Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004
    Posts
    2

    Unanswered: Help - Error 3251

    Hi,

    I am having a problem to run my program...
    I have a small db...

    When I try to run the declartion "ApproveRecord" I get the error message: "Run-time error 3251: Operation is not supported for this type of object."


    Set TEMPTBL = CurrentDb.OpenRecordset("REVIEWLIST")
    Set MAINTBL = CurrentDb.OpenRecordset("MAINTABLE")

    MAINTBL.FindLast "ID=" & CURRENTID

    ==>TEMPTBL.FILTER = "RWLISTNAME='" & MAINTBL![PROJ] & "'"<== the error occurs in this line.
    Set DLTBL = TEMPTBL.OpenRecordset

    It is a small db to aprove some documents... so it needs a mail to send to a list of peolpe, and that list I am trying to get... The tables Reviewlist e Maintable are full and fine...
    It is located in a network drive and people have a shortcut to its .mdb file.


    Some could help me...

  2. #2
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    try

    [alt][F11] Tools¦References

    see if you have Microsoft DAO 3.6 library "checked"



    izy
    currently using SS 2008R2

  3. #3
    Join Date
    Jan 2004
    Posts
    2
    Yes, I do... but it is still not working... I get the same error message.

Posting Permissions

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