Hello everyone,
I'm pretty green with Access, but, do have some basic coding background. I'm trying to create a very simple form where a user inputs data including number of copies, presses a print button and the form(s) print out which will be used as load flags to identify product ran on a machine. I do not need many different records - in my mind I'm thinking just one (?). I need for a user to open the form, enter their data and press print so the data they just entered is generated on a report and then printed to be used as a load flag. Basically, all I've done was create my table, form and report. When creating my form I used the "Add existing Fields button" and dragged the fields to my form for user input. I then created 3 buttons - a "Clear" button which sets all fields to " " (blank), a "Print" button and an "Exit" button. I then generated a Report the same way, using the "Add Existing Fields" button. However, I am not sure what code or Macro to write so when the "Print" button is pressed, the values that were just entered by the user are passed to the report, generate the report and then print the amount of pages entered by user.
Example of the fields I am using:
OperatorInitials
JobNumber
PieceCtn
CartonPlt
CartonWeight
LoadNumber
I am also having a hard time finding a way to serialize or number each sheet printed so the "load flags" print with a Load Number on them. It would have to be a number field that increases by 1 with each print out.
Thanks all and I'm hoping the best for help with this!
I'm pretty green with Access, but, do have some basic coding background. I'm trying to create a very simple form where a user inputs data including number of copies, presses a print button and the form(s) print out which will be used as load flags to identify product ran on a machine. I do not need many different records - in my mind I'm thinking just one (?). I need for a user to open the form, enter their data and press print so the data they just entered is generated on a report and then printed to be used as a load flag. Basically, all I've done was create my table, form and report. When creating my form I used the "Add existing Fields button" and dragged the fields to my form for user input. I then created 3 buttons - a "Clear" button which sets all fields to " " (blank), a "Print" button and an "Exit" button. I then generated a Report the same way, using the "Add Existing Fields" button. However, I am not sure what code or Macro to write so when the "Print" button is pressed, the values that were just entered by the user are passed to the report, generate the report and then print the amount of pages entered by user.
Example of the fields I am using:
OperatorInitials
JobNumber
PieceCtn
CartonPlt
CartonWeight
LoadNumber
I am also having a hard time finding a way to serialize or number each sheet printed so the "load flags" print with a Load Number on them. It would have to be a number field that increases by 1 with each print out.
Thanks all and I'm hoping the best for help with this!
