Hide Message in Action queries

  • Thread starter Thread starter Luciano
  • Start date Start date
L

Luciano

I converted an Access 2007 database into an Access Runtime application. In my
autoexec-macro, I have some action-queries. I turned off the checkboxes
Confirm (Record Changes – Document Deletions – Action Queries).’
However when I run this Runtime application (.accdr) I still get the
messages : You are about to run an update query that will modify data in your
table’. How can I avoid this messages?
 
Use the SetWarnings action in your macro to turn off (or turn on) those
messages.
 
I used these warnings in the Access 2007 .accdb mode and this is OK; but when
I converted this accdb database into a Runtime-application ( .accdr) these
messages appear again.
--
Luc Ringoir
Belgium


Ken Snell (MVP) said:
Use the SetWarnings action in your macro to turn off (or turn on) those
messages.
Click to expand...
 
I have this problem not on my own ccomputer, but on another computer that
don't have Access 2007 when I installed my Runtime-application.
--
Luc Ringoir
Belgium


Ken Snell (MVP) said:
Use the SetWarnings action in your macro to turn off (or turn on) those
messages.
Click to expand...
 
I don't have another suggestion for you, sorry. Let me see if i can get
someone with excellent knowledge about ACCESS 2007 to jump into this thread.

--

Ken Snell
<MS ACCESS MVP>


Luciano said:
I have this problem not on my own ccomputer, but on another computer that
don't have Access 2007 when I installed my Runtime-application.
Click to expand...
 
I converted my autoexec-macro (containing the action- and delete-queries)
into a VBA-Subroutine where I use te command 'Docmd.Setwarning False' and now
it seems to work!
Thanks
 
I was just going to suggest this approach, based on feedback I received from
a person at Microsoft. Glad it's working.
 
Back
Top