Recent content by jhomeyer

I have two tables linked in a one to many relation for referential integrity. Using a form, I try to enter an id in the many table that does not exist in the one table. Naturally Access give me an error message just as I expect it to. I want to set up error handling so that when the invalid...

Wow! Thank you for this. This solved my problem which is in a separate thread.

May I have a copy You are doing exactly what I want to be able to do. I have a table with userids and their type of access to the database (administrator, date entry, reports only). When they first logon they will be presented with a logon form that must be filled out correctly or they will...

I want to use VBA to get the data from one record in a table and store the results in variable that I can use throughout the rest of the application. I have an unbound text box where the user enters the text I want to select on. I tried using the docmd.runsql to select the record but it only...