If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Collect data by using e-mail messages
In Access 2007, a user can open a table, click on the External Data tab,
click on the Create Email group, and follow the steps to collect data updates through email. Rather than have to click on the tabs from the toolbar, I need to create a macro so that when the user clicks a command button, the same events happen. I asked this question a few weeks ago, but received just a few responses and no one seemed to be aware that Access 2007 has the "Collect Data through Email" option. Thanks in advance for your time! *Glen* |
#2
|
|||
|
|||
Collect data by using e-mail messages
On Thu, 4 Feb 2010 06:31:01 -0800, *Glen*
wrote: One reason may be that it is highly unusual to allow users access to the tables. Typically the developer sets this up for the table(s) that warrant this, before the user even gets to see the application. If your users are more developer-types, I'm sure they won't shy away from a few mouse clicks. Pretty much any menu operation has a RunCommand equivalent. Check it out. -Tom. Microsoft Access MVP In Access 2007, a user can open a table, click on the External Data tab, click on the Create Email group, and follow the steps to collect data updates through email. Rather than have to click on the tabs from the toolbar, I need to create a macro so that when the user clicks a command button, the same events happen. I asked this question a few weeks ago, but received just a few responses and no one seemed to be aware that Access 2007 has the "Collect Data through Email" option. Thanks in advance for your time! *Glen* |
Thread Tools | |
Display Modes | |
|
|