Solved

VBA data collection in Access 2007

Posted on 2008-06-26
9
977 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
9 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
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

 

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 500 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

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

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

In this post we will learn how to connect and configure Android Device (Smartphone etc.) with Android Studio. After that we will run a simple Hello World Program.
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

820 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