Recent content by pnmng49

Thank you, G81. You were right, it required this syntax: strSQL2 = strSQL2 & "'" & strMonth & "'" because strMonth=JULY Thanks to all that replied. Regarding normalization- this is a temp table that I use to hold data for a Word mail merge. This temp table gets overwritten the next month...

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

Hooray!! I did as you said, tested for user input = quit before the rs loop--- working great. Also added Me.Requery after the DoCmd to SaveRecord. Refreshes form to show the check marks instantly. Thank you very much, Dave.

Dave, thanks so much. It runs and will update the underlying table. However, the form(record source is tblValidationListMaster) on which cmdFindByORI is placed also has all ORI's displayed with a check box next to each. After the update to the table it takes a very long time for the check mark...

I tried .FindFirst "ORI = " & chr(34) & strUserInput & chr(34) but it still breaks at that line.

Thanks for your patience. .FindFirst ORI = strUserInput I also tried .FindFirst "ORI = '" & strUserInput & "'" but either way it breaks at that line

I set the breakpoint at With rs. It now runs to that line.

I put a break point at If .NoMatch = True Then. But it does not run at all. The error pops up as soon as I click cmdFindByORI

I changed the + to & and it still produces error message. The error message pops up as soon as I click the command button>

After the adjustment to rs, I still get an "Invalid use of null" error message. The ORI is of text data type in the table. User input would be like 0010300.

Thanks wazz, I think the code is properly formatted now.

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