Results 1 to 2 of 2

Thread: SQL VBA UPDATE error 3219

  1. #1

    Thread Starter
    Join Date
    Feb 2010

    SQL VBA UPDATE error 3219

    I Am getting 3219 error

    following code

    Dim rec3 As Recordset
    Dim db As Database
    Set db = CurrentDb
    MsgBox Me.ordnum.Value
    Set rec3 = db.OpenRecordset("UPDATE dailydtatab SET DEALERID = '" & Me.delident.Value & "' WHERE ORDERNUMBER ='" & Me.ordnum.Value & "'")
    MsgBox " recorders updated"
    can anybody tell what is the problem

  2. #2
    MS SQL Powerposter szlamany's Avatar
    Join Date
    Mar 2004

    Re: SQL VBA UPDATE error 3219

    Update commands don't return a recordset - what are you trying to accomplish with that code?

    I don't do VBA but there must be some kind of EXECUTE command that will run your ACTION query...

    *** Read the sticky in the DB forum about how to get your question answered quickly!! ***

    Please remember to rate posts! Rate any post you find helpful - even in old threads! Use the link to the left - "Rate this Post".

    Some Informative Links:
    [ SQL Rules to Live By ] [ Reserved SQL keywords ] [ When to use INDEX HINTS! ] [ Passing Multi-item Parameters to STORED PROCEDURES ]
    [ Solution to non-domain Windows Authentication ] [ Crazy things we do to shrink log files ] [ SQL 2005 Features ] [ Loading Pictures from DB ]

    MS MVP 2006, 2007, 2008

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


Click Here to Expand Forum to Full Width