I am trying to get my program to cancel a send e-mail command if certain things aren't filled out. Instead it is supposed to pop up with a message and then put the pointer in that field. The message box pops up, but the e-mail command is not cancelled. Can someone please tell me what I am doing wrong?
Private Sub SubmitAddCmd_Click()
On Error GoTo Err_SubmitAddCmd_Click
Dim stDocName As String
Dim strEmail As String
Dim strMailSubject As String
Dim strMsg As String
Dim strCopy As String
'Make sure MMS Job# is entered
If IsNull(MMSJob) Then
MsgBox "Please enter the MMS Job#"
[MMSJob].SetFocus
Cancel = True
'Make sure Client's name is entered
ElseIf IsNull(Client) Then
MsgBox "Please enter the Client's name"
[Client].SetFocus
Cancel = True
'Make sure job name is entered
ElseIf IsNull(Job) Then
MsgBox "Please enter the job name"
[Job].SetFocus
Cancel = True
'Make sure CSR name is entered for this job
ElseIf IsNull(CSR) Then
MsgBox "Please enter the name of the CSR for this job"
Cancel = True
'Make sure date job submitted button was clicked
ElseIf IsNull(Submitted) Then
MsgBox "Please click on the 'Date Job Submitted' button"
'[SubmittedCmd].SetFocus
Cancel = True
'Make sure mail date was entered
ElseIf IsNull(MailDate1) Then
MsgBox "Please enter a mail date for this job"
' [MailDate1].Value
Cancel = True
End If
'E-mail booking sheet to scheduling office in snapshot format
stDocName = "BookingRpt"
strEmail = "jhutton@merklenet.com;jsayers@merklenet.com"
strCopy = "rgarneriii@merklenet.com;"
I have a form with a control for the user to enter some data and then two command buttons 'OK' and 'Cancel'
For the OnExit event in the control I have a procedure that check the user input and if incorrect, opens a message box with an error message asking the user to correct the data. It then cancels the event so the focus remains in the current control.
However if the user presses the 'Cancel' command button on the form to cancel & close the form, the OnExit event for the current control still fires and asks the user to correct the data.
In my code in the control, how can I recognise that the Cancel command button has been pressed, so I can cancel the OnExit event and close the form?
I have a form (Pipeline) with an on load event that automatically directs the user to a new empty record.
Code:
Private Sub Form_Load() DoCmd.GoToRecord , , acNewRec End Sub
Now my problem is that I am trying to design a 'search form' that will allow the user to look up a specific record in the main form by pressing a command button. Creating the search form is easy enough. I cannot figure out how to override the on load event in the main form when pressing the command button.
As it is right now, the button opens the form and then go directly to a new record.
I have a form and a subform in it. I added New cancel button in the form so that the the user can cancel the record creation and no record will be inserted in the parent table.
But when details are entered in the subform (a datasheet) row records will be created in the subform table. what is the correct method or how to cancel these records if the user choose to click cancel button on the parent form.
I am rewriting an old Access 2003 database in Access 2010. When creating new command buttons, the current theme gives them a default appearance. I need to apply this appearance to old command buttons. I know there is a way to select the default button and apply its properties to others quickly. I have done it before but didn't write the process down .
Using Access 97, I have a single-form allow-additions form where a couple of bound fields are auto-populated 'on current' and a couple of other bound fields are left to be populated by the user (me!).
At the end of an input session, I can press ESC and then close the form OK. But if I forget to press ESC and try to close the form, I have an invalid incomplete record on screen.
How do I indicate that the new record isn't wanted? I have tried stuff like If Me!txtRequiredBoundField = Null then SendKeys "(ESC)" End If to no avail.
Hi, I want my user to be able to "cancel" his entry. At first I tried just deleting the record they were working on. But that added numbers in the auto number "ID" field, and I also needed the feature for editing, so deleting wasn't an option. As of now I have something that works, but is kind of messy. I made a mirror "temp table" that I write the record to. If they "save" i append/update the record to the regular table, then delete it from the temp, if they "cancel" I just Delete it from the temp. Was wondering if there was a cleaner way to do this ?
Hello All, I am finding this one difficult so felt I should post my issue. I have status field on my form. It is a bound field. A combobox - inactive, active. I wanted the field to do the following when changed If change then msgbox = Please enter reason in activity notes a vbYesCancel If they select it calls the activity notes form - this portion works. If they select cancel I tried making the field do form.field.undo (Me.statusid.undo) - something similar Cancel = True to reset the field to the original state. This fails and says my object is not valid I would be happy to take any suggestions . As always thanks in advance.
After looking through the forums, i couldn' really see the answer i was looking for. I have a form, that users can enter in details (with an auto-number created which is assigned to each record). Once they have entered the detials, theres a 'save' button which will save the record - which is fine. I also have a 'return' button which should return to the previous form and doesnt save the record. But as it stands, the record is saved when i click this return button. How do i make it so that the record isnt saved untill the save button is clicked? so if i return from the screen (pressing the return button), the record isnt saved (i.e. a cancel button).
I am having a problem with my cancl button on my form. this form has a subform. any changes cancel correctly on my main form. the problem is when there is a change on my subform and then is cancelled.. any ideas anyone? thanks!
I have a Report linked with a SubReport. I would like to cancel viewing this Report if my SubReport Has No Data. i tried this code but the report just shows up. Any Ideas?
Private Sub Report_Open(Cancel As Integer) On Error GoTo Err_Trapper If Reports![qryRepCurOrgProjsSR].Report.HasData = 0 Then Cancel = True End If Err_Trapper: MsgBox Err.Description Exit Sub End Sub
Ok i got an error message. Yoy entered an expression that has an invalid Reference to the hasData property.
Ive tried using a text bpx on my main report and putting a control source as
=IIf(qryRepCurOrgProjsSR.Report.HasData,0,"Nothing") Then in my Report Open Event i put the code below. But it fails me still.
If trim(Me.MyText) = "Nothing" Then MsgBox "The Report Is Cancelling....." Cancel = True Exit Sub End If
I have a subform which asks a user to confirm the update before it happens - if the user selects no - then the update is cancelled.
When the parent (they are not related record wise) form is closed the update on the subform is attempted - if the user selects no - how can I cancel the close of the parent form. At the moment a message saying "Cannot save the record at this time - changes may be lost". Which I don't want to see.
I have docmd.sendobject that opens Outlook to send an email, etc. However if the user does not send the email and cancels out of the message Access is asking the user if they want to debug. How can I simply have Access return to where the user was before they hit the command button that launched Outlook. I don't want them to go into the code. In fact I don't even want a message of any type - I thought I could trap the cancel somehow and code for it...
I have pasted the code that SJ posted on another thread that any changes to a record will ask the user to save before closing the form, this located in the beforeupdate event.
Private Sub Form_BeforeUpdate(Cancel As Integer) If MsgBox("Save changes?", vbQuestion + vbYesNo) = vbNo Then Cancel = True End Sub
The problem i am getting is that if the user selects no it pops up another message saying "You can't save the record at this time" followed by a description. How do i prevent this second message appearing i cannot find a thread with this in?
I'm looking for a way to cancel the closing of a form/app. I added a button asking if the user is sure they wish to exit, and am having difficulty finding the correct code to cancel the close event.Here is my codeDim ians As Integer ians = MsgBox("Are you sure you wish to exit?", vbYesNo, "Exit App") If ians = vbNo Then DoCmd.CancelEvent DoCmd.OpenForm "orderlist", acNormal Exit Sub End IfCan help or send me down the right path?Thanks
Hi all, I have a textbox with an input mask for an id number, so if I begin adding numbers I get an error message if they're not in correct format- this is fine- but I want the user to be able to cancel the entry and exit the form, but when I click the cancel button I get an error message about the id format- anyone know how I can allow cancel to override this? thanx
Hi I have a form with avout 4 fields based upon a query to allow user to edit an entry if needed. I want to put a cancel button on so that if they change their mind after having changed a field it reverts to its original value - so for instance they decide to change a land line phone number to a mobile, exit the field but then have a brain storm and decide not to do this so hit the cancel button. At the moment my cancel button just closes the form (and accepts the overwrite) which would be fine if I am using ADO but not if I am using a bound form. I am sure there is a simple answer (since I cannot be the only person who thinks this option might be a good idea). I am just not sure how to look for it. Any thoughts or ideas? Thanks
i dont want a user to be able to change a value in a combo box if a textbox is not null. im not sure what to add on the onenter event. is there not somthing like cancel=true
am using VB to check for an id if it is a new record. i have a message that pops up.
If IsNull(Form_myform![ID].Value) Then response = MsgBox("You have not entered your ID. Do you intend for this to be a record?", vbYesNoCancel, "id check")
but how do i get it to not enter the record into the table if no or cancel is clicked?
I have the below code that when a user will make a change in a combo box, it will pop up a message asking if they want to do so (to make them aware of it). How could I change it so there is a extra button cancel and when they hit cancel, the combo box will keep the value, if OK is hit, then make the change.
Code: If Me.Business = "TYPE 1" And Me.Case = "Sent Email" Then MsgBox ("You really want to change this!!!") End If
When I launch my modal, I want the user to be able to 'cancel' without creating a new record. It's not doing that and creating extra 'junk' in my table. How do I prevent that?
Here's my code: Private Sub Btn_Exception_SubModal_Click() DoCmd.OpenForm "Frm_Exception_UpdateModal", acNormal, , acFormAdd Forms! [Frm_Exception_UpdateModal]![clientnmbr].value = Me![clientnmbr].value End Sub
I am having some problems, I tryed a msgbox with only ok and if I would like to save the record I see now needs to be a yes/no buttons, so I changed the ok to yes/no and it saves the changes no matter what. so i will need a If statement correct, but what do I put in it?? The Same thing is happending with my ok/cancel buttons. Thanks