Recent content by Bob-THG

Do you mean select the row that an action is on and then click Show All Actions? ----- Ok, I just decided to write a VBA function that does a DoCmd.Setwarning(WarningsOff) and do a RunCode of the function at the top of the Macro. Sorry for being so Old School and dense.

You would first have to link the excel file into Access. Then it looks and acts like a table. From there you just write and run queries against it. *** Tip - Make sure it is a clean data file. All column headers are properly named without special characters. No subtotals and totals. If you...

I must be dense as well. I went to the design tab in Access 2007. Clicked the Show All Actions button so it was highlighted. Save and ran the macro. The result was that the warning messages all ran for each query executed. So I clicked the button so it wasn't highlighted any longer. Saved and...