Recent content by puzzles7

Ok, will do.

Thank you, setting the SetWarnings to No Before each query took care of it. Thanks again.

I did use SetWarnings in my macro after each call to OpenQuery. I tried setting them both to Yes and then to No but neither worked. I am working on this report in 2003 version. I have never written in VBA so I'm not sure what I need to do to make that happen. Can you show me? Here's the...

They are all related to "You are about to run a Make-Table Query", "The existing table will be deleted", "You are about to write ### records to the table", "Youn are about to tun a detele query that will alter your existing table", "You are about to delete ### records from the table". I tried...

Unfortunately no. Is there a way using VBA that I can auto answer those modals that pop up related to Make-Table and Delete Queries?

Hi, I'm Patti and I work as a Business Analyst in Florida, US. I have used Access on and off throughout the last 15 years so I have a solid knowledge of Access and its capabilities but I struggle at times with the VBA code and macros. My current company uses both 2003 and 2007 versions of...

Hi, I designed a report to show all permanent people who DO NOT have a current evaluation based on a start date parameter. Because of our data structure I have to run a Make-Table query to create a complete list and then use the parameter in a Delete query to delete all records from the table...