Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2016
    Posts
    1

    Post Runtime Error 3251 object not supported

    Hi:

    Have recently upgraded my access databases to 2016 - all are fine except one which keeps coming back with the above runtime error.

    The code affected is:

    Function dayendlast()
    Dim db As Database
    Dim rst As Recordset
    Dim strcriteria As String
    Set db = CurrentDb()
    Set rst = db.OpenRecordset("dayendt")
    strcriteria = "[dt] >= 0"
    rst.FindLast strcriteria
    dayendlast = rst!dayendrun
    rst.Close


    End Function

    Cab anyone help?

    Arend

  2. #2
    JoeM is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    From looking on the web, it appears that maybe you want to use db.OpenDynaset
    http://answers.microsoft.com/en-us/m...6-f2c5f3a517e0

  3. #3
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    I would also change this:
    Dim db As Database
    Dim rst As Recordset
    ...to...
    Dim db As DAO.Database
    Dim rst As DAO.Recordset

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

Similar Threads

  1. Runtime 424 error... Object required.
    By sanderson in forum Programming
    Replies: 8
    Last Post: 08-09-2015, 08:10 PM
  2. Operation is not supported for this type of object error
    By CementCarver in forum Programming
    Replies: 4
    Last Post: 06-17-2013, 02:04 PM
  3. Runtime Error 424 Object Required
    By Maltheo2005 in forum Programming
    Replies: 9
    Last Post: 06-13-2013, 04:52 PM
  4. Replies: 13
    Last Post: 06-12-2012, 09:52 PM
  5. Object not supported "ERROR"
    By Casper2012 in forum Forms
    Replies: 1
    Last Post: 08-24-2011, 06:31 PM

Tags for this Thread

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