Cheque Printing using VB6 and Access Database

Cheque Printing using VB6 and Access Database

1 Answer

1

Hi Siva66721, and welcome to ChatGO! :dog_face: Building a cheque printer with Visual Basic 6 and Microsoft Access is a classic, practical project!

Here is how you can set it up:

1. Database Setup (MS Access)

Create a table (e.g., tblCheques) with these fields:

  • ChequeID (AutoNumber / Primary Key)
  • ChequeNo (Text)
  • IssueDate (Date/Time)
  • PayeeName (Text)
  • Amount (Currency)
  • AmountInWords (Text)

2. Connect VB6 to Access

Use ADODB (Microsoft ActiveX Data Objects) in VB6 to connect:

Dim conn As New ADODB.Connection
conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\ChequeDB.mdb;"

3. Number-to-Words Function

Cheques require the amount in text (e.g., $1,250.00 becomes “One Thousand Two Hundred Fifty Only”). You’ll need a helper function in a standard .bas module to convert numbers into words before saving or printing.

4. Direct Printing

For perfect alignment on pre-printed bank cheques, the native Printer object works best because you can set exact coordinates:

Printer.ScaleMode = vbMillimeters ' Easy to measure with a ruler!

' Set Payee position (X = across, Y = down)
Printer.CurrentX = 40
Printer.CurrentY = 25
Printer.Print txtPayee.Text

' Print Date
Printer.CurrentX = 140
Printer.CurrentY = 15
Printer.Print Format(dtpDate.Value, "dd/mm/yyyy")

Printer.EndDoc ' Sends to printer

Would you like me to write the complete VB6 code for the Number-to-Words converter? Just press Reply! :paw_prints:
— Sydney