Form User Interface and Email help

[JNariss]

Hello,

I am developing an Intranet for my company. We have something called a
System Change Request which is a form a user fills out when they want
to request a change in the system. I created a database using Access
and have also created a Form for my users to fill in. I would like to
do a few things with the form. First off, I would like to upload the
form to my Intranet so when an employee logs on to the Intranet and
clicks the button that says "System Change Request" it will take them
to a form online. The form online I want is the one I created using
Access. Is there a way to do this and if so how? Next I want to be able
to let my employees submit the form and once it is submitted it will
update the database as well as email 4 managers to notify them that
there is a System Change Request Form that has been filled out. I know
that by filling out the form and clicking the submit button will easily
update the database but how can I go about the emailing to managers?

Any help will be fantastic I feel like I have been searching online for
the past 4 hours on how to do this and have not come up with a single
thing!!!!!

Thanks,
Justine

 

[Allan Murphy]

Just a suggestion, having very limited experience with Intranet, I would
link your button using a hyperlink to your database. Set the startup of your
database to the form so that when the user clicks on the button the form is
displayed etc.

The following is part of some code that I use to send multiple copies of an
email.

I have a field called email_ss which stores the email addresses of users who
require notification of any updates. Using a table allows me to make changes
without changing the code each time an user changes.

There is only record in this table with an id of 1. The email_ss field is of
a type MEMO, this allows more than 255 characters.

"Updates Complete for " & Date + 1, "", is the title of the email and
displays the tomorrow's date each time it is generated.


Dim email_ss As String
Dim temp_email_ss As String

temp_email_ss = DLookup("[email_ss]", "[tbl_update]", "id=1")
email_ss = temp_email_ss

DoCmd.SendObject , "", "", email_ss, "", "", "Updates Completed for " &
Date + 1, "", False, ""

 

[JohnGriffiths]

Sounds like ADP (Access Data Page)

Creating Secure Data Access Pages
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k/html/securedap.asp

I've never used them so I cannot be much help - John

The alternative of creating a html front-end should be straight forward if
using IIS/PWS and ASP (VB like environment for web apps), as well as giving
you more experience for your resume.

Just a suggestion, having very limited experience with Intranet, I would
link your button using a hyperlink to your database. Set the startup of your
database to the form so that when the user clicks on the button the form is
displayed etc.

The following is part of some code that I use to send multiple copies of an
email.

I have a field called email_ss which stores the email addresses of users who
require notification of any updates. Using a table allows me to make changes
without changing the code each time an user changes.

There is only record in this table with an id of 1. The email_ss field is of
a type MEMO, this allows more than 255 characters.

"Updates Complete for " & Date + 1, "", is the title of the email and
displays the tomorrow's date each time it is generated.


Dim email_ss As String
Dim temp_email_ss As String

temp_email_ss = DLookup("[email_ss]", "[tbl_update]", "id=1")
email_ss = temp_email_ss

DoCmd.SendObject , "", "", email_ss, "", "", "Updates Completed for " &
Date + 1, "", False, ""


--
Allan Murphy
Email: (e-mail address removed)

Hello,

I am developing an Intranet for my company. We have something called a
System Change Request which is a form a user fills out when they want
to request a change in the system. I created a database using Access
and have also created a Form for my users to fill in. I would like to
do a few things with the form. First off, I would like to upload the
form to my Intranet so when an employee logs on to the Intranet and
clicks the button that says "System Change Request" it will take them
to a form online. The form online I want is the one I created using
Access. Is there a way to do this and if so how? Next I want to be able
to let my employees submit the form and once it is submitted it will
update the database as well as email 4 managers to notify them that
there is a System Change Request Form that has been filled out. I know
that by filling out the form and clicking the submit button will easily
update the database but how can I go about the emailing to managers?

Any help will be fantastic I feel like I have been searching online for
the past 4 hours on how to do this and have not come up with a single
thing!!!!!

Thanks,
Justine

 

[JNariss]

Thanks to both of you for your help.....I will take your advice and try
it out. It will be my project tomorrow to figure out!!!!!