Comments on Alex & Access: How to undo whole record

Or you could put in VBA:DoCmd.SetWarnings (False)....

2008-06-20T16:54:00.000+04:00

Or you could put in VBA:

DoCmd.SetWarnings (False)
...here comes your 'undo' code
DoCmd.SetWarnings (True)

_ _ _ _ _ _ _ _ _ _ _ _
this way you would have the warnings only temporarly inactive.

ya that works :)tools > options > Edit/Find > Conf...

2007-06-14T19:39:00.000+04:00

ya that works :)

tools > options > Edit/Find > Confirm (Uncheck Record Changes option)

thanks for your "prompt" reply :)

Hi,you can switch off delete prompts in access opt...

2007-06-14T18:34:00.001+04:00

Hi,
you can switch off delete prompts in access options

i was wondering if we can bypass the prompt for de...

2007-06-14T12:51:00.000+04:00

i was wondering if we can bypass the prompt for deletion

i mean, if there was no prompt before deleting the record, the undo operation would have looked more realistic :)

any thoughts?

Very useful, thanks. I was strugling with undo on ...

2006-06-30T17:56:00.000+04:00

Very useful, thanks. I was strugling with undo on a form with both bound and unbound controls and couldn't get the "DoCmd" to work properly. But this code does the trick.