Disable or Hide Prompts?

LiamBFC · April 19th, 2006, 06:17 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

mmcdonal · April 19th, 2006, 06:46 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

LiamBFC · April 19th, 2006, 07:54 AM

Thanks, worked like a charm.

Liam Gulliver,
http://p2p.neopian-hosting.com
A New Programming Chat Forum