Calendar in access

[pm4698]

Hi there!
I need to insert a calendar in a form but in a specific way.
I want to have a form like this:

First column: Surnames
Second column: Property
(i get these columns with a query from the same table)
the other columns will be the days of the month.

Someway i have to select the month and the number of columns or the days change, so at each day i can choose through a combo box an option for each surname.


Any ideas?

Thanks in advance

 

[Access_guy49]

So you want one surname per day of the month? (Just trying to get some clearification on what you want)

Also, Does this have to be in one record, or would it be possible to re-jig your table structure to better accomodate this type of activity, perhaps using a one to many relationship.

 

[pm4698]

No, i want this:

1st column:all surnames from the table
2nd column: their "property" field
next columns will be the days of each month, but the records of these columns will be combo boxes which can take 3 values (which i will drag from a table through query)

i do not know if it can be done, but if it can, i would like to choose from a calender the month so the days - columns can adjust to each month's day

 

[vbaInet]

You're talking about dynamically changing the columns? What is the aim of this approach?

 

[pm4698]

Its not necessary for me to make it work (the dynamic change of the number of columns depending on the number of days per month ).

I can create a table with 31 columns (plus the 2 initial columns) and each time i can complete the table to the point i want.

But i would prefer the columns regarding the days of the month to change depending on the month.

 

[vbaInet]

Are you going to use forms to manipulate your data?

 

[pm4698]

This form will not save data anywhere.
I just want to have a general idea of what each employee do each day of the month - through the form and then print it or save it somehow to a file.

 

[vbaInet]

You could create your columns by using Yes/No data type or string data type (which returns Yes/No) indicating whether that day is in that calendar month. You get the number of days in the selected month from the calendar control and UPDATE.

 

[Access_guy49]

Yes, use the calendar control.
I would suggest using some code, on the "on update" event of the calendar control
Use a case statement, and make columns visible or invisible depending on the month.
example, partly in sudo code:

Select case Month
Month = January
day31.visible = true

 

[pm4698]

i want something like the attached file but in access.
The first 4 columns are dragged from a query from a table.the other columns will be days.

 

[vbaInet]

Having looked at your spreadsheet your requirements would require very good design and involve a generous amount of coding. Access guy49 and myself have given you some ideas for you to consider. Try looking through the forum's Samples Databases section for for databases that perform similar functions.

Unless someone on here has some other ideas?