Every month I have to print some reports for different cities. As you see in picture. I have to select every city and print them. Can anyone help just once push the button and reports for each cities print separately and convert to PDF. Thank you.
Every month I have to print some reports for different cities. As you see in picture. I have to select every city and print them. Can anyone help just once push the button and reports for each cities print separately and convert to PDF. Thank you.
This and the related looping code should get you started.
http://www.granite.ab.ca/access/emai...recipients.htm
You'd want to output to PDF rather than email.
I tried but it doesn't work. Thank you anyway. I need more help If anyone can?
I've used the basic technique a number of times; it works well. More than likely you made a mistake implementing it.