?
Solved

Send Object Method from Table Field

Posted on 2009-05-03
5
Medium Priority
?
311 Views
Last Modified: 2013-11-29
I have an Access Database that has a main table and a form that users use to enter data into the main table. There is also a second table that contains customer names. The first control on the form is a combo box that is bound to the customer field in the second table so users can select uniform spellings for customer names that will write to the main table also. This second table contains another field besides the customer name which is the customer's email address. The db also has a report that is based on the main table. What I want to do is to use the SendObject method to email the report to the customer for his specific record by using the customer's email address in the second table. I want the user to be able to avoid having to type in the customer's email address for each report sent out by using the email address in the second table. Is this possible? If so, how would I do it? It seems that the To: attribute in the SendObject method does not recognize any table or field reference.
0
Comment
Question by:Ennistymon
  • 3
  • 2
5 Comments
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 24292803
Ennistymon,

Here you go.

Study it carefully.
I am sure you can adapt this to work in your database.

;-)

JeffCoachman
Access-BasicSampleEmailIndividua.mdb
0
 

Author Comment

by:Ennistymon
ID: 24298258
Jeff, thank you for your thorough answer to my question. The user will send the email after each record is entered. What kind of changes to the code would be needed to accomplish this?
0
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 1000 total points
ID: 24298964
0
 

Author Closing Comment

by:Ennistymon
ID: 31578316
Jeff,
I am continuing to study and work with your solution particularly the last update which I believe will ultimately solve my problem. My limited knowledge of VBA and SQL are making this task daunting and time consuming, but I believe I am now on the right track with your help. Thanks for your help.
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 24311757
;-)

Thanks.

Do a search on Amazon for good Access and SQL reference books.

Good Luck!
;-)


Jeff
0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
A Case Study of using the Windows API to provide RS232 communications capability in Access without the use of Active-X controls.
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…
Suggested Courses

601 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question