Hide Message in Action queries

[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?

 

[Ken Snell \(MVP\)]

Use the SetWarnings action in your macro to turn off (or turn on) those
messages.

 

[Luciano]

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

Use the SetWarnings action in your macro to turn off (or turn on) those
messages.

 

[Luciano]

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

Use the SetWarnings action in your macro to turn off (or turn on) those
messages.

 

[Ken Snell \(MVP\)]

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>

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.

 

[Luciano]

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

 

[Ken Snell \(MVP\)]

I was just going to suggest this approach, based on feedback I received from
a person at Microsoft. Glad it's working.

 

[Luciano]

Hello Ken,
Thank you so much, your help was very helpful.
Luc