Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004
    Location
    UK
    Posts
    82

    Exclamation Unanswered: Dao Recordset Please Help

    I'm trying to use DAO.Recordset in VBA

    i keep getting method or data member not found when i try and use FindFirst
    can anyone help.

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    Assuming that you followed the example in the help system its likely your recordeset type doesn't support the find methods.

  3. #3
    Join Date
    Mar 2004
    Location
    UK
    Posts
    82

    thanks

    i guessed that was the case, i have managed to find a way round it though, using dlookup,

    the problem i was trying to solve was calculating the number of working days in the current month, not counting public holidays.

    i tried usind recodset to check a table to see if a specific date was a holiday.

    i managed to get round it by listing the number of working days for each month on the table instead.

    it's not really solving the problem but it gets the same result from the same data input.

    thanks for the reply

    andy

Posting Permissions

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