L1l_m5_P1gg13
New member
- Local time
- Today, 22:32
- Joined
- May 14, 2020
- Messages
- 7
Hello All,
I am hoping to get some help with VBA to print a label in Access.
I have an Access Report that pulls through a Serial Number and an IMEI Number, using a query parameter the user is asked for a serial number. Once this is entered the serial number and corresponding IMEI populate onto the report.
What I am trying to achieve is, when the user clicks the OK after entering the serial number (the query parameter) the OK runs code to populate the report and print automatically, then clearing the Report ready for the next serial number to be entered.
I know through VBA I can get this done, but I haven't seen how I could incorporate this into the parameter value section.
Any help would be greatly appreciated! Thank you
I am hoping to get some help with VBA to print a label in Access.
I have an Access Report that pulls through a Serial Number and an IMEI Number, using a query parameter the user is asked for a serial number. Once this is entered the serial number and corresponding IMEI populate onto the report.
What I am trying to achieve is, when the user clicks the OK after entering the serial number (the query parameter) the OK runs code to populate the report and print automatically, then clearing the Report ready for the next serial number to be entered.
I know through VBA I can get this done, but I haven't seen how I could incorporate this into the parameter value section.
Any help would be greatly appreciated! Thank you