J
JNariss
Hello,
I have created a database and am running into a few problems which I
thought someone out there can help me with. Here is the situation:
User logs on to my Intranet and clicks the link to open up the System
Request Change database. Opening the database will bring them to the
switchboard where they can choose to "Fill out a Reqest". This is a
form I created that I want the user to fill out and then click the add
record/email button. I have set this email button up to use the
SendObject command. However when I configure the SendObject to open in
..rtf it pulls up a Word document containing every single record in the
table and puts them in a table format. So then I tried to use .html
extension. And this also sends each report in a horrible html format.
Next I tried using .xls and don't really want it to open up in a table
format like that.
I want the person receiving the email to simply be able to click on the
attachement and view the form/report that has been created. So I
thought my last option is to use a snapshot view.
Well..............everything was going fine until I tested it out once
again and received an email indicating that the attachment has been
blocked and my request.snp file chagned to a request.snp.txt file.
Now I don't know what to do. Any ideas on how I can establish the user
easily opening up the filled out request?
After I accomplish that I would like my user to be able to not only see
the request but then have the ability to go back into the database and
continue this request with the next form I have called
"Acknowledgement". I have linked these tables together using
relationships and primary and foreign keys. So basically once someone
fills out a request and sends the request via email, the person
receving the email should be able to view the request and then
acknowledge it.
Please help me to establish this database - I know Access has the
ability to do this, however I can't seem to figure out how to do this
and I need some serious help.
Thanks a bunch,
Justine
I have created a database and am running into a few problems which I
thought someone out there can help me with. Here is the situation:
User logs on to my Intranet and clicks the link to open up the System
Request Change database. Opening the database will bring them to the
switchboard where they can choose to "Fill out a Reqest". This is a
form I created that I want the user to fill out and then click the add
record/email button. I have set this email button up to use the
SendObject command. However when I configure the SendObject to open in
..rtf it pulls up a Word document containing every single record in the
table and puts them in a table format. So then I tried to use .html
extension. And this also sends each report in a horrible html format.
Next I tried using .xls and don't really want it to open up in a table
format like that.
I want the person receiving the email to simply be able to click on the
attachement and view the form/report that has been created. So I
thought my last option is to use a snapshot view.
Well..............everything was going fine until I tested it out once
again and received an email indicating that the attachment has been
blocked and my request.snp file chagned to a request.snp.txt file.
Now I don't know what to do. Any ideas on how I can establish the user
easily opening up the filled out request?
After I accomplish that I would like my user to be able to not only see
the request but then have the ability to go back into the database and
continue this request with the next form I have called
"Acknowledgement". I have linked these tables together using
relationships and primary and foreign keys. So basically once someone
fills out a request and sends the request via email, the person
receving the email should be able to view the request and then
acknowledge it.
Please help me to establish this database - I know Access has the
ability to do this, however I can't seem to figure out how to do this
and I need some serious help.
Thanks a bunch,
Justine