ouestque
asked on
Access:VB:Printing Form code
I have multiple forms that are designed to be printed if I open them and go to FileàPrint. What is the Access VB I could use to open select forms and get them to print.
i.e. There are 4 forms frm_student1587, frm_student2122, frm_student344, frm_student444. The user prints 3 of them.
forms![ frm_student1587].print
forms![ frm_student2122].print
forms![ frm_student344].print
i.e. There are 4 forms frm_student1587, frm_student2122, frm_student344, frm_student444. The user prints 3 of them.
forms![ frm_student1587].print
forms![ frm_student2122].print
forms![ frm_student344].print
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Theroretically then, could I write a VB sub that would allow a user to choose a number of forms i.e. 100. and follow the following procedure---> open form1--print--close form1. open form2--print--close form 2 etc... to how ever many forms chosen?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Do you know the VB I would use to get it to print a form? When I go to print preview, it looks exactly like I want it, I just need the VB syntax to continue.