forms with 2 dimensions (looking like a spreadsheet)

[stephanev]

Hello,

I'm trying to build a personnal budget application.

I need to build a form that looks like a grid.

On the first column, you will see the different budgets elements

On the top line (headers), you should see the different months of the comming year.

I already managed to build the necessary tables (with 2 keys in the table source for the form).

My questions are the following:

1) how can I build a forms that looks like a spreadsheet, proposing me every cells from the start (not only the cells that i have filled before)?

2) how can I make for this form to be dynamic ? This means that, if I add a budget element in the budget elements table, how can I make the form to be adapted automatically, adding a line under the others, for every months?

I have asked severall other forums, no one could answer me.

thanks for your help.

Stephane

 

[MarkK]

The results you describe are best provided by a spreadsheet. I suspect that to get Access to work for you you'll need a little more information on relational databases and an associated paradigm shift.
Cheers,
Mark

 

[stephanev]

?

This form I want to build is only the first step of my budgeting software.
In fact, it is just an help I want to build in order to fill all the yearly information (split by months), on a casual way, and allowing me not to link Excell and Access.

Once I have enterred the different budgets for the differents months, I will then fill every spending I have every day, in antoher form, and constantly compare that, for each budget, I'm not going over the allowed budget.

This way, I really need to create this spreadsheet in Access.

Note: I've had good relational database training in the past, thanks for your proposal.

 

[Pat Hartman]

This way, I really need to create this spreadsheet in Access.

Relational tables are not spreadsheets. There is no built in way to make a "spreadsheet" out of a table. You can use a crosstab query to acheive the look but the query will not be updatable. You'll need to handle all the updating with code.