Can a calendar load a form based on date clicked?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bayou BoB - 24 Jan 2004 03:17 GMT

Hello.

I had a second question that I thought I'd place in a seperate
message.

As an add-on to the current database design, I'd like to have a form
that just comes up entitled "Schedule Check" and just have the form
contain the calendar control. I would like to have the user click on
whatever date they want to check, and see that day's activities only.
I have the form constructed that will show the records, now i just
need to know how to use this first form with a calendar to access the
form. I'm pretty sure I'm describing this alright, but in case I'm
not, The "Schedule Check" form pops up, and displays the calendar. The
user clicks on February 2nd, and up comes the scheduling form with the
records from February 2nd. How would I go about doing this? Many
thanks. I truly appreciate it!!

Kevin

Reply to this Message

Alex Dybenko - 24 Jan 2004 06:51 GMT

say in onclick event of textbox with date write:

dim varDate as variant
varDate=screen.activecontrol.value
if isdate(varDate) then
docmd.openform "Schedule Check"
forms("Schedule Check").axCaledandar.value=vardate
end if

futhermore you can put this in a function, and call it for all textboxes
with dates

Signature

Alex Dybenko (MVP)
http://Alex.Dybenko.com

> Hello.
>
[quoted text clipped - 14 lines]
>
> Kevin

Reply to this Message

Bayou BoB - 24 Jan 2004 19:51 GMT

I'm not sure I'm understanding correctly Alex. The "Schedule Check"
form would only contain the calendar. You load the form from the
switchboard, and up comes this form with a calendar in it. When you
click on another date other than today, I'd like a form to load that i
have already made, that displays the record from that date selected.
If I am writing in the onclick event of the textbox with the date in
the second form, how will it know the calendar has selected a date, if
that second form isn't even loaded yet? Should there not be some code
in the calendar's events somewhere that specifies that the second form
needs to load on pressing the date on the calendar? Thanks. This is
all quite new yet and some of these elements are a bit confusing to
me.

Just to clarify:

frmScheduleCheck (The form containing only the calendar)

-Calendar Control
-Close Button

frmTodaysSched (The form that will show the records for that day after
a date on the calendar has been selected)

-ActDate
-Activity
-Destination
-StaffinCharge
-VanRequired
-Close Button

Kevin

>say in onclick event of textbox with date write:
>
[quoted text clipped - 26 lines]
>>
>> Kevin

Reply to this Message

Alex Dybenko - 25 Jan 2004 07:48 GMT

yes, i this case you have to check what date is clicked in calendar form,
and open second form. sorry, first i didnt understand this

Signature

Alex Dybenko (MVP)
http://Alex.Dybenko.com

> I'm not sure I'm understanding correctly Alex. The "Schedule Check"
> form would only contain the calendar. You load the form from the
[quoted text clipped - 58 lines]
> >>
> >> Kevin

Reply to this Message

lilei - 15 Mar 2004 09:43 GMT

?????? ??????????;????????????????;????????????????????;??????????
????????????????????????????????????????????????????????????????????????????
;?;???;????;???????

Reply to this Message

spamfurnace - 15 Mar 2004 23:28 GMT

> ?????? ??????????;????????????????;????????????????????;??????????
> ????????????????????????????????????????????????????????????????????????????
> ;?;???;????;???????

Yeah that happens to all of us. My advice is to use the backspace key
and dont drive for at least 24 hrs.

hth
Richard

Reply to this Message