Your easiest and best suggestion requested

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

m-squared - 28 Dec 2007 17:36 GMT

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?

Signature

Reply to this Message

Douglas J. Steele - 28 Dec 2007 18:11 GMT

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.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

>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?

Reply to this Message

m-squared - 28 Dec 2007 18:33 GMT

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.

Signature

> Assuming that all the users use Outlook for their e-mail, Access 2007 can do
> what you're trying to do.
[quoted text clipped - 6 lines]
> > Access
> > the best method?

Reply to this Message

Jeff Boyce - 28 Dec 2007 19:13 GMT

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

> Doug, thanks for that suggestion. I suspected that Access would be the
> easiest and that Outlook would somehow come into play. Unfortunately, this
[quoted text clipped - 18 lines]
>> > Access
>> > the best method?

Reply to this Message

Klatuu - 28 Dec 2007 20:47 GMT

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

Signature

Dave Hargis, Microsoft Access MVP

> 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.
[quoted text clipped - 34 lines]
> >> > Access
> >> > the best method?

Reply to this Message

John W. Vinson - 28 Dec 2007 23:57 GMT

>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]

Reply to this Message