Results 1 to 4 of 4
  1. #1
    Business is offline Advanced Beginner
    Windows 8 Access 2010 64bit
    Join Date
    Apr 2016
    Posts
    78

    Sending total to pole display

    Hi guys,


    Another issue,how do i manage to send the total of my transaction to a pole display. i m using a VFD Display PD220.. This is the code i have used
    Dim mySales As String

    If isNumeric(Me.TotalSales) then

    mySales = Me.TotalSales 'TotalSales is a Visible Text
    'box with Enabled Property
    'set to No and Locked
    'property set to Yes
    Else
    mySales = 0
    End if


    MsComm1.Output = Chr $(&H5) 'Scroll
    MsComm1.Output = Chr $(&HA) 'Line Feed
    MsComm1.Output = Chr $(&H13) 'Cursor on
    MsComm1.Output = "TOTAL SALES " + mySales ' Displayed Data
    MsComm1.Output = Chr $(&HD) ' Carrige return
    I keep getting an execution error.
    how do i solve it.
    regards

  2. #2
    Perceptus's Avatar
    Perceptus is offline Expert
    Windows 7 64bit Access 2007
    Join Date
    Nov 2012
    Location
    Knoxville, Tennessee
    Posts
    659
    What is MsComm1?

  3. #3
    Business is offline Advanced Beginner
    Windows 8 Access 2010 64bit
    Join Date
    Apr 2016
    Posts
    78
    it s the usb port 1,where the pole display is connected

  4. #4
    davegri's Avatar
    davegri is offline Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,388
    Code:
    MsComm1.Output = Chr$(5) 'Scroll 
    MsComm1.Output = Chr$(A) 'Line Feed 
    MsComm1.Output = Chr$(13) 'Cursor on 
    MsComm1.Output = "TOTAL SALES " + mySales ' Displayed Data 
    MsComm1.Output = Chr$(D) ' Carrige return 
    Try above

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Pole Display
    By nhdee in forum Programming
    Replies: 13
    Last Post: 08-29-2014, 07:43 PM
  2. Replies: 3
    Last Post: 12-16-2013, 01:43 PM
  3. Combining 'sending mail' with 'sending a report'.
    By Mattbro in forum Programming
    Replies: 2
    Last Post: 11-25-2012, 07:42 AM
  4. Display Total on a form
    By Ray67 in forum Forms
    Replies: 21
    Last Post: 06-18-2012, 03:49 PM
  5. Replies: 3
    Last Post: 10-23-2009, 05:03 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums