VB code/MSAccess DB runtime error

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • dna316
    New Member
    • Nov 2013
    • 1

    VB code/MSAccess DB runtime error

    I have a label printing setup that includes Visual Basic code for calculating use by dates and excluding leap year and inserting data into labels from Acess data base tables.
    The setup was made using MS Access 2003.

    Everything works great with the old LabelView 8.5 and MSAccess 2003.

    When testing the same setup with the new LabelView 10 or Bartender 10. I get runtime errors.Error '429' ActiveX component cant create object. Debug hilights this line of code....Set LVfile = CreateObject("L blvw.Document")
  • CJ_London
    New Member
    • Nov 2013
    • 28

    #2
    What version access have you upgraded to?

    the object "Lblvw.Document " will have been specified LabelView 8.5, you probably need to upgrade the references to Labelview 10

    Comment

    • zmbd
      Recognized Expert Moderator Expert
      • Mar 2012
      • 5501

      #3
      If CAintheUK suggestion to look at the references for LabelView 8.5 to upgrade the references to Labelview 10 don't help then:

      1) Make a backup copy of your file.
      2) Open the COPY of the file
      3) FileSaveAs and save the COPY as the newest file type available (so from an *.mdb for acc2000 - 2003 to a *.accdb for ACC2007 and newer).
      4) Open the new version of the file.

      Comment

      Working...