If so...I'm trying to alleviate some papers on my desk and get them into a program on the PC instead... I'm trying to figure out how to set up a program in either access or excel where I can schedule individual appointments with client(s) and their consultants and then generate a printout of those individual assignments for the consultants to know which client to meet with and when, and of course some demographics of each profile would be included, but for the appointment scheduling I would like to setup an automatic program for them from (via data entries) prompts that could be answered and then the program will automatically setup the appointments.
If you know of a site where I can find formulas for such programming in those two softwares and if there is a way for either of these programs to automatically open email programs for sending out each individual appointments to consultants would be great assistance...serious replies only please...Thanks ahead of time!
2007-06-26 01:34:46 · 5 answers · asked by Rmprrmbouncer 5 in Computers & Internet ➔ Programming & Design
I already do know the softwares....just don't know the query formulas that would enable program to setup schedules....then email them out to each individual consultants...I tried browsing for templates at Microsoft's site and found very little for my employer's (who is cheap and won't upgrade to office 2007) version of office pro 2002...
2007-06-26 02:38:00 · update #1
You'll need to have a table with all of the appointments & the details in it.
Then a Data-Entry form with "required fields" for them to use (a LOT easier than a series of prompts).
Also, You'll have to setup a second DB with the original tables linked, and build a loop in a VBA module using the DoCmd.Sendobject function to go through the consultants and email each one a report/query with the list of thier appointments.
This can take a week to put together & shake the kinks out of it when You know what You are doing. Since You have to ask, It's a little beyond your experience, but You can probably figure it out.
A good learning tool for stuff of this level is the Northwind SampleDB. It has instructions on writing the VBA code to do a lot of the stuff it does. Look it up in the Microsoft knowledge base.
2007-06-28 02:01:01 · answer #1 · answered by Capt Crasher 6 · 1⤊ 0⤋
Both programs can take a long time to master.
But if you want to give it a go, check out
learnthat.com
microsofttechnet.com
good luck!
For formulas and troubelshooting issues.
2007-06-26 09:21:51 · answer #2 · answered by Beck92 4 · 0⤊ 0⤋
Do a public calendar in Google and have your parties sign on there. It sent remiders to you and them to their email addresses
2007-06-26 20:05:17 · answer #3 · answered by Ivan 2 · 1⤊ 0⤋
Crikey, my best answer would be to hire someone to do it... or take a year long advanced Access and Excel course...
2007-06-26 08:40:53 · answer #4 · answered by nzseries1 4 · 1⤊ 1⤋
Try this link
2007-06-26 09:10:01 · answer #5 · answered by AnalProgrammer 7 · 0⤊ 0⤋