Date in forms

[sandrao via AccessMonster.com]

I would like to have a command button that I could use to insert a date in a
date field.
the date would be for scheduling events at the beginning of each week, hence
I would like the dates to be for the beginning of each week. First date
could be 04-mar-07 the next record in the date column would be 11-mar-07.
Each record would have the beginning of the week date.

 

[Guest]

Hi Sandrao,

If your skills in access are very good you could create a procudure in
Modules to do this for you.

If you are a newbie Can I suggest the following to you:-

In excel create a field with the first date you want to use use auto fill to
the last date you want.

Then

Import date table into access in a separate table. (This includes every day
of the week which can be used of other purpose.)

Then run a query to show a day of the week.

Then in your form create a combo box from this table (using the start of the
week as a filter) and then after update event copy this date your field in
your table.

This should solve your problem.

If you need any help on any of the task please reply and I will help you.

(It my be long winded but this way imporves your basic access skills)

Regards

Trev