By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,711 Members | 2,130 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,711 IT Pros & Developers. It's quick & easy.

Open Form WIth Calendar Control To Specific Date

P: n/a
I have a form that has a specific date on it. I want to open another
form that has the Active Control Calendar on it. I want to open this
form to the specific date on the first form. I have searched this
forum high and low to find a solution and have tried virtually
everything mentioned, all to no avail. Some solutions even crash the
computer. Does anyone have any ideas?

Thanks

TD
Nov 13 '05 #1
Share this Question
Share on Google+
7 Replies


P: n/a
Your form with the specific date on it has to be open to do it.( It can be not
visible) Put the following code in the OnOpen event of the Calendar form:

Me!NameOfCalendarForm!NameOfCalendarControl.Value = _
Forms!NameOfFirstForm!NameOfSpecificDateTextBox

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"TDIOwa" <td****@hotmail.com> wrote in message
news:f0**************************@posting.google.c om...
I have a form that has a specific date on it. I want to open another
form that has the Active Control Calendar on it. I want to open this
form to the specific date on the first form. I have searched this
forum high and low to find a solution and have tried virtually
everything mentioned, all to no avail. Some solutions even crash the
computer. Does anyone have any ideas?

Thanks

TD

Nov 13 '05 #2

P: n/a
Reg
"PC Datesheet" <no****@nospam.spam> wrote in message news:<MC*****************@newsread2.news.atl.earth link.net>...
Your form with the specific date on it has to be open to do it.( It can be not
visible) Put the following code in the OnOpen event of the Calendar form:

Me!NameOfCalendarForm!NameOfCalendarControl.Value = _
Forms!NameOfFirstForm!NameOfSpecificDateTextBox

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"TDIOwa" <td****@hotmail.com> wrote in message
news:f0**************************@posting.google.c om...
I have a form that has a specific date on it. I want to open another
form that has the Active Control Calendar on it. I want to open this
form to the specific date on the first form. I have searched this
forum high and low to find a solution and have tried virtually
everything mentioned, all to no avail. Some solutions even crash the
computer. Does anyone have any ideas?

Thanks

TD

TD you can download an example popup calendar I've posted to the Utter
Access Discussion form, that does what your looking for. You can use
all or parts of it, if it will work for you. It also popsup beside the
text box it's been activated from. Paste the link below to your
browser, should take you to my post.
http://www.utteraccess.com/forums/sh...b=5&o=&fpart=1
Nov 13 '05 #3

P: n/a
I have tried all your suggestions and still am having problems. What
has me baffeled is that the procedure I was looking for worked perfectly
on another computer and when I went to this computer I started having
problems with the computer crashing. I have looked at all the
references on both computers and they are the same. Still open for
suggestions.

TD
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 13 '05 #4

P: n/a
Tom Dean <td****@hotmail.com> wrote in message news:<40**********************@news.newsgroups.ws> ...
I have tried all your suggestions and still am having problems. What
has me baffeled is that the procedure I was looking for worked perfectly
on another computer and when I went to this computer I started having
problems with the computer crashing. I have looked at all the
references on both computers and they are the same. Still open for
suggestions.

TD


If it works on one computer and not on another, it sounds like the
ActiveX Calendar control is not registered on the second computer.
What happens when you try to compile the code on the computer it's not
working on? If it fails and highlights the code with this ActiveX
control, then the control is not registered on that computer.
Nov 13 '05 #5

P: n/a
I'm still stumped on this one. I have continued to look for solutions
and have tried every trick that I can think of. The problem is that
when I open form 2 and try to have the ActiveX calendar show the date
on read from the calendar date field on form 1 I get the following
message:

MSACCESS caused an invalid page fault in
module <unknown> at 0000:00c6001e.
Registers:
EAX=00c6002c CS=0167 EIP=00c6001e EFLGS=00010286
EBX=0062f608 SS=016f ESP=0062f574 EBP=0062f6b4
ECX=00000009 DS=016f ESI=0062f608 FS=10c7
EDX=00000002 ES=016f EDI=00000001 GS=0000
Bytes at CS:EIP:
00 a0 2c 00 c6 00 1c 0b c6 00 00 02 00 00 2d 00
Stack dump:
65253640 00c61668 0043f35b 65255bfc 0062f608 00000000 00000000
00000000 00000000 00000000 00000000 00000008 00000000 0040b510
00000000 00000000

I can not understand why it works on one computer and not the other.
I have compiled the database and receive no errors. The references
are the same. I am open for suggestions....

HELP!!!
Nov 13 '05 #6

P: n/a
I'm still stumped on this one. I have continued to look for solutions
and have tried every trick that I can think of. The problem is that
when I open form 2 and try to have the ActiveX calendar show the date on
read from the calendar date field on form 1 I get the following message:

MSACCESS caused an invalid page fault in
module <unknown> at 0000:00c6001e.
Registers:
EAX=00c6002c CS=0167 EIP=00c6001e EFLGS=00010286
EBX=0062f608 SS=016f ESP=0062f574 EBP=0062f6b4
ECX=00000009 DS=016f ESI=0062f608 FS=10c7
EDX=00000002 ES=016f EDI=00000001 GS=0000
Bytes at CS:EIP:
00 a0 2c 00 c6 00 1c 0b c6 00 00 02 00 00 2d 00
Stack dump:
65253640 00c61668 0043f35b 65255bfc 0062f608 00000000 00000000 00000000
00000000 00000000 00000000 00000008 00000000 0040b510 00000000 00000000

I can not understand why it works on one computer and not the other. I
have compiled the database and receive no errors. The references are
the same. I am open for suggestions....

HELP!!!

TD

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 13 '05 #7

P: n/a
Tom Dean <td****@hotmail.com> wrote in message news:<40**********************@news.newsgroups.ws> ...
I'm still stumped on this one. I have continued to look for solutions
and have tried every trick that I can think of. The problem is that
when I open form 2 and try to have the ActiveX calendar show the date on
read from the calendar date field on form 1 I get the following message:

MSACCESS caused an invalid page fault in
module <unknown> at 0000:00c6001e.
Registers:
EAX=00c6002c CS=0167 EIP=00c6001e EFLGS=00010286
EBX=0062f608 SS=016f ESP=0062f574 EBP=0062f6b4
ECX=00000009 DS=016f ESI=0062f608 FS=10c7
EDX=00000002 ES=016f EDI=00000001 GS=0000
Bytes at CS:EIP:
00 a0 2c 00 c6 00 1c 0b c6 00 00 02 00 00 2d 00
Stack dump:
65253640 00c61668 0043f35b 65255bfc 0062f608 00000000 00000000 00000000
00000000 00000000 00000000 00000008 00000000 0040b510 00000000 00000000

I can not understand why it works on one computer and not the other. I
have compiled the database and receive no errors. The references are
the same. I am open for suggestions....

HELP!!!

TD

Could be that the ActiveX control on your form is corrupt? Try making
a duplicate of your form and then removing all the ActiveX calendar
controls. if that works, your Calendar controls are corrupt. If you
create a brand new form and drop a calendar control in it and run it
and it crashes then your ActiveX calendar control is corrupt and
should be replaced on that machine. one reason to stay away from
ActiveX controls...
Nov 13 '05 #8

This discussion thread is closed

Replies have been disabled for this discussion.