Hi All,
I use Access 2013 to calculate and generate PDF commission reports for each individual employees. These reports are saved individually to a temporary location on the drive. I need help on creating a VBA module to achieve the following:
- Email these reports to the respective employees...
Just an update for people who are trying to accomplish this in the future. I've decided to create a temp table to store my report data instead. Turns out it runs faster because it doesn't need to rerun the query for each report group.
If it helps, I'm trying to modify the VBA code posted here:
ttps://access-programmers.co.uk/forums/showpost.php?p=1264731&postcount=24
ttps://access-programmers.co.uk/forums/showpost.php?p=1049034&postcount=10
This code worked if I already had a table with all the information I needed on the...
Hi all,
First time poster and beginner here.
I'm having an issue with a some VBA I'm trying to piece together to export individual reports to PDF by employee ID. The report is based on a query (qryMnthlyCommSumm) and the issue I'm having is passing the criteria to the query. There are 2...
Hi everyone! My name is Bryan and I'm a beginner in Access looking to learn as much as I can to increase my productivity at work and eventually pay it forward!