Private Sub Email_Notification_Button_Click()
'This function emails out an notification email to recipients to flag a Internal Incident has been raised
If MsgBox("Would you like to send an email notification to highlight concern?", vbYesNo + vbQuestion, "Email Notification") = vbYes Then...
Sorry I think we're confusing each other now.
I have added your DLookup into the VBA code and it comes up with this on the Full Microsoft Access
When i try and run it on Runtime, i get this
Before changing the DLookup, the original one worked fine on the Full Microsoft Access.
It allowed me to edit and send using the full Microsoft Access with no issues as expected, but when i ran the code on a Runtime version of access i get the "Execution of this application has stopped due to a run-time error"
When i read your message back i did laugh and put my head in my hands ha-ha!
Took your advice and just put
DoCmd.SendObject acSendNoObject
but i still get the same error.
On a computer with full Microsoft Access, it loads an empty email and if i close the email without sending it returns the...
I've tried eliminating all the different bits i've added. The only bit of code in there now is;
Private Sub Email_Notification_Button_Click()
DoCmd.SendObject acSendNoObject, , , , , , , , False
End Sub
This still returns the same pop up as above. 😖
It is an accdb.
I'll have a play with the "DoCmd.SendObject....." section in a mo as need to pop out. Using the full version of access it only errors if I dont send the email (outlook has loaded the message ready to send and i cancel it). On runtime it just displays that error.
Hi theDBguy!
Apologies should have explained a bit better haha. They click the button and nothing happens (no errors, no pop ups etc.), you can just keep clicking the button and it continues to do nothing.
I'll remove the On Error now and give it a go quickly :)
All the best
Stu
Hi Everyone,
Im stumped and hoping someone might be able to point me in the right direction (or tell me it cant be done).
I have created a database to manage Internal Incidents and got a button that sends a generic email to the Investigator and Raiser, using the following VBA;
Private Sub...
Thank you all for your feedback, especially about the poor namings. Everything I've done with access is self taught and from help from you all, so now i know this I will do my best to follow the guide to prevent using certain words.
@arnelgp I have used your method and is working perfectly...
Hi Everyone,
I thought I had mastered everything on my new project, but i'm stuck on my last hurdle! I haven't managed to create anything yet as my mind has gone blank and anything I've tried has failed miserably!
I've drawn out the two tables I need to reference, containing example data...
You sir are a star! I have never used Case before though, so a new learning there. I really appreciate that and it will allow me to sleep tonight now! :)
Hi All,
I have been working on this for too long now and I am just banging my head against a wall now, admitting defeat and hoping someone might be able to help me!
Background is that im making an Internal Incidents database, and each text box is locked/unlocked depending on your Department...
Hi Everybody,
Me again, im hoping this is my last question as I have been playing all day and lost the plot haha!
I have created a Query that lists all email addresses that need to receive an email notification when we raise an incident in the database.
The query is called...
Im suprised any of it works with the brainfarts I keep having lately haha!
I may be back soon as Im now struggling (or not sure if its possible) to pull multiple email addresses from a query into outlook haha!
Hi Everyone,
So I closed the database down last night and looked at it this afternoon with a fresh head and I have solved it all within the hour
So I was building myself an inital test before embedding it into the database to show certain fields based on Permission settings, managed to get it...