make print macro to emmulate Ctrl+P

August 23, 2011 at 05:33:22
Specs: Windows XP
I have created a database using Access 2000 but am struggling to create a command button that once clicked opens up the printer box that you get when you press Ctrl+P. I have managed to create a button that will print to my default printer when clicked by creating an Event Procedure and using the following script in Visual Basic:

Private Sub Print_Click()

End Sub

I have several networked printers I need to be able to choose between can anyone give me the code i need to type in???

See More: make print macro to emmulate Ctrl+P

August 23, 2011 at 07:53:09
can you insert the commonDialogue control onto your project?

if so you can very easily use this to show you the Print Dialogue

Google vb or vba commondialogue

Report •

August 24, 2011 at 02:03:23
Thankyou for your reply, I have tried inserting the CommonDialogue control but even the coding on that will not emulate the ctrl+P printer box.

What I need, if it can be done is the code to put into an event procedure that will enable me to access the same window that Ctrl+P opens

Report •

August 24, 2011 at 03:24:18
Try this


Report •
Related Solutions

Ask Question