Solved

how to create a table to send to a printer

Posted on 2006-06-24
6
153 Views
Last Modified: 2010-04-30
Hi Experts.

I've produced a form that I would like to print the fileds onto a table including borders and let the user select which printer they would like to send it to using the standard windows printer properties.

Your help will be much appreciated. If you need any more information please ask.

Many Thanks
Lee
0
Comment
Question by:ljhodgett
  • 3
  • 2
6 Comments
 
LVL 13

Expert Comment

by:Mark_FreeSoftware
ID: 16975456

do you develop in excel or in vb?
0
 
LVL 35

Accepted Solution

by:
[ fanpages ] earned 250 total points
ID: 16978005
Here's two examples in VB.NET:
[ http://www.vbdotnetheaven.com/Code/Jun2003/2093.asp ]
[ http://www.vb-helper.com/howto_net_list_printers.html ]

Sample code for VB:
[ http://www.freevbcode.com/ShowCode.asp?ID=3646#selectprinter ]


Also FYI:
"How To Set Which Printer Is the System Default Printer"
[ http://support.microsoft.com/kb/q266767/ ]

BFN,

fp.
0
 

Author Comment

by:ljhodgett
ID: 16978052
Hi.

I'm using vb6 to develop the program

Cheers

Lee
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 35

Expert Comment

by:[ fanpages ]
ID: 16978213
Then please look at the "Sample code for VB" link above.
0
 
LVL 13

Expert Comment

by:Mark_FreeSoftware
ID: 16978381

also take a look at this site, it has some useful links

http://www.thescripts.com/forum/thread14898.html
0
 
LVL 35

Expert Comment

by:[ fanpages ]
ID: 16982622
Thanks for closing the question.

Presumably one/more of the links proved useful.

BFN,

fp.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Enums (shorthand for ‘enumerations’) are not often used by programmers but they can be quite valuable when they are.  What are they? An Enum is just a type of variable like a string or an Integer, but in this case one that you create that contains…
Background What I'm presenting in this article is the result of 2 conditions in my work area: We have a SQL Server production environment but no development or test environment; andWe have an MS Access front end using tables in SQL Server but we a…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

895 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now