Formatting for mass data entry

[Dan]

Hello, I posted this same message in the Queries forum
already...so I appologize, but it may be more suited here.

I am putting together a simpler way to enter mass amounts
of data into a table. Initially I had a form that was
filled out and you could scroll through the records with
it. It would be simpler for everyone if I could make a
simple query (or somthing) with the field headings listed
down the left side, rather than across the top. Is there
some function that would allow me to do this? The reason I
want this is just so that the data fields for each record
can fit on the screen at once, without scrolling across.

Thanks in advance,
Dan

..

 

[John Spencer (MVP)]

Try a form in continuous view. That can give you all the fields in a scrollable
list, but it will only show one set of data per form, so you can't get multiple
columns with column 1 the field title, column 2 - record one's data, column 3 -
record two's data, etc.

You can end up with something like the following (the ------- represents the
break for the next record)

First Name: John
Last Name: Spencer

 

[Dan]

Thanks,
The only problem with that is I've got about 20 fiels to
enter and about 50 records per group, totalling 10,000
records. The first two fields are already filled in and
the next 18 must be filled in when the data is collected.

The most convenient way would be a horizontal table with
the field headings along the left side, like this,


First Name: John Roberta Anna 4 ... 50
Last Name: Spencer Jones Tershkova 4 ... 50

3: data data data data...data

.. . . . . .
.. . . . . .
.. . . . . .

20: data data data data data

This way you can see all the data for a single individual
at once, without scrolling. Then lock the first column
(the headings) and scroll to the right, through the
individuals. Easy to do in Excel but not Access. If this
isn't possible in Access, is there a way for Access to open
an excel spreadsheet and have it automatically update the
records back in Access? That may not have been clear...

I hope there is a way.
Thanks again,
Dan

 

[John Spencer (MVP)]

I'm sure it could be done with sufficient coding and a lot of work. But it
wouldn't be simple to do and wouldn't be simple to maintain. Even IF I did
figure all this out it would be way beyond the scope of the newsgroup to provide
a solution.

Perhaps you can find a professional developer who would be willing to implement
the solution you envision. But if they don't already have a developed solution I
would expect you might be shocked at the cost.

Even if you do it in Excel, you then have to write code to extract the
information column by column and bring it back into Access.

Good luck

 

[Guest]

hmm. Thanks, I was hoping it would be an easy task.
Thanks a lot for the help.

Dan