Closed

MS Access VBA Function

This project received 11 bids from talented freelancers with an average bid price of $137 USD.

Get free quotes for a project like this
Employer working
Skills Required
Project Budget
N/A
Total Bids
11
Project Description

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

'***************************************************************************************************
Notes:
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.

Peter

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online