Solved

VBA data collection in Access 2007

Posted on 2008-06-26
9
974 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
Comment Utility
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
Comment Utility
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
Comment Utility
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
 

Author Comment

by:greenprg
Comment Utility
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
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 500 total points
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
Helen

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

Jeff
0

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

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.
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

728 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

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now