|
Subject:
|
Disable or Hide Prompts?
|
|
Posted By:
|
LiamBFC
|
Post Date:
|
4/19/2006 6:17:58 AM
|
Is it possible to disable or hide the append query prompt when you run an insert statement from a form in Access?
Liam Gulliver,
http://p2p.neopian-hosting.com
A New Programming Chat Forum
|
|
Reply By:
|
mmcdonal
|
Reply Date:
|
4/19/2006 6:46:36 AM
|
Before the code that runs the query, put this line:
DoCmd.SetWarnings False
Then after the query line put:
DoCmd.SetWarnings True
Please note there is no "=" as there might normally be when using a boolean.
HTH
mmcdonal
|
|
Reply By:
|
LiamBFC
|
Reply Date:
|
4/19/2006 7:54:16 AM
|
Thanks, worked like a charm.
Liam Gulliver,
http://p2p.neopian-hosting.com
A New Programming Chat Forum
|
