Need a Forms expert

M

mromyn

Hi -

I have data in a table, that would be much more user firendly if it were in
a spreadsheet. Since everythign else i am using the table for is in
Access...I am using access.

Users will need to make occasional updates to this table. Ideally this data
would be in a Form, and the form would have rows and columns like a
spreadsheet. The form would also show all of the data that is in the table
and allow the user to update the data.

Is this possible? If so, does anyone have any examples?

Thanks!
Mel
 
B

BruceM

All data entry should be done by way of forms. Users should not enter data
directly into tables. I'm not sure what you mean when you say a spreadsheet
is more user friendly, but I expect you mean you are familiar with Excel and
would prefer that Access be in the same general format. You may want to
consider whether it is truly better for the user in that format. With a
Single View form (or a Continuous form, to some extent) you have complete
flexibility to group data in a way that makes the most sense to the user.
If you were to build a paper form for name and address you would tend to put
FirstName, MI, LastName on the first line, then Address on the second line,
City, State, Zip on the next line. A Single View form can be similarly
constructed.

That being said, you can use AutoForm to create a form based on tne table.
Switch to design view. Click View >> Properties to open the form's Property
Sheet. Click the Format tab, and choose Datasheet as the Default View.

Continuous forms are best for just a few fields. If the user needs to
scroll back and forth you may do well to reconsider the spreadsheet format.
 
Top