March 16, 2008 at 3:44 pm
Hi all,
Sorry if this is a bit off topic, but am in need of some expert guidance!;) I am sure that you guys would complete this task in no time at all, in a variety of ways, but with my limited knowledge I am having some difficulty!
I have a table (sales_price_list) that I want a user to easily maintain, and insert records. There are also additional tables (customer, product) that hold info that I need to call on to add filters etc.
I have tried using a "data access page" that I came across in MS ACCESS, which I have used to group the data by sales_price_list, and product. This looks exactly as I would hope, and gives the user the ability to modify specified fields without problems. This is 95% of the way there, but I am stuck on 1 point:
When inserting data (eg price, start_date, end_date) and saving, I cannot get it to carry the group details values, meaning that no sales_price_list or product details are entered into the line.
-----------------
To sum this up, I haven't read many positive things about "Data access pages", whilst I hope they can do job, I know they have some restrictions. If anyone can help me with this, or recommend a simple alternative solution please let me know!
Thanks in advance!
Andy:)
March 17, 2008 at 11:44 am
Andy,
It has been a while since I looked into using MS Access as a front end. You might consider building a Form in Access, that is based on your table, to give the user the ability to insert data to your SQL Server table. If I am way off here, please provide more detail.
Hope This Helps,
"Key"
MCITP: DBA, MCSE, MCTS: SQL 2005, OCP
March 17, 2008 at 11:53 am
You also may need to force refreshing your query. You may find that it doesn't show things quite as aggressively as you'd like. (Assuming I'm understanding exactly what you're getting at). In other words - just adding a value that links the recrod to a separate reference isn't going to make the related fields auto-populate, you may need to force a requery to make sure your formed "refreshes".
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply