Hide Message in Action queries

Hide Message in Action queries

Post by THVjaWFub » Tue, 29 Jan 2008 03:29:01


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?

--
Luc Ringoir
Belgium
 
 
 

Hide Message in Action queries

Post by MV » Tue, 29 Jan 2008 03:47:59

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

--

Ken Snell
<MS ACCESS MVP>

 
 
 

Hide Message in Action queries

Post by THVjaWFub » Tue, 29 Jan 2008 11:03:00

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
 
 
 

Hide Message in Action queries

Post by THVjaWFub » Tue, 29 Jan 2008 11:24:01

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
 
 
 

Hide Message in Action queries

Post by MV » Wed, 30 Jan 2008 12:40:10

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>
 
 
 

Hide Message in Action queries

Post by THVjaWFub » Wed, 30 Jan 2008 14:31:17

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
--
Luc Ringoir
Belgium
 
 
 

Hide Message in Action queries

Post by MV » Thu, 31 Jan 2008 12:06:53

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

--

Ken Snell
<MS ACCESS MVP>
 
 
 

Hide Message in Action queries

Post by THVjaWFub » Fri, 01 Feb 2008 05:59:01

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