I posted this problem earlier in the month and some one decided it was
better to change the subject and ask a completely different question.
I am therefore reposting. I am hoping some one can assist with this.
Thanks in advance.
I have an access database that i have added a pop up calendar to, the
Table information for the Date Reported field is
Date/Time
format short date,
input mask is 00/00/0000.
i have created a combo box on the form and have bound the control to
the Date Reported field. I have placed the calendar control on the
form and set the Visible property to no.
The following code has bee added to the Mouse Down Event of the Date
Reported combo box.
Private Sub Date_Reported_MouseDown(Button As Integer, Shift As
Integer, X As Single, Y As Single)
' show calendar and set date
Calendar.Visible = True
Calendar.SetFocus
End Sub
The folowing code has been added to the Click event for the calendar
control.
Private Sub Calendar_Click()
' Set Date reported to selected date and hide calendar
Date_Reported.Value = Calendar.Value
Date_Reported.SetFocus
Calendar.Visible = False
End Sub
When i go back to the form and click on the combo box control i
receive an error stating. "The value you have entered isn't valid for
this field." This is displayed twice before showing the calendar. I
am
able to clcik on a date in the calendar and it si then displayed int
he combo box control.
I am at a loss to fix this.
Please advise.
Thanks
Karl 3 2685
On 17 May 2007 00:51:53 -0700, "th****@gmail.com" <th****@gmail.com>
wrote:
I have a hard time following your logic - perhaps that's why you're
not getting many responses.
You have a combobox that you want to put a date in using a calendar
control??? Then you fiddle with the MouseDown event, ignoring the fact
that people can interact with a dropdown using the keyboard only (e.g.
Alt+CurDown)???
DateReported should probably be a textbox, bound to the DateReported
field in the underlying table or query. If you want to help the user
with a calendar control (you don't mention which one - every one is
different), you actually need to know how to write some code to show
that calendar (perhaps in a modal form) and upon selection put the
value in the desired textbox.
One alternative is to use the "Microsoft Date and Time Picker
Control". You can find it in your toolbox under ActiveX controls. No
programming needed, just put it in the place of the DateReported
textbox.
-Tom.
>I posted this problem earlier in the month and some one decided it was better to change the subject and ask a completely different question. I am therefore reposting. I am hoping some one can assist with this. Thanks in advance.
I have an access database that i have added a pop up calendar to, the Table information for the Date Reported field is Date/Time format short date, input mask is 00/00/0000.
i have created a combo box on the form and have bound the control to the Date Reported field. I have placed the calendar control on the form and set the Visible property to no.
The following code has bee added to the Mouse Down Event of the Date Reported combo box.
Private Sub Date_Reported_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single) ' show calendar and set date Calendar.Visible = True Calendar.SetFocus End Sub
The folowing code has been added to the Click event for the calendar control.
Private Sub Calendar_Click() ' Set Date reported to selected date and hide calendar Date_Reported.Value = Calendar.Value Date_Reported.SetFocus Calendar.Visible = False
End Sub
When i go back to the form and click on the combo box control i receive an error stating. "The value you have entered isn't valid for this field." This is displayed twice before showing the calendar. I am able to clcik on a date in the calendar and it si then displayed int he combo box control.
I am at a loss to fix this. Please advise. Thanks Karl
On May 18, 12:31 am, Tom van Stiphout <no.spam.tom7...@cox.netwrote:
On 17 May 2007 00:51:53 -0700, "tho...@gmail.com" <tho...@gmail.com>
wrote:
I have a hard time following your logic - perhaps that's why you're
not getting many responses.
You have a combobox that you want to put a date in using a calendar
control??? Then you fiddle with the MouseDown event, ignoring the fact
that people can interact with a dropdown using the keyboard only (e.g.
Alt+CurDown)???
DateReported should probably be a textbox, bound to the DateReported
field in the underlying table or query. If you want to help the user
with a calendar control (you don't mention which one - every one is
different), you actually need to know how to write some code to show
that calendar (perhaps in a modal form) and upon selection put the
value in the desired textbox.
One alternative is to use the "Microsoft Date and Time Picker
Control". You can find it in your toolbox under ActiveX controls. No
programming needed, just put it in the place of the DateReported
textbox.
-Tom.
I posted this problem earlier in the month and some one decided it was
better to change the subject and ask a completely different question.
I am therefore reposting. I am hoping some one can assist with this.
Thanks in advance.
I have an access database that i have added a pop up calendar to, the
Table information for the Date Reported field is
Date/Time
format short date,
input mask is 00/00/0000.
i have created a combo box on the form and have bound the control to
the Date Reported field. I have placed the calendar control on the
form and set the Visible property to no.
The following code has bee added to the Mouse Down Event of the Date
Reported combo box.
Private Sub Date_Reported_MouseDown(Button As Integer, Shift As
Integer, X As Single, Y As Single)
' show calendar and set date
Calendar.Visible = True
Calendar.SetFocus
End Sub
The folowing code has been added to the Click event for the calendar
control.
Private Sub Calendar_Click()
' Set Date reported to selected date and hide calendar
Date_Reported.Value = Calendar.Value
Date_Reported.SetFocus
Calendar.Visible = False
End Sub
When i go back to the form and click on the combo box control i
receive an error stating. "The value you have entered isn't valid for
this field." This is displayed twice before showing the calendar. I
am
able to clcik on a date in the calendar and it si then displayed int
he combo box control.
I am at a loss to fix this.
Please advise.
Thanks
Karl- Hide quoted text -
- Show quoted text -
Thanks for the reply.
What i am trying to do is had a popup calendar appear when the date
control on a form is selected, then once a date is selected show that
date in the date field and close the calendar.
I have tried a few different ways i am am able to get the calendar to
appear and insert the selected date, then close the calendar. However
i recieve an error indicating that the value for the field is not
valid. when i click okay it closes the error message and everything is
okay.
On May 21, 4:01 pm, "tho...@gmail.com" <tho...@gmail.comwrote:
On May 18, 12:31 am, Tom van Stiphout <no.spam.tom7...@cox.netwrote:
On 17 May 2007 00:51:53 -0700, "tho...@gmail.com" <tho...@gmail.com>
wrote:
I have a hard time following your logic - perhaps that's why you're
not getting many responses.
You have a combobox that you want to put a date in using acalendar
control??? Then you fiddle with the MouseDown event, ignoring the fact
that people can interact with a dropdown using the keyboard only (e.g.
Alt+CurDown)???
DateReported should probably be a textbox, bound to the DateReported
field in the underlying table or query. If you want to help the user
with acalendarcontrol (you don't mention which one - every one is
different), you actually need to know how to write some code to show
thatcalendar(perhaps in a modal form) and upon selection put the
value in the desired textbox.
One alternative is to use the "Microsoft Date and Time Picker
Control". You can find it in your toolbox under ActiveX controls. No
programming needed, just put it in the place of the DateReported
textbox.
-Tom.
>I posted this problem earlier in the month and some one decided it was
>better to change the subject and ask a completely different question.
>I am therefore reposting. I am hoping some one can assist with this.
>Thanks in advance.
>I have an access database that i have added a pop upcalendarto, the
>Table information for the Date Reported field is
>Date/Time
>format short date,
>input mask is 00/00/0000.
>i have created a combo box on the form and have bound the control to
>the Date Reported field. I have placed thecalendarcontrol on the
>form and set the Visible property to no.
The following code has bee added to the Mouse Down Event of the Date
>Reported combo box.
>Private Sub Date_Reported_MouseDown(Button As Integer, Shift As
>Integer, X As Single, Y As Single)
>' showcalendarand set date
>Calendar.Visible = True
>Calendar.SetFocus
>End Sub
>The folowing code has been added to the Click event for thecalendar
>control.
>Private Sub Calendar_Click()
>' Set Date reported to selected date and hidecalendar
>Date_Reported.Value =Calendar.Value
>Date_Reported.SetFocus
>Calendar.Visible = False
>End Sub
>When i go back to the form and click on the combo box control i
>receive an error stating. "The value you have entered isn't valid for
>this field." This is displayed twice before showing thecalendar. I
>am
>able to clcik on a date in thecalendarand it si then displayed int
>he combo box control.
>I am at a loss to fix this.
>Please advise.
>Thanks
>Karl- Hide quoted text -
- Show quoted text -
Thanks for the reply.
What i am trying to do is had a popupcalendarappear when the date
control on a form is selected, then once a date is selected show that
date in the date field and close thecalendar.
I have tried a few different ways i am am able to get thecalendarto
appear and insert the selected date, then close thecalendar. However
i recieve an error indicating that the value for the field is not
valid. when i click okay it closes the error message and everything is
okay.- Hide quoted text -
- Show quoted text -
I revisited my database and have been able to input a popup calendar
without the errors.
Thanks Karl This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Mark A. Washburn |
last post by:
The Julian Calendar, adopted in 46BC by Julius Caesar, adds one day every
four years to correct for the fact that Earth's solar year is slightly more
than 365 of Earth's daily rotations. ( 365.25...
|
by: Shuffs |
last post by:
Could someone, anyone please tell me what I need to amend, to get this
function to take Sunday as the first day of the week?
I amended the Weekday parts to vbSunday (in my code, not the code...
|
by: jacob henson |
last post by:
I have a user control with a calendar in it. when my main
page load with the calendar in it. the page has a java
script error. also if you try to use the calendar it give
a java script error. ...
|
by: Ben |
last post by:
I have a javascript code in the ASP.NET page.
I want to access Calendar control that is inside ASP page and is "run
at server".
I try to use following code but it doesn't work.
<script...
|
by: GV |
last post by:
Hi all,
New to developing in VS 2005 ASP 2.0
Trying to have a easy pop calender for a button on a web page.
I keep getting a error message in IE6 that says:
Line 69
Char 3
Error:...
|
by: jphelan |
last post by:
After opening and clicking on the popup calendar command control
button, "fdlgCal"; I click on a given date. The date is suppose to
then appear in a date field next to the control. Instead, I get...
|
by: thorpk |
last post by:
I have an access database that i have added a pop up calendar to, the
Table information for the Date Reported field is
Date/Time
format short date,
input mask is 00/00/0000.
i have created a...
|
by: mathewgk80 |
last post by:
HI all,
I am having popup calendar Javascript code. But i dont know how it is connecting to asp.net code.. I am using asp.net,c#.net and also using 3tier architecture with master page....
I...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
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...
|
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...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
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...
|
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,...
|
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,...
|
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...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
| |