Expert
(513) 874-3306
We fix and repair laptop motherboard no video, no...
Answer
can we enter data in table through query calculation
Problem for Microsoft Office Access 2003 (077-02871) for PC
Data From Table Auto Fill
I have a database built. In the Form I enter a Center and in a seperate box the County it is in. When I send out my surveys each Center is assigned a number that is only for that Center. I want to speed up my data entry, so I'm wondering if there is a way to simply enter my assigned numbers so that when it is entered, it will come up as the specific County and Center for all of my reports. Can this be done with a query or a Macro? I figure I would have to build a spreadsheet for the program to reference but I don't know where to go from there.
Comments:
Apr 21, 2009
- Ok made the tables. Did the relationship. In the fields on the form I went into the properties and selected the same fields from each table for the Control Source. This didn't work. I tried putting the and in between the fields in the Control Source window and it didn't help. It gives me "#Name?" in all the fields when I run the form. Did I miss something? Also I did not see a way to make sure that the relationship goes from Main to Center table. This may be part of my problem too.Best Solution
posted on Apr 11, 2009
You need to create 2 tables. Create one table with just the Center Number, County and Center fields, using the Center Number as the primary key, lets call this table Center. Then create the other table with all the other fields you need, lets just call it the Main table for now.
Then create a relationship between the Center table and the Main table using the Center Number for the relationship. The relationship should be a One-to-Many from the Main to teh Center table. When creating the form, you take the fields from both tables. When you input the Center Number, the County and Center should be automatically filled in.
Then create a relationship between the Center table and the Main table using the Center Number for the relationship. The relationship should be a One-to-Many from the Main to teh Center table. When creating the form, you take the fields from both tables. When you input the Center Number, the County and Center should be automatically filled in.
Yes
No
Popular Solutions for Microsoft Office Access 2003
Questions and Unsolved Problems for Microsoft Office Access 2003
Do you recommend Microsoft Office Access 2003 (077-02871) for PC?
Answer
Answer
export report from acces 2007 to excel
Answer
different files. How do I do that
Answer
Hey everyone. Can anyone help me come up with a script that will allow me to import a text file...
(More)
Answer
I am getting the message "Module not found" after deleting a form that I no longer use...
(More)
Ask our Experts
Browse popular Problems
More Common Problems
Most Common Problems for:
For Microsoft Office Access 2003 ...:
Top Business and Pro... Experts
Experience:
I have owned a computer networking sales and service company.
Ask Me
Top Computer & Laptop Repair
Best Business and Productivity
Recommended by Owners
Recommended by Owners
