Delete warning

J

juicegully

Hi,

When i run the delete command...

DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
DoCmd.DoMenuItem acFormBar, acEditMenu, 6, , acMenuVer70

what is the best way to suppress the delete warning?

There was an earlier post that said to use:
Docmd.SetWarnings False
<SQL delete statements>
Docmd.SetWarnings True

or else

dbEngine(0)(0).Execute "DELETE...", dbFailOnError

but these were when the Delete statments were SQL statements. Are either of
those lines okay to use with my delete statements?

Thanks
 
J

juicegully

Hi,

I tried it so my complete code is

Me.AllowDeletions = True
DoCmd.SetWarnings = False ' Suppresses the warning message
DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
DoCmd.DoMenuItem acFormBar, acEditMenu, 6, , acMenuVer70
Me.AllowDeletions = False
DoCmd.SetWarnings = True

I get the following error:
"Compile error: Argument not optional"

Any ideas?

Thanks
 
M

Michael J. Strickland

--
---------------------------------------------------------------
Michael J. Strickland
Quality Services [email protected]
703-560-7380
---------------------------------------------------------------
juicegully said:
Hi,

I tried it so my complete code is

Me.AllowDeletions = True
DoCmd.SetWarnings = False ' Suppresses the warning message
Click to expand...

No equal sign, the syntax is:

DoCmd.SetWarnings False
 
J

juicegully

Thanks
I should've read it more throroughly


Michael J. Strickland said:
--
---------------------------------------------------------------
Michael J. Strickland
Quality Services [email protected]
703-560-7380
---------------------------------------------------------------


No equal sign, the syntax is:

DoCmd.SetWarnings False
Click to expand...
 
Top