Thanks Gasman for all your assistance.
I don't think I have the knowledge to implement your code and make it work for me. We'll manually change the From address when we send the email.
Again, thanks for your help.:):):)
Made the changes that you noted above and ran the report based on a "BoxesNextDay" Customer and From address is still showing @colemancontainers.com.
Here is my current code:
Me.Refresh
Dim iAccountIndex As Integer
Dim db As DAO.Database
Dim rs As DAO.Recordset
Dim strReportName As String...
Thanks again for your input, but I am thinking that the problems you encountered when trying to compile is the fact that i have skinnied it down. The source tables are all from a ODB connection and I got rid of all of them for confidentiality. What I sent does work on my system, giving an...
Thanks again Gasman but cannot figure out where/how to set up the "From" company on your email code.
I have a skinnied database which I'll attach which may assist you in assisting me.
On the detailed AR report, I show user name from logon info and the company, coleman or boxes next day from...
Sub Test2()
Dim OutApp As Outlook.Application
Dim OutMail As Outlook.MailItem
Dim iAccountIndex As Integer
iAccountIndex = ListEMailAccounts("Gmail")
Set OutApp = CreateObject("Outlook.Application")
Set OutMail = OutApp.CreateItem(olMailItem)
With OutMail...
Thanks Gasman, but got the following error when setting that line to:
Set .SendUsingAccount = oAccount.
Error: Run-time error '91': Oject variable or With block variable not set.
I want the vba to pick up the address based on the customer.
Trying to get vba so that my AR Collection person can click on past due customers, look at their account, make comments and then send an email with the account attached. I seem to have that process working well.
My problem stems from the fact that we run two companies with two different...
Thanks plog.
The form works properly if I enter a date. e.g. if it is today or prior to today, it brings back a message and puts the cursor back at text16, if it is in the future, it gives the drop down box with the list of customers that match the date input.
On most other forms I have...
Did the Isdate() thing and it showed up as false whether it was empty or filled with a date. Text16 is an unbound text box formatted as a short date.
ed
Thanks for your response.
I looked at this, and if you look about half way down my attachment, I did a Immediate screen for Null and "" and it appears to me text16="" not null.
Did I miss something?
Ed
I have attached a copy of part of my program where a user inputs a date to get the next 10 days of expected customer deliveries. I input a criterion that the date input must be in the future, ie > today. When I input an earlier date and hit the arrow on the Customer drop down box, I...
Hi Minty,
The report is in report view format so they can view it, download to Excel or Print it (hopefully). I have changed the code to what you suggested but used acNormal rather than the preview.
Have to wait until the user gets back to me to see if it works.
Regards Ed
I have uploaded the design view of the report. I am using a remote connection so I basically cannot test the print myself so I use the print preview in Access. The user verifies that the printout looks like the file that I originally attached.
I am using DoCmd.PrintOut acPrintAll to print...
I have created a report in landscape that appears nicely on the screen (see upper image on the attached file). However, when I go to print preview, it has HUGE print and now appears to be a portrait orientation (see bottom image on the attached file).
Any assistance would be much appreciated...