Search results

  1. P

    Select Query to find empty Date fields

    I am trying to create a select query on "ApprovedDate" where no approval is recorded. IsNull returns an expected type mismatch. Any ideas? Regards:confused:
  2. P

    Access 2003 Opening form and displaying last record in underlying query

    Got it. Brilliant Thanks
  3. P

    Access 2003 Opening form and displaying last record in underlying query

    GoToRecord Hi Yes I have looked at the help. I tried it. But it is a question of where I put the code. If I put the event procedure under "on open" it says can't find the filed name because it is not open and leaves me at record 1 of XXX. I can't think of where else to put it. I want to...
  4. P

    Access 2003 Opening form and displaying last record in underlying query

    Hi Everybody I want to open a form to add records using a subset of records filtered on a query. eg "department" and then display the last record when query is ordered on "DocumentCode" But don't know how? It just displays the first record in the subset. Any help would be appreciated Regards...
View older results
Back
Top Bottom