Search results

  1. W

    Missing record query.

    Good morning, I use Access 2000 to store details of recordings on DVD discs. There are well over 1000 discs on file and sometimes a disc may get damaged. These, I physically remove from the collection and also remove the record from the Recordings DB, which leaves gaps in the collection where...
  2. W

    Querying a DB by a match on part of field string.

    On Access 2000, I want to produce a query by a complete match on one field, but also by a match on part of the text string of another field which is entered in a pop-up, ie.to query the Title field and list all records containing the string 'Ship' . I've tried different expressions but none...
  3. W

    Solved Query repeats criteria input.

    I've been dogged by this problem on separate occasions for quite a while now. When I run the attached query it prompts me to enter the Media Type as expected, but when I do and then press enter, it repeats the prompt so I have to enter the Media Type twice before it lists. This is annoying, and...
  4. W

    Solved Query selection in Access 2000.

    Hi all, as this is my first message I hope all you seasoned users will bear with me. I've used Access for several years to record various information about collections I have. Though I've had quite a bit of experience with the front end, I've usually had to rely on others when attempting...
  5. W

    Forum newbie!

    Hi all, just a couple of words to introduce myself. I'm a retired engineer, and general creator with a passion for collecting. All collections eventually become unwieldy as far as data's concerned, and that's where Access 2000 comes in! My stumbling block has always been getting things to work...
Top Bottom