473,326 Members | 2,012 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,326 software developers and data experts.

Calender / date control

I have a field called date . I want to have a drop down box which,
when you chick on it, will show a calendar. Upon selecting a date from
this calendar it will put the selected date in the “date” field. It is
a similar idea to what you see on travel websites when booking trips.

Any ideas. Thanks

Denis
Jun 27 '08 #1
3 1898
- date field should be text box
- add calendar to form, partially covering text box, and set calendar
visible = no
- code the text boxc click event:
1. opens ocx calendar
2. if date not empty, sets date of box to calendar, else sets as
today
- code calendar click event
1. set text box data to value of calendar
2. hide calendar
- after code works, have calendar control completely cover text box -
users should not have the ability to enter values directly

James Igoe

http://vba.wikidot.com/
http://code.comparative-advantage.com/
On Jun 9, 10:50 am, Leslie Porter OHV

On Jun 11, 11:43*am, Denis <denisphe...@gmail.comwrote:
I have a field called * date . *I want to have a drop down box which,
when you chick on it, will show a calendar. Upon selecting a date from
this calendar it will put the selected date in the “date” field. It is
a similar idea to what you see on travel websites when booking trips.

Any ideas. Thanks

Denis
Jun 27 '08 #2
ARC
In access 2007, date fields will automatically display a built-in calendar
button. Just fyi...
"Denis" <de*********@gmail.comwrote in message
news:1a**********************************@y38g2000 hsy.googlegroups.com...
I have a field called date . I want to have a drop down box which,
when you chick on it, will show a calendar. Upon selecting a date from
this calendar it will put the selected date in the “date” field. It is
a similar idea to what you see on travel websites when booking trips.

Any ideas. Thanks

Denis

Jun 27 '08 #3
Denis <de*********@gmail.comwrote:
>I have a field called date . I want to have a drop down box which,
when you chick on it, will show a calendar. Upon selecting a date from
this calendar it will put the selected date in the “date” field. It is
a similar idea to what you see on travel websites when booking trips.
See the Calendar Tips page at my website
http://www.granite.ab.ca/access/calendars.htm

There could, likely will, be lots of version problems when you go to distribute the
MSCal.OCX..

One alternative is MonthCalendar is a completely API generated Month Calendar derived
directly from the Common Control DLL. There are links to several downloadable
calendar forms at my website. As these are forms you can also do anything with them
you want.

You can also use the calendar form which comes in the Access <insert your version
hereDevelopers Handbook by Litwin/Getz/Gilbert, publisher Sybex
www.developershandbook.com. These books are well worth spending money. Every time I
open one I save the price of the book.

Duane Hookum has an awesome and simple calendar in a report. See the Calendar
Reports sample section at http://www.access.hookom.net/Samples.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
Jun 27 '08 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

8
by: PerryC | last post by:
I want to be able to accomplish this, please help: When click on the DOB field, a ActiveX Calender popup and the user choose a date, the value is automatically refreshed in the DOB field in the...
4
by: Chris | last post by:
Hi, I am trying to create a popup calender so a user can click on a button on the main form, a calender will then popup, the user will select a date and then click ok on the popup. The date will...
3
by: Learner | last post by:
Hi there, I have a text box in my webform to type in a date. I want to take advantage and use the calender control to let the user just to click on the clander and select a date. How do i...
2
by: jack | last post by:
Hi, Im creating a attendence project for which im using a callender control .. in this im making the user to click on the button with will enter the current date and time in the database . is it...
6
by: Lobster | last post by:
Hey everyone, I'm having trouble manipulating the calender object in vba. I have a form with a Microsoft calender control object 9.0 embedded in it. All I want to do is upon opening this form, set...
1
by: Doug | last post by:
Hi, How do I get a Calender Control popup to appear near the button which activated it, rather than on the other side of the screen? (MS Access 2000)
7
by: gubbachchi | last post by:
Hi all, In my application I need to display the data fetched from mysql database after the user selects date from javascript calender. I have written the code in which after the user selects the...
1
by: moksha | last post by:
hi friends, In my application i have date field.To enter date i want to calender control. When i keep my cursor on textbox calender should popup and the selected value in calender has to...
21
Vkas
by: Vkas | last post by:
i had created my own web calender control!!!! it consist 1} text box (it display's the selected date) 2} button (it hide and show the calender control) 3} calender control (use for the selection...
1
by: xtremebass | last post by:
Hello Bytes, i have a calender program which is created by using Javascript. when i execute that program using Internet Explorer,it works properly but when i tried in Mozilla firefox it didnt...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...

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.