Search results for query: *

I used ADO instead and was able to detect when a record was successfully inserted, but now I can not delete or modify the inserted records using access. Every time I tried to delete or modify the newly inserted record, the command would get cancel since Access thinks that some one else is...

Perhaps someone can help me with a problem I am having. Here is my situation, I am using access as a front end to a mysql database, using the odbc-mysql version 5.1 connector. I have some code that use a DAO connection object to insert new records into the database. To verify that the record was...

On further testing, the on error capture event did not work. The other possibility was to locked or hide the subform until data is entered into the form does work, but not what I required. One way that work was to synchronize the parent and child form by VBA code, this prevented the pop...

Thanks Duane! It turns out, I was able to catch the error in the subform error event.

To clarify, what I meant to say is enter the child data fist into the subform without creating a record for it. Just entering data into the subform pop up the message. Why would people enter data into the subform first? Some one who knows how the tables are related would probably never enter...

Greetings! Here is my situation. I have two forms in a parent and child relationship, with the child form contained in the parent. When the forms first open up, they are blanked for data entry. If I try to enter some data into the child form, before entering any data into the parent a message...

Ah that work! Thank you so much!

I am relative new to access, and was wondering if it is possible to filter a records by detecting if a certain field is a null? Here is my situation. I have a query that is a left outer join between table1 and table2, but some time I need to have an inner join between the two tables. I thought...