Your easiest and best suggestion requested

[m-squared]

I need to collect simple data from 350 people and would like to do it by
pushing a form to each and then just merging the data to one file. Is Access
the best method?

 

[Douglas J. Steele]

Assuming that all the users use Outlook for their e-mail, Access 2007 can do
what you're trying to do.

If you're using an earlier version of Access, or if some (or all) of your
users aren't using Outlook, there's no easy way.

 

[m-squared]

Doug, thanks for that suggestion. I suspected that Access would be the
easiest and that Outlook would somehow come into play. Unfortunately, this is
the 2003 version and there is no plan for the corporation to upgrade any time
soon. Any other solution? I thought about a shared worksheet in Excel but the
scientists are not that savvy...forms are the easiest way to collect data
from them. I need them to validate and add one additional piece of data to
their record. Thanks again for trying to help.

 

[Jeff Boyce]

Consider using a Word document set to look like a fill-in form but set to
save the data only. When they ship it back, you could import the data.

?!You have scientists who don't know how to open/use a spreadsheet?!

Alternatively, you could create a spreadsheet and modify it to display as a
form, then send it for their completion. Again, import the data into
Access.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Klatuu]

If you want scientists to understand it, write it in Fortran

 

[John W. Vinson]

If you want scientists to understand it, write it in Fortran

Hah. Nope. Quadrille-ruled lab notebook with coffee stains, lines for date and
signature (generally filled in months after the experiment is done), and
incomprehensible scribbles and diagrams.

John W. Vinson [MVP]