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...
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...
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
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.