Open Form WIth Calendar Control To Specific Date

TDIOwa

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

Subscribe Reply

2753

PC Datesheet

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!NameOfCalend arForm!NameOfCa lendarControl.V alue = _
Forms!NameOfFir stForm!NameOfSp ecificDateTextB ox

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdata sheet.com
www.pcdatasheet.com
"TDIOwa" <td****@hotmail .com> wrote in message
news:f0******** *************** ***@posting.goo gle.com...

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******* **********@news read2.news.atl. earthlink.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!NameOfCalend arForm!NameOfCa lendarControl.V alue = _
Forms!NameOfFir stForm!NameOfSp ecificDateTextB ox

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdata sheet.com
www.pcdatasheet.com
"TDIOwa" <td****@hotmail .com> wrote in message
news:f0******** *************** ***@posting.goo gle.com...
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

Tom Dean

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

Pieter Linden

Tom Dean <td****@hotmail .com> wrote in message news:<40******* *************** @news.newsgroup s.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

TDIOwa

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

Tom Dean

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

Pieter Linden

Tom Dean <td****@hotmail .com> wrote in message news:<40******* *************** @news.newsgroup s.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

Similar topics

2298

Unable to open form !!

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 problem occurred while 'DB-name' was communicating with the ole server or ActiveX controle. The form has a calendar-controle. I have eliminated the code in the OnOpen-event but the form stays corrupt!

Microsoft Access / VBA

2113

Step by step how to open a popup calendar on the main form?

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 the subform because there is not enough space). After the date is chosen, it will be send back to the subform. Thanks in advance. Sincerely, Perry

Microsoft Access / VBA

2158

retrieving the original value from a calendar control

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. During the "Edit" command of the grid, I have the following code: <code> If e.CommandName = "Edit" Then Dim myDatagridItem As DataGridItem Dim lblStartDate As Label Dim lblEndDate As Label

ASP.NET

293

Calendar Controls and Open Parameters

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 to create an application in visual basice. http://msdn.microsoft.com/library/en-us/vsintro7/html/vxwlkwalkthroughcreatingwebapplicationusingvisualcorvisualbasic.asp I've setup everything nearly the same as in the walkthrough. I'm using a...

ASP.NET

3434

Using the MonthView Control But Cannot Update the Text Field on Another Form

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 end date), and 2 buttons. When the user clicks the button, it will invoke the calendar form. Here's the code fragment for the first form: Private Sub Command1_Click() Dim instanceCalendarForm As CalendarForm Set instanceCalendarForm = New...

Visual Basic .NET

2747

how to open a php page automatically

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 page for the first time and not doing anything, then I fill up my form and insert the data (with the button "add request" and when the oci_execute is done go to another page. all I need to know is how to go to another page automatically... and...

PHP

2451

form manipulation

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 develooped a form to choose the date and this form contain this function

Microsoft Access / VBA

7406

Date and Time Picker (How to open it?)

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 control (I have this) then I want to open the DTPicker (using still the double click event) to show the calendar as would normally click it (to open the calendar). I hope this make sense. Do you know maybe how to do it? (VBA code) I cannot find...

Microsoft Access / VBA

2678

Calendar bookings represented on a room booking form

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 number of bookings in a day. The following code represents the column for the first day of the week (monday) and formats the text boxes accordingly if the room is booked. This all works fine but I have to have this code again to represent the...

Microsoft Access / VBA

8917

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

9426

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

9281

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

9200

The easy way to turn off automatic updates for Windows 10/11

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 Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

8148

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

6722

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

6022

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

3238

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

2680

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP