No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
10 Posted Topics
In the expression IIF[SSN]=50,99,[SSN]) when I enter 60, all works well. But if I enter 50, I get "The value entered doesn't meet the validation rule for the field or control". BTW, SSN is defined in the table as Number (Long Integer). What's the problem?
You must select the desired record using a key to the table(s).
You have a loosly worded problem. Hire a tutor for 2 hours and you'll have the answer quickly. It sounds like you do not getting a match between the tables you're trying to read. But if you don't understand SQL at all then you're in trouble from the start. The …
Form1 searches table1 for a key. Go to Form2 and store key (not visible). Then read table2 using this key. If NO match, just enter new data and close Form2 to save to table2-this works ok. But if there IS a match, click on NEW Record icon at top of …
Form1 searches table1 for a key. Go to Form2 and store key (not visible). Then read table2 using this key. If NO match, just enter new data and close Form2 to save to table2-this works ok. But if there IS a match, click on NEW Record icon at top of …
I have successfully created a command button on a form to do a search on a primary table for a key, entered data on the form and saved it into a second table. However the key for that second table does NOT get saved (but does show on the form). …
Please tell me the necessary code to read a first table for information then search a second table. If no match, add a new record to the second table. Thanks!
Google the error message (without the number in paranthesis) and you'll see.
If this is NOT in Access, then you need training. Also, are you comparing the first column (first 4 characters) in the first file to the first column (first 4 characters) in the second file? If yes to both: 1. Import both Excel files to tables (A and B). 2. …
The End.