DBase Update Confirmation Window.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Greetings;

Is there away to ignore the update window you get while running a Query or SQL statement?

<You are about to Delete 1 Record> or
<You are about to Append 1 Record>

What I have is a few buttons on a Main Menu that swap data between Dbases and would not like the user to see these additional statements. I know it is hard coded into the engine, but I'm hoping there is away to auto confirm using VBA.

Sincerely;
~Lethoric De'clree
 
Put DoCmd.SetWarnings False before your Query or SQL statement and
DoCmd.SetWarnings True after your Query or SQL statement.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com


Lethoric said:
Greetings;

Is there away to ignore the update window you get while running a Query or SQL statement?

<You are about to Delete 1 Record> or
<You are about to Append 1 Record>

What I have is a few buttons on a Main Menu that swap data between Dbases and
Click to expand...
would not like the user to see these additional statements. I know it is hard
coded into the engine, but I'm hoping there is away to auto confirm using VBA.
 
Back
Top