Advertisement

06.26.2008 at 12:48PM PDT, ID: 23519602
[x]
Attachment Details

VBA data collection in Access 2007

Asked by greenprg in Access Coding/Macros, Miscellaneous Programming, VB Script

Tags: Microsoft, Access, 2007, VBA

I'm pretty new to Access 2007 & VBA and I've been hunting around the help files and my Access 2007 Bible.  I haven't found any info on whether or not the Data Collection Wizard in Access 2007 can be written into VBA code to run as an event procedure.  

When a new request is created by a user, e-mail is automatically sent to specified persons for approval to the request.  Is there a way for the e-mail recipients to reply "approved" or "not approved" to the auto sent e-mail and to have the approval reply automatically update a field in the database?Start Free Trial
[+][-]06.26.2008 at 10:49PM PDT, ID: 21881187

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.27.2008 at 08:34AM PDT, ID: 21884843

Experts Exchange has a courteous staff of administrators who help members get the most out of the website by means of administrative comments like this one.

Start your 7-day free trial to view this Administrative Comment or ask the Experts your question.

 
[+][-]06.27.2008 at 08:50AM PDT, ID: 21885009

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]06.27.2008 at 11:17AM PDT, ID: 21886380

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.03.2008 at 01:32PM PDT, ID: 21928786

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]07.03.2008 at 07:43PM PDT, ID: 21930733

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: Access Coding/Macros, Miscellaneous Programming, VB Script
Tags: Microsoft, Access, 2007, VBA
Sign Up Now!
Solution Provided By: boag2000
Participating Experts: 1
Solution Grade: B
 
 
[+][-]07.07.2008 at 08:15AM PDT, ID: 21945774

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]07.07.2008 at 01:13PM PDT, ID: 21948285

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628