By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,850 Members | 972 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,850 IT Pros & Developers. It's quick & easy.

setting up Data Access Page

P: n/a
I must warn all of you willing to help me that this is my first go at
designing a functional data access page. Please bear in mind that we
all start somewhere so if I should be asking the absolute dumbest
questions you've heard in a while remember I'm not the first. I am
specifically looking for step by step direction. I also feel I must
make you aware of my dedication. You see, I need to complete this
project to get a nice bonus for Christmas. I have a 3 year old
daughter that needs new clothes, new supplies for school, and overall
something better than whats left over after I have paid all of the
bills. If you have made it this far, thank you in advance! I
sincerely appreciate it. (Did I forget to mention deadline of
11/18???? Hope you like a challenge as much as I do:)...)
OK. I have sucessfully created and maintained a very useful database
(A2k3) for a large project my company has undertaken. Not very
complicated at all and few relationships. Currently 4 total users on
a split database... Being a victum of my own brainstorm, I now have
been asked to add additional user and client DAP interfaces allowing
such users and clients to update the table data.
I assume learning how to design and implement one with your help will
yeild the knowledge to continue on with the less important ones to
come. The most important DAP is going to be for our "production
status"
I have the following fields I want users to update:
(alot more tables and relationships than shown....just thought I'd
keep it simple for my first DAP)
Table 1 Table 2 (Contains Multilple related
_______ _______ to Location ID)
Order # (Primary key) Location ID
Location ID Location Item #
Sort key (text)
Existing Product (text)
Proposed Product Type (text)
Proposed Product Item (text)
Proposed Description (Text)
Is our Product? (true/false)
Released to Production (true/false)
Production Start Date (date)
Fabrication (true/false)
Plastic (true/false)
Paint (true/false)
Graphics (true/false)
Production Comp Date (date)
Production Comments (memo)

Fuctionality needed:
Users need to be able to look up by Order # or Location ID (latter not
integral)
Users to wiz bang button filter records by start date,Completed date,
sort key, and product type.
More specifically Completed Date and Start date by
"is null
and is not null."
Sort key and Product Type by user defined paremeter
value
Users to be able to update values and dates in the database tables
over the intranet via a DAP while myself and 3 others are using the
Database in the Access forms I have created.
I have met no success with use of the wizzard and my "How to Do
Everything with Access" book has failed me miserably with the data
access page. Really wish I had the time to open a new how to manual
for Data Access pages...but as you will remember from above I have a
deadline og 11/18. Please be patient with me. I sincerely appreciate
all of the help I can get with this. I'm sure my daughter will too.
Thanks in advance! and Kind Regards,
Joseph A.K.A., Manystrengths (except with DAP's :)
Nov 13 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.