Make-Table Warning Messages

reidynem · August 17th, 2011, 06:49 AM

I am having a problem with my work database because due to the complexity of the queries / macro's etc...whenever I run the update button a vast number of warning messages pop up.

The button is linked to a macro which runs 6 make-table queries.

The problem I have is because I did not create the database, I have no idea where to start to turn these warnings off.

On investigating, I am told that the following code would sort it out, however, I have no idea where to put this code!

Private Sub cmdRunMakeTable_Click()
DoCmd.Hourglass True
'Turns off the Access warning messages
DoCmd.SetWarnings False
DoCmd.OpenQuery "mktqry_MakeNewTable"
DoCmd.Hourglass False
'Turns the Access warning messages back on
DoCmd.SetWarnings True
End Sub

I did try and put the code into the SQL each query but SQL does not appear to like this Syntax.

If anyone could help me, that would be appreciated.

gjgriffith · August 17th, 2011, 12:09 PM

Hello reidynem,

Thank you for posting your question about Access. Specifically, you asked:

Quote:

The button is linked to a macro which runs 6 make-table queries. ... On investigating, I am told that the following code would sort it out, however, I have no idea where to put this code!

Ok, so in this case, in your macro, you can just disable the warnings through the macro, instead of through code. Specifically, before you call the make table queries, first call the macro "SetWarnings" and set it to the value "False". Then, after the queries are run, call the "SetWarnings" macro again and set it to "True" to re-enable the warnings. Does this make sense?

Hopefully that answers your questions, but if there is anything else i can do to help, please let me know!

Thanks,

reidynem · August 18th, 2011, 03:28 AM

thanks so much, all sorted!!

gjgriffith · August 18th, 2011, 10:26 AM

Hello reidynem,

Awesome, I'm so glad to hear that using the SetWarnings Macro to disable and enable warning messages in Access worked for you! The SetWarnings functionality is certainly useful in both VBA code and Macros! And if there is anything else i can do help, please let me know...

Cheers,

reidynem · August 22nd, 2011, 10:13 AM

well now you come to mention it gjgriffith, I would like some further help if possible?!

I have a union query which is all our open orders and I would like to display these on a calender in a form. I know how to get a calender in the form design view but I do not know how to a) link it to a query or then b) make the orders appear in the various dates on the calender.

What I am ultimately aiming for is to be able to see at a glance, what orders are due when.

Thanks!