Access and Outlook

L

Larry G.

I am trying to design a database for scheduling field sampling of sites. What
I would like to do is set it up so that when someone enters a data in a
certain field an email is generated so that the person responsible for that
site knows that a visit has been scheduled. Also when that data has been
entered in Access I want it to update into a calendar that all of use as a
publice calendar that is used for scheduling. As always: any help you
geniuses can give would be greatly appreciated.

Larry
 
A

Arvin Meyer

I've never used anything like a public calendar. Most calendar items are in
personal folders and you give other users rights to see and edit their
contents. Check out the following sample code and databases on my website
for examples of what you want:

http://www.datastrat.com/Download/OutlookAppointment.zip

http://www.datastrat.com/Download/OutlookForms2K.zip

http://www.datastrat.com/Code/OutlookEmail.txt
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access
 
M

Mike Painter

Larry said:
I am trying to design a database for scheduling field sampling of
sites. What I would like to do is set it up so that when someone
enters a data in a certain field an email is generated so that the
person responsible for that site knows that a visit has been
scheduled. Also when that data has been entered in Access I want it
to update into a calendar that all of use as a publice calendar that
is used for scheduling. As always: any help you geniuses can give
would be greatly appreciated.
Click to expand...

The web based calendar found at http://www.brownbearsw.com/ will do at least
everything you want and probably more.

If you meant "entering a date" as opposed to "entering a data" above I would
look at this as your main app and capture (I'm not going to write data)
information from it if need be.
 
Top