Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Mar 2001
    Location
    St Georges du Bois, Pays de la Loire
    Posts
    84
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Search across tables (Access 97 SR2)

    We have a database containing tables that hold data about document issue to people. A new table is started when a document is issued - the table title contains the document code and the date. We now need to search across these tables to see when individuals signed for their document - the search only needs to return the table title in which name ocurrs. The number of tables changes all the time as documents are issued. We need to be able to tell the search to look for tables beginning with a specific code.

    Could someone give me any tips on how to do this please?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Search across tables (Access 97 SR2)

    You're going to hate this answer, I'm afraid. You should store data in tables, not in their names.

    Storing your data in many tables is making things difficult. You'd have to write lots of code to search table names and then retrieve records from some of them.

    It would be much better to use one table with document information and one table that records when and to whom a document was issued. The tables should be linked (one-to-many) by the document ID.

  3. #3
    Star Lounger
    Join Date
    Mar 2001
    Location
    St Georges du Bois, Pays de la Loire
    Posts
    84
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Search across tables (Access 97 SR2)

    Yes - big sigh, so early in the morning too.

    We inherited this system some years ago and only in this week have we been asked for information.

    Going to sit down now and see if there is some way of pulling the specific document code info together. Looks like the start of another learning curve.

    Thanks for your help Hans - spent some days near Amsterdam last year - really envy you your on the flat cycling.

    David

Posting Permissions

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