MS Access VBA Function


I need to print directly to a Dot Matrix printer from MS Access 2003. The paper is continious feed and I need to print line by line. Access reports will only print by page and the Epson LQ680 does not have the correct length paper to select.

On each line there will be variables and I will need to be able to position each variable in the line either by spaces or position. As I see it it would look some thing like:

Dim Line1 as string, var1 as string, var2 as string

var1 = "Vancover Airport"

var2 = "7684 5674 3242"

Line1 = " " & var1 & " " & var2

' *** Your part *********************************************************************************

Print Line1 to dotmatrix printer and roll up one line ready for next line of print



1. There will be approx 30 lines on each label I can loop until the end of the label as required.

2. Must be able to select the correct printer by name

3. I must be able to set the default Font and size,

I will also pay if there is a better way of doing this.


Skills: Microsoft Access, Visual Basic

See more: access vba function, access function, access 2003 print dot matrix, vba access print dotmatrix, printer epson vba access, access print dot matrix printer, access vba position line, access font printer dot matrix, print dot matrix vba access, up string, access vba print dot matrix, vba for, print vba, microsoft vba, in vba, end vba, ms access 2010, roll up, Pay roll, ms access, MS Access VBA, microsoft access vba, airport, ACCESS VBA, access microsoft

About the Employer:
( 8 reviews ) Mulgrave, Australia

Project ID: #760148

11 freelancers are bidding on average $137 for this job


Greetings.. {smile} 25+ years of hard core MsAccess and Windows programming experience. I have set up Epson LQ continuous form label printing before, but that was 9 years ago. Hopefully not to much has changed since More

$65 USD in 1 day
(19 Reviews)

You should set the printer as an output device by using OPEN DEVICE_NAME FOR OUTPUT AS #1. Where DEVICE_NAME is LPT. Simply send the string you want to print. And for default font and size, you could get it from VB6 Pr More

$200 USD in 1 day
(5 Reviews)

Good day, my name is Michael P. Morrissey, Mike for short, and I have been programming with Visual Basic 6.0 for almost 13 years now. During my career with programming with VB, I have done more than my fair share of VB More

$150 USD in 14 days
(1 Review)

I have 20 years experiences in VBA programing.I will do done your project.

$50 USD in 0 days
(0 Reviews)

I can help because I was working on a similar project several years ago and several months ago with EpsonLQ printers, paper form continues

$46 USD in 1 day
(0 Reviews)

I m from India, working with windows, sql server, access, vb6,,C, C#, Crystal Reports, foxpro since 1994, I have developed many projects like inventory, accounting, payroll, hotel management, School Fees Collect More

$200 USD in 7 days
(0 Reviews)

Hi i am interested to work in this project. Regards Lakshmi

$30 USD in 30 days
(0 Reviews)

can i help you?

$190 USD in 1 day
(0 Reviews)

I am a systems engineer working programmer developing applications for VIBA visual basic and now I application for medical research in CIDEIM (international center for training and medical research) More

$195 USD in 8 days
(0 Reviews)

Hello Madam/Sir, We are a group of software professionals and posses more than five years of industry experience. We look forward to work on your project and assure you on time delivery with high quality and customer More

$250 USD in 5 days
(0 Reviews)

Hi, we are working with .net since 2005, here i am sending some screen short to view and take decision. please reply me back for next proper step. bye

$130 USD in 15 days
(0 Reviews)