?
Solved

VBA data collection in Access 2007

Posted on 2008-06-26
9
Medium Priority
?
990 Views
Last Modified: 2013-11-27
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?
0
Comment
Question by:greenprg
  • 4
  • 4
8 Comments
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 21881187
greenprg,

1. You might want to look into SharePoint for this.

2. Everytime I see a complex solution for Outlook automation, this book is not far behind:
http://www.outlookcode.com/article.aspx?ID=25

3. Also, click the "Request Assistance" button in your original question, and ask that a link to this Q be placed in the Outlook, Exchange and Sharepoint Zones

JeffCoachman
0
 

Author Comment

by:greenprg
ID: 21885009
Thanks, Jeff!

The link you sent is helpful so I'm researching down the Outlook path.  It seems it may only have solutions from the Outlook direction so I'll still need to figure out if I can automate the entire loop.....pushing the e-mail from Access and having Outlook replies auto update my Access database.

I also up'd the point value on my question since I haven't received any solutions yet.  Does more points on questions, help?  It's my first posting.....quite a fascinating system.

Thanks again!
Helen
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 21886380
greenprg,

< It's my first posting>
...Then let me be the first to say: "Welcome to Experts-Excahnge!"

<Does more points on questions, help? >
In a nutshell, ... yes.
It goes to showing how important the question is to you.
;-)

JeffCoachman
0
Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

 

Author Comment

by:greenprg
ID: 21928786
Not sure if my question is really hard....boring...or just can't be done.  I'm curious to see if I'll get any responses after increasing the point value to the max.  Hope to hear from someone.
0
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 1500 total points
ID: 21930733
greenprg,

<Not sure if my question is really hard....boring...or just can't be done.>
Or too time consuming ... or some combination of all of the above.

I can tell you that this is not a question I have ever seen.

This Q seems to straddle the fence as to what is a "I just need help with this: type question and what is a full blown project that should really be assigned to a paid consultant.

Most experts here work full time and do not have the time to research and develop a custom solution for members.
(Why work on something for an hour for free, when you can get paid by a client for the same amount of work and time?)

For example: the question of sending out an email upon request is relatively straight forward.
How much of that part of the solution have you worked on yourself?

There are Voting buttons in Outlook that you could probably use for your replies, did you know that?

I found this in a quick Google search:
http://www.access-programmers.co.uk/forums/showthread.php?t=38122

So if you find out how to send an email through outlook. (Again, another quick Google)
http://msdn.microsoft.com/en-us/library/aa159619.aspx

Are you saying you can't combine the two?


It goes a long way if the asker has shown that they themselves have spent some time solving the issue and is not just posting to EE because it is convenient.
;-)

JeffCoachman


0
 

Author Comment

by:greenprg
ID: 21945774
Thanks, Jeff!

It's my first posting (I'm still getting the feel for this website) and it's the first Access database I've developed.  I've only MODIFIED databases in the past and that was years ago.  I guess I'm pretty rusty at this stuff considering I've been on "maternity leave" for 5 years.  It's amazing how all the info is out there just to be Google'd.

So, with that said, yes, my database sends out e-mail fine and I've only been looking at the Access/VBA side trying to figure out if I can accept replies and update my database automatically.  Since the e-mail sent from Access is from whoever is making the request, when the 6 recipients who need to approve the request reply, all the replies will go to the requestor....who right now has to manually update the database with the approvals he has received.  Not perfect, but workable.  Really cool would be replies that automatically update the database, replies are stored on the server as CYA "proof", and at the end of each day, e-mail is automatically sent again to "need to know" users that the request has been updated.  Not having programmed this stuff before, I guess I was fishing around to see if this has already been done somewhere.  

Voting buttons in Outlook sound good (I had heard about it) but is it possible to have an e-mail template with the voting buttons so Access can generate the e-mail automatically?  Currently, I am using the DoCmd to send the e-mail and I have the request information in an RTF attachment.

I've got so many other areas of the database to work on that the "really cool" auto update was just a small piece of my project.  I guess I was looking for a ....oh yeah, that's easy, we do that all the time, answer.  I thought I may have been overlooking something really simple.

So, love the links you sent.  You've helped me figure out how to navigate the web more and now I know how to "search" better.  Since I'm not a lazy programmer, I will take your links and run with it.  Thanks for all the help shaking the rust off my fingers.

Helen
0
 

Author Closing Comment

by:greenprg
ID: 31474054
Wow!  I get to grade this too?  Well, thanks again, Jeff.  I really do appreciate the time you spent to walk me through how things work on this website.  I'm still quite fascinated by the website.  It's like a combination of an arcade game and a quiz show for programmers. I hope the B doesn't screw something else up and I hope the points help you on your journey to the top.

Helen
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 21948285
Helen

Great,
;-)
Make sure you investigate the Outlook 2007 programming book I posted the link for.

Jeff
0

Featured Post

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

Question has a verified solution.

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

The SignAloud Glove is capable of translating American Sign Language signs into text and audio.
If you are a mobile app developer and especially develop hybrid mobile apps then these 4 mistakes you must avoid for hybrid app development to be the more genuine app developer.
Six Sigma Control Plans
Progress

862 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