Need Additional Help
I think the code referenced by ADezii will work but being a newbie at VBA, I'm not sure how to integrate the new code into my existing code. I have my existing code running behind my forms and not in a module. I have been researching as to whether I need to put this in a module and the more research I do the more confused I get. Any suggestions would be helpful.
dlblack
Last Activity: Aug 26 '10, 06:28 PM
Joined: Jan 16 '09
Location:
-
Opening Outlook from Access when Outlook is Closed
I am using the following code to send emails with attachments from Access using Outlook. The code works fine if Outlook is already open and emails are sent as expected via Outlook. When Outlook is closed, data is saved to the database but the email is not sent. Here is the the code. If anyone has suggestions on how I can get Outlook to open before trying to send the email I would appreciate it.
...Code:Private Sub Approve_Click() On Error
-
Chip,
Thanks for the tip. I will try implementing the Dlookup to see if this solves my issue.Leave a comment:
-
Mandanarchi,
I made the suggested change, but the error message displaying is still the default message. Any other suggestions would be appreciated.Leave a comment:
-
Using Custom Error Messages
I have created a form that captures Capital Project Request data for review. After the reviewer has made their decision as to approve or deny the project request, they click an approval button or a denial button. When the button is clicked, an append query runs and writes the data to the appropriate table. I have the project ID set as the primary key and the project ID field is set to not allow duplicates. This process is working correctly, but I... -
I have created a form that captures Capital Project Request data for review. After the reviewer has made their decision as to approve or deny the project request, they click an approval button or a denial button. When the button is clicked, an append query runs and writes the data to the appropriate table. I have the project ID set as the primary key and the project ID field is set to not allow duplicates. This process is working correctly, but...Leave a comment:
No activity results to display
Leave a comment: