Warning Message

[aftabn10]

Hi, I have created a query to add some data into an existing table.

To automate this I have created a macro to run this query when required, however what I would like to do is to add a warning message "Are you sure you want to add new data" but i am not sure how to do that.

The reason being is that if somebody clicks the add data button in error, then this will mess the tables up.

If somebody could please help.

Thanks in advance.

 

[Access_guy49]

For the button on your form that runs the update query..

If msgbox "Do you want to continue", vbyesno = vbyes then
  'Run your command here
else
exit sub
endif

 

[vbaInet]

I don't really use macros but you can achieve this easily using VBA. If I remember rightly you know some VBA?

 

[aftabn10]

Thats rite, I do. Using Access 2007, which has the Actions and Conditions and was wondering if there was a way to write the query within their?

Access_guy49 thanks for your reply, will try that out...

 

[vbaInet]

Remember to enclose the msgbox paramter in brackets (using Accessguy49's code):

If msgbox("Do you want to continue", vbyesno, "Insert confirmation") = vbyes then
       'Run your command here
else
        Msgbox "Action cancelled"
end if

No need to exit sub. You can decide whether or not to include the Else statement.

 

[Access_guy49]

Thanks for catchin that vba!

 

[vbaInet]

No worries

 

[Matoco1]

I use a macro condition to ask the use if the user has loaded headed paper. this bit goes in the condition box of the top action and any other actions below that should be condition ...

Msgbox('Haeded paper loaded?',1)=1
...
...

hope this helps