Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: flash1
  • Content: Threads
  • Order by date
  1. flash1

    Subform - unable to add new records

    The Front end of my database is in Access 2000. The back end was upsized to SQL Server 2000. I am experiencing problems with various subforms where it is no longer possible to add new records in the subform. The record source of the subform is based on a query that pulls records from two...
  2. flash1

    Access 97 - Upsizing Tools not found on Microsoft Site

    I would like to download the Upsizing Tools for Access 97. The download link on the Microsoft Site does not work. Does anyone know if this tool has been removed from the Microsoft site or if I can get it from somewhere else? I also checked the Microsoft Download Center and could not find it...
  3. flash1

    Filter Recordsets for Null Values

    How do I filter for Null values on a recordset? The following does not work: lsRecordsetFilter = "FieldName = Is NULL " rst.Filter = lsRecordsetFilter Set rst = rst.OpenRecordset(rst) Thanks, Flash1
  4. flash1

    Create a new recordset based on an existing recordset?

    I have created a search function that allows the user to select up to 4 different criteria to search the database. I have developed the sql statements. The statements use multiple joins between tables. The various search options make it too complex to apply the criteria using a single sql...
  5. flash1

    Apply a new query to an open recordset

    I have created a search function that allows the user to select up to 4 different criteria to search the database. I have developed the sql statements. The statements use multiple joins between tables. The various search options make it too complex to apply the criteria using a single sql...
  6. flash1

    How to apply a new query to an open recordset

    I have created a search function that allows the user to select up to 4 different criteria to search the database. I have developed the sql statements. The statements use multiple joins between tables. The various search options make it too complex to apply the criteria using a single sql...

Part and Inventory Search

Back
Top