S
smashing_austin
Hi All,
I'm using MS Access 2003 (SP1) and am having a terrible time doing
something that seems very simple!
All my system messages are suppressed, and I know this because any
change I make to a query/table (etc) is automatically saved without
any prompting. Also, any action queries are automatically run without
being prompted "You are about to delete xx rows etc". In the Tools ->
Options -> Edit/Find tab, the boxes are ticked to True for Record
Changes, Document Deletions and Action Queries.
I want to turn system messages back on to understand the errors I am
having with a particular Append query, however I can't seem to do it!
I have created a new module in VBA, and created the following sub:
Sub Test()
Docmd.Setwarnings True
End Sub
Even after running this sub above, system messages refuse to turn on!
There seems to be no way to turn them back on again. I can't find any
articles in KB or in Google Groups, and I am absolutely baffled!
I would really appreciate any help - Cheers, Angela
I'm using MS Access 2003 (SP1) and am having a terrible time doing
something that seems very simple!
All my system messages are suppressed, and I know this because any
change I make to a query/table (etc) is automatically saved without
any prompting. Also, any action queries are automatically run without
being prompted "You are about to delete xx rows etc". In the Tools ->
Options -> Edit/Find tab, the boxes are ticked to True for Record
Changes, Document Deletions and Action Queries.
I want to turn system messages back on to understand the errors I am
having with a particular Append query, however I can't seem to do it!
I have created a new module in VBA, and created the following sub:
Sub Test()
Docmd.Setwarnings True
End Sub
Even after running this sub above, system messages refuse to turn on!
There seems to be no way to turn them back on again. I can't find any
articles in KB or in Google Groups, and I am absolutely baffled!
I would really appreciate any help - Cheers, Angela