PDA

View Full Version : To delete rows without getting the warning message



mud2
05-19-2005, 09:25 AM
How do I purposely delete some or all of the rows of a table without getting the warning message?
AND, where do I find the "Solved" key after this problem is solved? I found it once but now I can't.

OBP
05-19-2005, 12:41 PM
Question 1 - Try turning off system messages with - DoCmd.SetWarnings False
This will turn off all warning messages! You need to turn them back on again with - DoCmd.SetWarnings True
Question2 - look in the Thread Tools tab at the top of the Forum page.

xCav8r
05-19-2005, 08:53 PM
If you do this with ADO or DAO, you won't get any warnings. ;)

Which can sometimes result in a super DOH!

Norie
05-20-2005, 10:14 AM
Can you not just goto Tools>Options... and uncheck Record Changes in the Confirm section on the Edit/Find tab?