Hello, this post is related to prior messages 92397 and 91663. I use Access 2007 and my experience level is beginner.
I created a simple time tracking database for my group at work. It makes a list of daily tasks performed by a user and creates a few simple reports. I saved it as TimeTool_old in the PTS Time Tool folder. The following ID's and Passwords can be used to login to see how it works and what I am trying to do.
EmployeeID Password
Ahfong staff1
Griffis staff2
Suggs manager1
As it is, the tracker looks and works exactly like I want. My boss loves it and wants to begin using it as soon as possible. However, there is a problem I want to fix before it is used: I am not able to synchronize the customer and product combo boxes on the data entry form. The reason is because my tables and relationships are flawed (see messages 92397, 91663). I will be using the suggestions and code on the following link when I try to synchronize the combo boxes:
http://msdn.microsoft.com/en-us/library/bb404901%28v=office.12%29.aspx
To fix the problem, I decided to follow the suggestions in the prior posts and redesigned the tables. I created a new database called TimeTool_new. I would like someone to please check my tables and relationships to see if I am on the right track before I go further.
Once my tables are correct, I need help recreating the data entry form to look and function exactly like the form in the old DB. I am having a very difficult time doing that. I have spent several hours trying to recreate the form, with no luck. There is a blank form called FrmDataEntry in the new DB. Please help me add fields to this form to look and function just like the form in the old DB. It was a fluke that I got it to work in the old DB. I simply tried different things and copied elements from a previous database until it worked, although I didn't know what I was doing.
There are some basic concepts involved in creating tables, queries and forms that I don't understand and need to learn, such as: When does a table's ID field need to be included when creating another table, query, or form; and is it selected instead of, or along with, the data field? For example, when selecting fields from the Customer table, is the CustomerID field selected along with, or instead of, the Customer field?
Another question is: Should the source records for my new data entry form (FrmDataEntry) be created from tables, a query, or both, and what fields are needed?
What I am trying to do with my DB is very simple, and it is driving me batty that I am having such a hard time getting it to work. I'm sure your suggestions will give me a better understanding of what to do. Feel free to modify the tables and relationships in the new DB. I appreciate any help you can give me.
Thanks,
Brad
Tidak ada komentar:
Posting Komentar