How to input data in an access form like ms excel?

[eko99312]

Dear All,

As you know that input data on excel is easy than access, you can simple click the date that you prefer and input the value that you want. For example :

Consider that the month that I use is November 2009 :
If i use excel it will look like this,

Country	Day in a month				
        1       2       3       4       5
Australia               4       3
China           5       2
England                 7
France          2       3
India   1
Italy   1                               8
Japan                           6

The column consist date in a month (until 30 for November 2009), the row consist the country (fix value / description).
In excel we can simply put a value on every row that we choose.

1. Does anyone familiar with data input on excel that could be apply in access form?
2. What should be prepare to get excel kind of display in ms access form?
3. In excel to change the month we can just simply move to copy the active sheet then rename it to next month name, Does it possible in ms access form?
4. A simple sample would be thankful if possible.
5. PS : How to align a column when asking a question (as you can see my table gone messy)?

Please kindly answer my question in easy language.
Thank you and regards,
Eko

[ChipR]

Using the [code ] and [/code ] tags (without the extra space) will allow you to line up your example properly because it uses a font with constant width characters. Until then, it's very difficult to tell what you are trying to do.

My general advice is, if you want to use a form that works like Excel for input, just use Excel and import the data into a table. Rewriting the Excel interface is not fun.

Also, have you planned out your tables such that there will be an advantage to using a relational database?

[NeoPa]

5. PS : How to align a column when asking a question (as you can see my table gone messy)?

The trick, when entering table data on the forum is :

1. Use the [ CODE ] tags (as Chip suggests).
2. Never use TABs for alignment. Always space out your data.