473,390 Members | 1,343 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,390 software developers and data experts.

Open Form WIth Calendar Control To Specific Date

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
7 2725
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
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
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
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
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
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Filips Benoit | last post by:
A particular form - always the same - sometimes becomes corrupt after saving. Error msg = The expression On Open you entered as the event property settings produced the following error: A...
3
by: PerryC | last post by:
I have a Main Form, then a subform. There is a date field in the Subform that I want to be able to click on it, and a VBCalendar popup in the main form for me to choose a date (I don't want it on...
1
by: bill yeager | last post by:
I would like to place the currently selected date (retrieved from the database) on a calendar control which is embedded inside a datagrid. However, I can't find the ID of the control to do so....
0
by: KJBaham | last post by:
Hi, I've created many MS Access databases that report info from a DB2/400 system here, and I am trying to learn to put these into web applications. I am using the following walkthrough as a guide...
1
by: John Davis | last post by:
I am writing a program that allows user to select the date in a calendar, and it will update the text fields automatically. I created 2 forms. The first form has 2 text fields (start date and...
3
by: Stephen V | last post by:
Can anyone help me out with this problem. I would like to redirect/ go to another php page when my SQL insertion is done and also send a variable at the same time. the idea is, to come on my...
3
by: SelimZairi | last post by:
hi all, i am developing an application that use a specific calendar actually it uses 3 calendars hijri and gregorian and Umm al qura(not listed internaltional) for umm al qura calender i...
2
by: emsik1001 | last post by:
Hi Everyone I want to use a control called "Microsoft Date and Time Picker Control 6.0 (SP4)" on my form. So basically I want to double click a text box and transfer the date to the DTPicker...
4
by: phill86 | last post by:
Hi, I am trying to represent on a form time slots I have re-created the look of an outlook calendar on the form I have a table with the calendar bookings start and end time and there could be any...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.