Calender Control and date field

[KingRudeDog]

Using Access 03....

I created a form with a calender on it [frmCalender].

I placed a command button on my parent form, next to the date field [request_date]

How do I link whatever date I click on (in the calender) to appear in the [request_date] field?

 

[ejstefl]

There are many examples of this both on this site and on others. You can start with this link: http://www.fontstuff.com/access/acctut09.htm

If you still need more, I would suggest doing a search on this forum.

 

[adaniele]

king, i gave you an example in the other thread. thx, max.

 

[RuralGuy]

Download some of these calendars and see how they work! That is the best way to learn.

 

[Krij]

You name the calendar e.g.: MyCal
Now in the MyCal_Click event you'll write:

Me!txtfield.text = Me!MyCal.value

if you are using a listbox then you'll fill it with:

With Me!lstMyBox
.RowSource = ""
.ColumnCount = 6
.ColumnHeads = True
.ColumnWidths = "0cm;4cm;1cm;0cm;1,512cm;8cm"
.BoundColumn = 1
.RowSource = "SELECT SomeFields_From_Tables " _
& "FROM tblSomething " _
& "INNER JOIN etc " _
& "WHERE (((tblSomething.MyDate) = Forms!frmMain!MyCal)) " _
& "ORDER BY tblSomething.Anything;"
End With

Using Access 03....

I created a form with a calender on it [frmCalender].

I placed a command button on my parent form, next to the date field [request_date]

How do I link whatever date I click on (in the calender) to appear in the [request_date] field?