Search results

I meant on which button. "New Call" or "Save"

I'm sorry if I'm sounding super annoying. I understand it's hard to explain to someone else something that comes to you quite easily. I have been there before many times. I really appreciate you helping me. But I feel like we are having communication problems. It would make the process easier...

I know they are seperate I already added the code to the save button. My concern is with the validation code you entered above. I'm not sure if I was suppose to integrate it with the code you gave me before that. I'm putting the validatinon code on the New Call button but isn't there something...

I don't understand what I'm doing wrong. I tried to incorporate the validation code into the code you gave me earlier but I continue to get error message "Espected End Sub" Private Sub Add_Record_Click() On Error GoTo Err_Add_Record_Click If Me.cmdSave.Caption = "Save" Then...

Private Sub Add_Record_Click() On Error GoTo Err_Add_Record_Click If Me.cmdSave.Caption = "Save" Then Me.Add_Record.Caption = "New Call" ' ... Validation code GOES HERE ... If IsNull(Me.CS_Rep) Then MsgBox "CS Rep Is Required" Me.CS_Rep.SetFocus...

sorry I don't have that much experience writing code. This is partly what I came up wih. Is there a way I can get rid of this save button and just use New Call. I really appreciate the help Private Sub Add_Record_Click() On Error GoTo Err_Add_Record_Click If Me.cmdSave.Caption = "Save"...

There's no change on what I had before. If I hit the New Call button it would countinue to a new record even if there's no data inputed in the required fieds. I wanted the New Call button to check for required fields on both form and subform. If no data is inputed then I would like for it to...

this is what I have coded on On Click for the New Call button and I don't see any change Private Sub Add_Record_Click() On Error GoTo Err_Add_Record_Click DoCmd.GoToRecord , , acNewRec Exit_Add_Record_Click: Exit Sub Err_Add_Record_Click: MsgBox Err.Description Resume...

Hey I'm kind of a novice when it comes to this. But I'm not sure where I'm suppose to put the first part of the code. I got the on Dirty code in already.

is there a way to integrate them into one button?

It is confidential sorry. Maybe I can include a txt file with the code. let me know if that would be ok

The user will type data into the subform.

Main form: CDatabse Rep Name > combobox > required Caller's Name > textbox > required reason > comobox > required Account# > textbox > not required Date > is automatically inputed Subform: CNote Date> automatic Note > required I want to make it mandatory for the user to input data in the...

HI, You are correct I only want one button (New Call button) But I need it two do those 2 things I mentioned before. 1. Check all requred fields (in the subform and mainform) 2. append a record The subform is in a datasheet format, not sure if that's neccessary. I'm only concerned with...

I would like to remove the "Save" button. My initial idea was to somehow make the "New Call" button check and make sure there's info there for all the required fields including the subform fields in order to move on to a new record. I tried adding the code I have for the save button onto it...

I have two button on a form. One called "New Call" and the other "Save" The Save button checks for all required fields and makes sure that the user enters all required info. My problem is that they can circumvent that by just clicking on the "New Call" button. Is there a way I can somehow...

Sorry I thought you were reffering to the the subform. I'm not sure what you mean by the textbox. the code you just sent you want me to put it in the Note field or the subform??>

Thanks vBaInet, This is what I have behind the On Click event (button) Private Sub Add_Record_Click() On Error GoTo Err_Add_Record_Click DoCmd.GoToRecord , , acNewRec Me.CS_Rep.SetFocus Exit_Add_Record_Click: Exit Sub Err_Add_Record_Click: MsgBox Err.Description Resume...

Mdlueck unfortunately I don't have the time to look that up. I thought it was going to be a pretty quick thing. I was just looking for the right code to do that. I was hoping someone would provide me with one. thanks anyways

Hey thanks for the input but the main problem I don't know what VBA code I should insert. Unfortunately I'm not so tech savvy. Sorry for making this so difficult.