Results 1 to 6 of 6
  1. #1
    dmon2010 is offline Advanced Beginner
    Windows Vista Access 2007
    Join Date
    Sep 2013
    Posts
    39

    Print labels from Access 2007 using label program.

    I have a form where I'd like to create a button to print labels from a labeling program called Label Matrix. I already have the label set up in Label Matrix to draw info from the Access table, and I know how to create a button. I can't figure out how I would make the button print the label.



    Any help would be greatly appreciated. I can post more info when needed.

    Thanks again.

  2. #2
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,863
    I am not familiar with Label Matrix. Do they offer an API to interact with their program? How is the file formatted that will do the actual printing of your labels?

  3. #3
    dmon2010 is offline Advanced Beginner
    Windows Vista Access 2007
    Join Date
    Sep 2013
    Posts
    39
    I'm pretty much new to this. Sorry. I have no idea what an API is...?

  4. #4
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,863
    How is the file formatted that will do the actual printing of your labels?

  5. #5
    dmon2010 is offline Advanced Beginner
    Windows Vista Access 2007
    Join Date
    Sep 2013
    Posts
    39
    Label Matrix Document (.qdf)

  6. #6
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,863
    If you want to open an existing QDF file you can try something like this in the click event of a button.

    Me.ButtonName.HyperlinkAddress = "C:\FolderName\FileName.QDF"

    If double clicking QDF files does not open them directly, you can try using command line to open the application first and then open the file

    I took this from a VB Script example but I belive this translation is correct for VBA. THis opens an Access DB using Access 2010 32 bit

    Shell """C:\Program Files (x86)\Microsoft Office\Office14\MSACCESS.EXE"" ""C:\FolderName\FileName.accdb"""

    You would have to find the path to the exe file that launches the application Label Matrix

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

Similar Threads

  1. Replies: 1
    Last Post: 04-05-2013, 09:48 AM
  2. Auto-fetching Data From 3rd Party Program, Access 2007
    By D4WNO in forum Import/Export Data
    Replies: 1
    Last Post: 08-21-2012, 03:24 PM
  3. Replies: 1
    Last Post: 05-04-2012, 02:22 PM
  4. Problem with label in Access 2007
    By Madraykin in forum Forms
    Replies: 4
    Last Post: 02-04-2010, 10:41 AM
  5. cannot print labels
    By Diane in forum Database Design
    Replies: 4
    Last Post: 12-29-2005, 08:19 AM

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 - Senior Forums