Search results

Hi everyone, This Access 2000 update query (in red) doesn't update the table. Can you help? I have posted the results from Immediate Window after end of sub. Private Sub cmdCreatePurgeLetters_Agency_Click() On Error GoTo Err_cmdCreatePurgeLetters_Agency_Click DoCmd.SetWarnings...

Hi everyone, I have two tables with a one to one relationship (they have the same PK). I would like to be able to update the record in each table from values the user inputs into text boxes on a form. I have set "referential integrity" and "Cascade updates", but the update is only happening...

I have a form with three command buttons to preview, email, and print a report. The code works---sometimes!!. It is erratic, sometimes the preview code won't open the report. Here is the coode, can you help, please? [code]Private Sub cmdOpenPreviewStatusReport_Click() On Error GoTo...

Hi everyone, The following code produces an "Invalid use of Null" message.(Access 2000) I am trying to test if the strUserInput matches a value in the ORI field of tblValidationListMaster. If it does I want to set MailFlag by running strSQL; if the strUserInput is not found as a value in the...

I need to develop an Access 2003 App that can handle the scheduling of clients into training sessions (only either AM or PM). For example: Company. date session location ABC Corp 1/1/08 AM Rm 110 XYZ Co. 1/3/08 PM Rm 599 Location Capacity Initially Reserved(based on 2 per invitee) Rm 110 50...

Hi Everyone, How can I display the full set of a query's results on a form. Example: My query returns n records: OrgID, First, Last, Address, City, State, Zip I would like to be able to display the results in text boxes on a form. Of course, n can vary with each instance of the query...