Forms

  • Thread starter Thread starter Andy
  • Start date Start date
A

Andy

I am in the early stages of creating a db for a work project that has hit me.
I have a lot of information to collect from a team of people and I have so
far created the table and form. Now I am stuck how do I send the form out for
people to complete and send back. The only other option I would have would be
to allow access on a network drive but I dont want to go this way as I would
like to keep the db read only.
So my question is what is the best way to collect the data i need. Using
Access 2003.
Many thanks in advance
 
Andy said:
I am in the early stages of creating a db for a work project that has
hit me. I have a lot of information to collect from a team of people
and I have so far created the table and form. Now I am stuck how do I
send the form out for people to complete and send back. The only
other option I would have would be to allow access on a network drive
but I dont want to go this way as I would like to keep the db read
only.
So my question is what is the best way to collect the data i need.
Using Access 2003.
Many thanks in advance
Click to expand...

An Access form can only be used within your MDB running under Access. It
has no functionality as a separate (external) entity that you can send to
someone.

Access 2007 has a feature like you're describing where you Email a "form" of
sorts/ The recipient fills it out and returns it, and then the data can be
imported into your database. 2007 is the only version that has this.
 
Andy,
one possibility is to use a Word form.
Use drop down lists etc on the master word form to have some control over
data entry.
You can email the form to everyone to fill in.
When they return the completed forms, use some code that allows you to
import the data from word forms.
I have a copy of code to do that.


Jeanette Cunningham -- Melbourne Victoria Australia
 
An old fashion way is to use an Excel spreadsheet for collection and then
import or link and append.
 
Back
Top