Search results for query: *

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...

Check to make sure that you do not have any local tables on the Front End such as Error Tables that are not linked. Delete these and try again. Flash1

I have a similar problem. Check CPU usage on the server. We have found that it sometimes peaks at 100% and causes the Blue Screen. Is the server crashing? If the server crashes then the backend will probably become corrupt. Do you compact on a regular basis? I find that this sometimes helps...

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...

Solved it. lsRecordsetFilter = "FieldName = NULL" rst.Filter = lsRecordsetFilter Set rst = rst.OpenRecordset(rst)

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

Thanks for the ADO info. I had considered using a temporary table since I need to have the option to run a report on all or part of the resultant but wasn't sure if it was the best way to go. I am using Access 97.

No, I want to manipulate the recordset based one or many criteria selected by the user before bringing it back to the form. The criteria are applied one at a time drilling down to the resulting records. I am new to this forum, how do I link/search to the thread that you referenced? I tried the...

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...