Search results

  1. 8

    Searching for a particular ID number across all tables in an Access Database

    I have inherited an old Access database with about 300 tables. We need to be able to search for a client ID number (for example 'R12345') in every table in the database and to return all tables that it exists in (all rows would actually be good but a list of the tables it exists in would do as a...
  2. 8

    Add a simple date picker to an existing form

    I have created a very basic form that lists all the fields and you can also scroll through the entries in the table. This was done simply by highlighting the table, right clicking and going to Create > Forms > Form. What I require though is to copy this form but add in the feature that when you...
  3. 8

    Query to return entire rows with Min Date only

    I am looking to return one row from groups of the same EpisodeID whereby the row with the minimum date is selected each time. This includes returning all other fields in the row such as EventID below and ideally others as well if that will be possible. To illustrate I include the following...
  4. 8

    SELECT returns more than one row

    Hi I am using a simple Pass Through Query in MS Access to pull data from a Sybase database and populate a table in Access. This query has always worked in the past but has recently been throwing back the following error message: ODBC -- call failed. [Sybase][ODBC Driver][Adaptive Server...
Top Bottom