Search results

This explains quite a bit of the threads I read on the errors of incorrect syntax on their execute commands. Thanks for the information. Very helpful. Brent

Hello, Is there any particular reason I would choose to use DoCmd.RunSQL "insert into... Versus CurrentDb.Execute "insert into.... ?? I am using an unbound form on the front end of my database to populate the backend tables (multiple tables). Some forms only have a few fields, while...

Hello, Sorry, I was delayed at work longer than I thought. The form will be used for fire fighters to report infectious disease exposures. The incident table contains the basic information about the call and the person involved in the exposure. The exposure table will contain all the...

Hello, I have been working on a a table design, but I am failing to create the correct relationships. My main table is the tblIncident with the three remaining tables being linked via a one to many relationship. I am using an auto number as my primary key, then linking that number to a FK in...