98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access VBA Training and help » Create a button to do a number of functions | Access forum
Create a button to do a number of functions | Access forum
Resolved · Low Priority · Version 2007
Tue 18 Jan 2011, 16:37Delegate Sarah said...
Sarah has attended:
Excel VBA Intro Intermediate course
Access Advanced course
Access Intermediate course
Create a button to do a number of functions
I want to create a button on a form that does a number of functions.
1) to run a query (the query is already setup, it basically selects all records in one table for a given time period which the user enters)
2) the data is saved as an excel/csv file
3) and then inserted into an open email
Can this be done or am I getting too complicated?
Thanks,
Sarah
Wed 19 Jan 2011, 09:44Trainer Anthony said...
RE: Create a button to do a number of functions
Hi Sarah, thanks for your query. Thank can certainly be done but the first question is whether you want to do this from within Access or Excel? Either way, you are going to need code to contact the Outlook object model which is something we do on our Advanced course and is a bit beyond the scope of this forum. However, have a look at this link for pointers on how to export from Access to a csv file:
http://social.msdn.microsoft.com/Forums/en/isvvba/thread/d5432b8e-08f6-4b6a-b13d-fc7656970704
Hope this helps,
Anthony
Wed 19 Jan 2011, 09:56Delegate Sarah said...
RE: Create a button to do a number of functions
Hi
I've completed the Advanced course and didn't come across the Outlook Object - I guess it depends on the trainer and the trainees as to whats covered on the day.
I'll see if I can give it a whirl.
Thanks,
Sarah
Wed 19 Jan 2011, 09:56Delegate Sarah said...
RE: Create a button to do a number of functions
Oh and I'm wanting to do this in Access
Wed 19 Jan 2011, 10:03Trainer Anthony said...
RE: Create a button to do a number of functions
Hi Sarah. We address connecting to Outlook on the Advanced Excel VBA course, not the Access course, which is why you may not have come across it. Here are two links, the first with a good suggestion on linking an Excel CSV file as a table in Access and then running an append query to it:
http://bytes.com/topic/access/answers/868486-export-query-result-csv-file
...and the second discussing emailing from within Access VBA:
http://www.ozgrid.com/forum/showthread.php?t=89441& ;page=1
Hope this helps,
Anthony
Wed 19 Jan 2011, 10:56Delegate Sarah said...
RE: Create a button to do a number of functions
Hi,
I've managed to do it using the macro facility.
I basically selected 'Open Query', followed by 'Send Object' then 'Close' and it works perfectly - I didn't even have to write any code.
Thanks for the links they were very helpful.
Sarah
Wed 19 Jan 2011, 10:59Trainer Anthony said...
RE: Create a button to do a number of functions
Excellent! The simplest solution is always the best. Glad to be of help.
Anthony
Training information:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Related tablesWhen you have related tables such as Customers and their Orders, the Customer table is the Primary table. |
