Recent content by pjg34711

Bob and Paul, Thanks for your guidance. I think I've solved the problem. Paul G.

Thanks, Bob. It works. Paul

Hi, I'm still on my quest to enter a file name for a file I will later output to my computer. This is my current test code (whithout the inputbox segment) - Function CopyQuearytoSdriveFolder() Dim MyValue As String MyValue = "mm_dd_yyyyQTMsQuery.xls" DoCmd.OutputTo "acOutputQuery"...

Thanks, Sean. I'll try that. Paul (pjg34711)

Thanks, Paul. It seems that the PDF version is the best route since pulling the data from our HRIS system at a later date, even if the date parameters are the same will usually result in a slightly different population. Thanks again, Paul (pgj34711)

I need to run a standard report, but need to save the new results with a date-specified name. Can I use VB to request the user to enter a new name and use that name for the copied report?

I believe that whenever I open a query, the query refreshes, thus giving me new data. Can I stop a query from refreshing at open so that the data I've used in executive reports are always available?

I tried the inner join. That seems to give me the data I needed. Thanks again to both Pat and Accessensible.

Thanks, Accesensible and Pat, I try the non-VBA solution first ( not too skilled in VBA yet).

I need to compare records in a table to a table of active records so that I can only choose actiive records from the initial table. Any help would be greatly appreciated!

Just joined and am looking forward to getting and sharing information.