Results 1 to 4 of 4

Error 429: ActiveX component can't create object

Threaded View

  1. #1
    Registered User
    Join Date
    06-19-2013
    Location
    Peoria, IL
    MS-Off Ver
    Excel 2010
    Posts
    18

    Error 429: ActiveX component can't create object

    Sub Submit ()
    
    Dim d, rs As Object
    Dim mySQL As String
    Set d = CreateObject("accesss.application") <----having trouble here!
    d.opencurrentdatabase ("path here")
    d.DOCMD.SetWarnings False
    mySQL = "insert into working_hours (effective_date, fac, bldg, start_of_day, end_of_day) values (" & EffDate & ", " & fac & _
            ", " & bldg & ", " & SoD & ", " & EoD & ");"
    Set rs = d.Execute(mySQL)
    
    End Sub
    I have a button 'update assigned to this macro where i am bringing values in and pasting them into an access database.
    Last edited by Leith Ross; 07-11-2013 at 01:32 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1