Link to home
Start Free TrialLog in
Avatar of ouestque
ouestqueFlag for United States of America

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
SOLUTION
Avatar of Jim Horn
Jim Horn
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of ouestque

ASKER

I agree!  But with my situation I really need it to print a form. :)

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.
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial