using a query to insert data in a fo_rm

[BSY]

Edit

is unable to insert data to database.

 

[Galaxiom]

What error is raised?

 

[BSY]

What error is raised?

This is the error

 

[John Big Booty]

That all looks pretty standard (you can turn those warnings off if you wish), when you answer yes to the second dialogue box, does it Append the one record, as advised? or is there another error?

 

[BSY]

That all looks pretty standard (you can turn those warnings off if you wish), when you answer yes to the second dialogue box, does it Append the one record, as advised? or is there another error?

no error , can insert all the data , how to turn off the warnings ？

 

[John Big Booty]

From your screen shots, I'm guessing you are using Access '07, so click on the Circular button in the very top left hand corner of the window, and click Access Options, now got to the Advanced menu, under Editing look for Confirm, uncheck Action queries.

 

[MyTech]

DoCmd.SetWarnings False

 

[boblarson]

If you use DoCmd.SetWarnings False, make sure to put

DoCmd.SetWarnings True

in the EXIT path of your procedure where you used false. Otherwise you may find yourself with a problem later on and strange things will occur.

Most of the time we suggest using

strSQL = "SQL string goes in here"
CurrentDb.Execute strSQL, dbFailOnError

because that doesn't require you to turn off anything and you don't get confirmations.

 

[MyTech]

Bob, thanks forn the strSQL idea.

 

[BSY]

Thanks for the information , reply and teaching ~
learning many for u all ^ ^

 

[John Big Booty]

Glad to have been able to help