Action Query Notifications 1

[1DMF]

Hi,

Is there a way I can set the MS Access MDE to not show Action Query notifications?

I know you can go into MS Access Tools->Options->Edit/Find and take the tick out of Action Query to stop the notifications.

However, can this only be done on each users PC, or can I set this property somehow within the project?

Cheers,
1DMF.



"In complete darkness we are all the same, only our knowledge and wisdom separates us, don't let your eyes deceive you."

"If a shortcut was meant to be easy, it wouldn't be a shortcut, it would be the way!"

Google Rank Extractor -> Perl beta with FusionCharts

 

[vieirasoft]

Hi Try this

Application.SetOption "Confirm Action Queries", False
Application.SetOption "Confirm Record changes", False
Application.SetOption "Confirm Document deletions", False

Best regards from Portugal

 

[1DMF]

The project won't compile with "Invalid outside procedure"?

"In complete darkness we are all the same, only our knowledge and wisdom separates us, don't let your eyes deceive you."

"If a shortcut was meant to be easy, it wouldn't be a shortcut, it would be the way!"

Google Rank Extractor -> Perl beta with FusionCharts

 

[1DMF]

It's ok, It seems you have to put it on a form module.

I put it in the global module as I wanted it to just disable this when the globals and other declarations were defined.

Many thanks for your help, works a treat!

"In complete darkness we are all the same, only our knowledge and wisdom separates us, don't let your eyes deceive you."

"If a shortcut was meant to be easy, it wouldn't be a shortcut, it would be the way!"

Google Rank Extractor -> Perl beta with FusionCharts