Search results
-
L
Yes No Prompt on duplicating record
Ok, I have a user that wants to duplicate some records in access 2010. I know this it is a simple task to create a button to duplicate only this creates the record directly on clicking the button. I would like the user to have a prompt that when the user clicks duplicate record, they get a... -
L
Mail User Based on Loaded Form
Ok I got it working by moving Me.[Date Closed] = Date Me.[Time_Closed] = Time DoCmd.Close to the end of the code. thinking the form was closing before the script got the chance to read field emailaddress. Private Sub Command77_Click() Dim olApp As Object Dim objMail As Object... -
L
Mail User Based on Loaded Form
How do I do that. all I have ever done is Compile in VB which all comes back fine -
L
Mail User Based on Loaded Form
No I don't get an email address in the to box. it is blank -
L
Mail User Based on Loaded Form
Om I tried that see below but still don't seem to get an email. Private Sub Command77_Click() Me.[Date Closed] = Date Me.[Time_Closed] = Time DoCmd.Close Dim olApp As Object Dim objMail As Object On Error Resume Next 'Keep going if there is an error Set olApp = GetObject(... -
L
Mail User Based on Loaded Form
No subform this is the name of the actual main form I have also made the MaillAddress field visible and can see the correct mail address for each user being populated in the form. -
L
Mail User Based on Loaded Form
Hi thanks for the reply. I have tried this but still not working and I have also changed field to MailAddress to see if this was causing the issue. I don't get any errors in the code just no email My code now reads Private Sub Command77_Click() Me.[Date Closed] = Date Me.[Time_Closed] = Time... -
L
Mail User Based on Loaded Form
Hi there, I have created a helpdesk database that works the way it should. When I close the helpdesk call I would like the code behind the "Close Call" button to mail the actual user that logged the call. I have created the code that can mail to the address I type into the code but how do I get... -
L
Macro-shortcut to insert Date and Time
Ridders, Works perfectly thanks you :) -
L
Macro-shortcut to insert Date and Time
Hi, I know this is an old thread but hopefully you can still help.. I have managed to get the code working and inserting date and time when i add text to my notes field.. i would also like to have the username of the person entering the text EG: Date Time User. the userdata can be taken from a...