Dobts in Create a Form

[gatarossi]

Dear all,

I would like to change my old sheets of excel for ms access. Then I
have in my sheets an expense control. In this sheet I have: code of
expense, the profit center, the date and the values.

I'm thinking in create a form to imput/include/exclude datas in my
table, but I'm having several problems. I'm thinking in create a form
and a subform like an excel sheet...

Form:
Profit Center: (combobox, the user will select the profit center)
Date: (Multiselect Listbox, the user will select the date).

SubForm: (now it's my problem, because I need that the user select a
expense code, and I would like to imput the values in colums like an
excel sheet

expenses code data selected1 data selected2 data selected3
salary 100
101 102
equipment 50
51 53

I don't know how to create this layout in my form. When I select a
date in my Multiselect Listbox, appear one column in my subform -
refering the date selected. And I don't know how I will actualize the
datas in my table whith this layout.

Please, I need ideas for solving this problem and the better is some
examples of expenses control form's.

I would be tankfull!

André.

 

[Guest]

Access is not Excel

How many data are you expecting to select for each expense code?

 

[gatarossi]

I think that is not a maximum number of dates. But I agree that in the
subform we need to put a limit for example 12 textbox acting the
dates.

Thanks!!!

André.

 

[Guest]

There is no limit but you still want to impose one? That is my point! Any
information that can be unlimited should be treated as records, not fields.
What happens if you have more than 12 dates?

Get some understanding of normalisation and data integrity. As I said,
Access is not Excel.