Results 1 to 2 of 2

Thread: need a big help

  1. #1
    Join Date
    Jun 2002
    Posts
    5

    Red face Unanswered: HEEEEEEEEEEEEEEEELLLLLLLLLLLLLLLPPPPPPPPPPPPPPPPPP PPPPPPPPPPPPPPPPPP

    I trying to acces by a recordset on my table and that doesn't function. it say to me
    run-time error '3001':

    invalid argument.

    my source code is


    Dim rstTMP1 As New Recordset 'table TransfertInscTMP1
    Dim NewEmail As String
    Dim NewWorkPhone As String
    Dim NewFaxNumber As String

    Set rstTMP1 = CurrentDb.OpenRecordset("TransfertInscTMP1", dbOpenDynaset) 'the place that doesn't run

    thanks for your help
    Last edited by WaRs; 06-17-02 at 13:15.

  2. #2
    Join Date
    May 2002
    Location
    Budapest - Hungary
    Posts
    12
    Hi,
    Did you try repair funtion(tools > database utilities > compact and repair)? Maybe it can help.

    On the other hand I think there is missing return reference to current database...

    Set dbs = CurrentDb command


    Attila

Posting Permissions

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