Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003

    Unanswered: Error on openning

    I have coppied a front end backend database into one new database file in order to show to other users on a lap top. The database will not open and give an error : type mismatch at this line.
    SQLStr = "SELECT ID FROM tblStaff WHERE InUse = '" & fOSMachineName & "'"
    Set RS = CurrentDb.OpenRecordset(SQLStr)
    While Not RS.EOF

    any ideas where im going wrong?

  2. #2
    Join Date
    Jan 2004
    The Netherlands
    inuse probably is a True/false value where as the code compares it to a string....

    Look into that and see if you can figure it out from there


Posting Permissions

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