Search results

Here's the code again: Private Sub cancel_record_and_return_to_menu_Click() On Error GoTo Err_cancel_record_and_return_to_menu_Click DoCmd.DoMenuItem acFormBar, acEditMenu, acUndo, , acMenuVer70 Me.Undo Cancel = True Exit_cancel_record_and_return_to_menu_Cl: Exit Sub...

I had an error message with the following command: Compile Error: Sub or Function Not Defined: Form_Current What should I do?

I think this is rather simple, but I created an 'undo' button via the wizard. When pressed in the form, it does not work and gives an error msg: "The command or action 'Undo" isn't available now". Here's my code: Private Sub cancel_record_and_return_to_menu_Click() On Error GoTo...

Thanks a million. I did search for it and was not successful.

Thanks Pat. Can you provide me with a link only to expedite time? Thanks Again.

:D Thanks a million!!

Thank you. It worked. Please check back to periodically today to see if I have any more problems. Thanks a million! ;)

Question: So I have to have code in the BeforeUpdate on the FORM and on the BeforeUpdate on the field also?

It works! ;) But ... When I add a new record, the first field is the Provider Code. If I tab to the next field without entering data, the error msg does not appear. I put this code in Lost Focus event. I received the error message, but the cursor did not stay in the Provider Code field.

Thanks. I removed all events on the Provider_Code field and placed it on the BeforeUpdate on the Form. Here's my code: Private Sub Form_BeforeUpdate(Cancel As Integer) If IsNull(Me!Provider_Code) Or Len(Me.Provider_Code) < 3 Then MsgBox "This Field, 'Provider Code' Must Be Completed...

I still need some help. Can anyone assist me? Thanks in advance. ;)

It doesn't work. The message doesn't appear. Also, please explain to me why I would place this code in the before update when it needs to validate what has been placed into the field, which would seem to be the "After Update"? Everything almost worked with my original code but the cursor...

I tried it. It didn't work. Here's the edited code based on your suggesstion: ************************* Private Sub Provider_Code_AfterUpdate() If IsNull(Me!Provider_Code) Then MsgBox "This Field, 'Provider Code' Must Be Completed. Please Enter A 3-Digit Privider Code!", vbExclamation...

The Provider Code field is a TEXT field.

I have written some code to do the following: When keying data into a new record and/or clicking onto the "Menu" button, which closes the form. The User must enter a 3-digit Project Code. If the project code contains a null value, a message appears stating they must enter a 3-digit project...

No. I had changed something in the table relationship. Can you work with what you have. I am unsure as to how I should fix this. I sent you a private message as well.

Basically anything. Choose 506 for Hinds Community College and select any location in the second combo box. Then, advance to the next record (#2)

The error message is directly related to combo boxes. In order for the combo boxes to work properly, in the manner that it was sent to me, the tables had to be related as it is. But, it's creating the error when I try to advance to the next record. I will resend the sample that was sent to...

I have submitted a thread on last month but had to stop working on this project due to another project that took precedence. I am now resuming the completion of this project. Could I get some help with the following error: Cannot perform cascading operation. It would result in a duplicate...

Hi. I am now resuming the completion of this project. Would someone help me out with the following error: Cannot perform cascading operation. It would result in a duplicate key in table". Is there a problem on the table level?? Would you check out my relationships? Thanks.