Create Data Input Form that looks like a table?

[NeilT123]

I have loads of data to enter into my database which has been given to me as printed tables.

Is it possible to create a data input form which looks like a table?

 

[MazeWorX]

take a look at continuous forms

HTH << MaZeWorX >> "I have not failed I have only found ten thousand ways that don't work

 

[missinglinq]

Actually a Datasheet View Form looks identical to table and should do fine if you're not looking to anything fancy but just straight data input.

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!

 

[TheAceMan1]

How are ya NeilT123 . . .

I'd go with [blue]MazeWorX 's[/blue] suggestion as forms in datasheet view loose alot of functionality. You can use the form wizard to generate the form.

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[NeilT123]

Thanks for the replies, I think I am missing something here.
I would like an input table that looks like this, where the asterisk is a field called NValue. The NValue is the data I need to enter so on opening a new table there may not be any data where the asterisk is.

Crop Type Wheat
SNS 0 SNS 1 SNS 2 SNS 3 SNS 4
Soil Type 1 * * * * *
Soil Type 2 * * * * *
Soil Type 3 * * * * *
Soil Type 4 * * * * *
Soil Type 5 * * * * *
Soil Type 6 * * * * *
Soil Type 7 * * * * *

Sorry the asterisks should be under the SNS headings.

I have tried continuous forms but all I can get is

CropType Soil Type SNS Index NValue
Wheat Soil Type 1 0 30
Wheat Soil Type 2 0 40
Wheat Soil Type 3 0 50
Wheat Soil Type 4 0 60
Wheat Soil Type 5 0 70

and so on.

I am not sure what to do next. Do I/can I base the table on a crosstab query?

 

[dhookom]

A crosstab query as you have probably found is not updateable. You can use code and/or queries to append to un-normalized temporary table for editing in the spreadsheet view. You will then need more code and/or queries to update/append to the normalized table.


Duane
Hook'D on Access
MS Access MVP

 

[missinglinq]

You'll notice, AceMan1, that I said

should do fine if you're not looking to anything fancy but just straight data input.

;0)>

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!

 

[TheAceMan1]

missinglinq . . .

Yes ... I noticed! ... mY POST AS not meant to lay yo aside!

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]