HELP - How do I create forms that users can complete outside Acces

G

Guest

I currently have a report created in Access. On the report I have entered 2
check boxes and a text box along with information from the database. Is
there anyway to make this report usable outside of Access?

The idea is to have the user check off whether or not they are completing a
process and then give a reason if they are not. However, when I export the
report to Rich Text (Word), both the check boxes and text box disappear,
leaving only the data.

Is there another way to save or export the report so that the check boxes
and text box can be utilized? I have tried just about every format that
Access had available.
 
D

dkv98446

If you want the document to be completed online consider creating an access
form, or if the document is to be completed by hand you could merge the data
into a Word template that has the check boxes and text box on it.
 
G

Guest

Thanks for the advice. The idea is for the user to complete the form
electronically and then e-mail the form back. I believe there are a few
problems with the Word template idea. I do not know how many yes/no boxes
there should be. Each location I create the form will require a different
amount of boxes.

When I do a "save as" on the report and choose MiscroSoft Data Access Page.
It is essentially exactly what I want. However, I cannot save the changes as
I check off boxes or enter in text. In addition, when I send the file
through e-mail it no longer populates the information from the database.

Any further advice?
 
G

Guest

One way is to create the form in Excel. Add a hidden sheet that references
each inputted field and place them in row 1 going across. When you recieve
the Excel file back import tha hidden sheet only.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top