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()
'Turns off the Access warning messages
'Turns the Access warning messages back on
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.