Embeded Macro

[Garry]

I have a form with a button. In design view when I select this button and go
to

properties

on click

embedded macros

...

Question, how do I switch off and then back on the confirm action queries

I have about twenty macros running from this one button and do not need
query reminders

Cheers

 

[Phil Hunt]

If you think your application can get functions then now, you should start
using module instead of macro. It gives you more control

 

[John W. Vinson]

I have a form with a button. In design view when I select this button and go
to





Question, how do I switch off and then back on the confirm action queries

I have about twenty macros running from this one button and do not need
query reminders

Cheers

If you insist on using Macros (rather than the more flexible and maintainable
VBA code - which is NOT really all that scary!!) - then put a macro line

SetWarnings False

before your queries. If you do so you must Must MUST!!! put a line

SetWarnings True

after the last query, otherwise you'll turn off all warning messages for
everything for the rest of the session.

It would be very easy to have VBA code on the button run your queries, using
the Execute method. This lets you trap errors in the queries and also
suppresses the prompts.
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com

 

[Garry]

I have delved into code and found it a bit daunting but by copying
and modifying other code all seems good

Thanks for pointing me in the right direction

Garry