473,324 Members | 2,567 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

Emailing Form

I developed a small database for my supervisor that tracks the dates
employees wish to schedule for vacation, how many days they are
eligible for, how many they have taken, etc. He asked me if it is
possible for the employee to email the "form" he has completed to his
supervisor, who in turn would approve or reject the dates requested,
and email the "form" back to the employee. We would, of course, need
some type of authentication process. I'm sure I will have to use
another program other than Access (97, by the way) to do this. Does
anyone have any ideas how to do this?

Thanks,
JD
Nov 12 '05 #1
2 2532
Hello
It is possible to develop something like you describe, but may be you
will want to consider simpler way, which can be realised with MS
Access and doesn't involve sending forms via e-mail.

Place you database's backend on network and the front end on
everyone's PC. Create a form for users to fill in their requests.
Request's data goes into the backend.

You supervisor has got a form to check the request data. At the
moment, when user submitted his request, it is available for the
supervisor to view. He can enter corrections, or to click "Rejected".
At the moment, when supervisor submitted his corrections, they are
available to the user.

E-mail can come handy, because users and superviser will not look into
the database all the time. When user submits his request, an automatic
e-mail can be generated from MS Access informing the superviser that
there is something new in the database. Also, an automatic e-mail will
inform user about the supervisor corrections and decisition.

One of the advantages of filling in the data by user into database,
that your supervisor will not need to do it him/herself.

Hope it will be of interest to you.
Galina
jd****@yahoo.com (jd****@yahoo.com) wrote in message news:<75**************************@posting.google. com>...
I developed a small database for my supervisor that tracks the dates
employees wish to schedule for vacation, how many days they are
eligible for, how many they have taken, etc. He asked me if it is
possible for the employee to email the "form" he has completed to his
supervisor, who in turn would approve or reject the dates requested,
and email the "form" back to the employee. We would, of course, need
some type of authentication process. I'm sure I will have to use
another program other than Access (97, by the way) to do this. Does
anyone have any ideas how to do this?

Thanks,
JD

Nov 12 '05 #2
Thanks for the suggestion. However, this is not what my supervisor
wants. He wants forms that can be e-mailed, approved or rejected, and
returned. How can I accomplish this?

Thanks,
JD

ga*********@cityofbristol.ac.uk (Galina) wrote in message news:<cc**************************@posting.google. com>...
Hello
It is possible to develop something like you describe, but may be you
will want to consider simpler way, which can be realised with MS
Access and doesn't involve sending forms via e-mail.

Place you database's backend on network and the front end on
everyone's PC. Create a form for users to fill in their requests.
Request's data goes into the backend.

You supervisor has got a form to check the request data. At the
moment, when user submitted his request, it is available for the
supervisor to view. He can enter corrections, or to click "Rejected".
At the moment, when supervisor submitted his corrections, they are
available to the user.

E-mail can come handy, because users and superviser will not look into
the database all the time. When user submits his request, an automatic
e-mail can be generated from MS Access informing the superviser that
there is something new in the database. Also, an automatic e-mail will
inform user about the supervisor corrections and decisition.

One of the advantages of filling in the data by user into database,
that your supervisor will not need to do it him/herself.

Hope it will be of interest to you.
Galina
jd****@yahoo.com (jd****@yahoo.com) wrote in message news:<75**************************@posting.google. com>...
I developed a small database for my supervisor that tracks the dates
employees wish to schedule for vacation, how many days they are
eligible for, how many they have taken, etc. He asked me if it is
possible for the employee to email the "form" he has completed to his
supervisor, who in turn would approve or reject the dates requested,
and email the "form" back to the employee. We would, of course, need
some type of authentication process. I'm sure I will have to use
another program other than Access (97, by the way) to do this. Does
anyone have any ideas how to do this?

Thanks,
JD

Nov 12 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Steven Scaife | last post by:
There seems to be a problem with my emailing code, although during testing it worked fine. What happens is it sends two emails instead of one, and also doesn't put any text in the email for some...
9
by: Brendan MAther | last post by:
I have a table called Contact_Info. I have a form that allows me to show all the contacts from a specified city and sector. Once these contacts appear on my new form I would like to be able to...
2
by: Chuck | last post by:
I have a database that has a table in it with employee information (name, dob, email, etc). This is joined to a table that has tasks that are assigned to each individual that has a recurring date....
5
by: Colin Anderson | last post by:
I discovered, with great excitement, this article http://www.davison.uk.net/vb2notes.asp when researching methods for emailing from Access via Notes. Unfortunatly, when I run this I get a...
1
by: Alfie | last post by:
I've got a form, and I'm trying to set up a way of emailing from it. Does anyone know, if I've got an email address in a field called , is there a way that I could create a command button which,...
2
by: Paul Wilson | last post by:
Hi guys, In classic ASP, i used to enable emailing from a webpage using the following code, lcData = "mailto:?CC=" + lcCC + "&subject=" + lcSubject + "&body=" + lcBody...
4
by: Mike Moore | last post by:
What is the best way to launch outlook from an asp.net web page? Can you do this using MAPI or is there a control that you can purchase? We are unable to use SMTP. We use MS Exhange and MAPI...
1
by: dman | last post by:
Hi, I am a total newbie to asp.net. I have spent the last week or so trying to find a good tutorial that would show me how to create a form that would be entered into a SQL database and then...
0
by: paulhux174 | last post by:
Emailing a web page to several addresses Hi, I need to send the contents of a web page to several email addresses (4). Some elements of the Form I want to hide for some and some elements of the...
1
by: crisostomofred | last post by:
I have a report with it's source from a query. The query calls data from 3 related tables. The report is a meeting agenda and I only want to attach a snapshot report to my email based on the...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.