Search results

I tried this code but it didn't cycle through all the locations.

I entered this but received a Loop Without Do Error. Any suggestions? The only thing I changed was I removed the MsgBox so that the user wouldn't have to acknowledge each no data report.

I placed the following and still received an error on the first DoCmd.OpenReport line. I then tried the following and the same issue of all locations being printed on all reports and blank reports continuing to be exported occured. Is there a specific location within the cbVBA_Click() that it...

Each report had all locations listed and blank reports were still exported.

I have the below code to loop through multiple filters and export reports. I now am trying to add code to NOT export reports with no data. Because there are so many locations that these three reports are being filtered by I would prefer for this action to be done without the user having to...

That did it. Thank you so much.

Hello, I have applied some code (below) that will filter and export reports based on a table field value, locations. I have folders with each location as it's title. I am now trying to automatically have the report filtered to "Tampa" go to the Tampa folder. I have tried several ways but none...

Thank you for all the responses! I was able to set a looping filter and export action to one report so I am going to recreate with the other reports.

The closes I have gotten is the below code I found. It opened and exported a single report with all the different location names. However, the filtering portion did not work so it was the same location on all the exports. It would prompt for a parameter value at the beginning, and it would list...

Hello, Any help would be greatly appreciated. I have a database with the following components. Table1 - Applicant details, includes a text field for location. Table2 - List of locations Queries Source - Table1 Query1-With Human Resources Query2 -Pending Interview Query3-Offer Made Report1 -...