Date Picker for Excel inserts a pop-up calendar into Microsoft Excel. It works like a drop-down calendar, offering a handy date selector. As long as the date picker app is running, it activates the pop-up calendar in all the Excel files you open. It does not require you to. Mini Popup Calendar, as its name states, is a calendar with a simple reminder feature. The reminder feature will let you enter a message to be displayed on a certain date and time of your choosing. The reminder feature needs the app to be running in order to work. To make best use of the reminder feature, add it to your login/startup items.
Is there a way to make the mini toolbar, with the attachment control, visible all the time?
Hy!
I've putted on calendar on an database but by example when I press first of June how can I make it recognise which week day is it?
Thanks
Hi All!
I have Access Calendar on my form. I named it txttoday. Which code and where should I put the code in order when I open my form I want the date always be on todays date. I guess it should be on Open and something like txttoday = now()....
Please advice,
B
Using an activeX calendar. I have 2 questions.
1) Is it possible to have certain dates always highlighted in the calendar so the user can clearly see these dates. What I'm looking for specifically is to have each second thursday always highlighted with another color.
2) Using a seperate form and calendar than the one above, how would I go about using a calendar to search for old records (apply a query to it maybe, but how would I do that?) so that when I click on a date, the records for that specific date are opened.
I really appreciate any help that anyone can offer with either question. If you leave an answer in code, can you please clearly define what you named each item that I may need to replace, i.e. Calendar, Date, etc., because I'm not incredibly familar with using code.
Thanks in advance for the help, I will be able to respond quickly if you have any questions or if I didn't explain anything clearly.
Hi All!
I have Access Calendar on my form. I named it txttoday. Which code and where should I put the code in order when I open my form I want the date always be on todays date. I guess it should be on Open and something like txttoday = now()....
Please advice,
B
I am trying to use a calendar to fill the date box on a simple form, I have used the examples from various threads on here but I cannot get the calendar to pop up.
The error message I get is
Run Time Error 2110
Microsoft Access cant move the focus to the control activeXCt161
Any thoughts on how I can fix the problem?
Hello,
I have seen pop up calendars in use in other databases and wondered if it was possible to put one into my current DB. (The standard little Microsoft style one).
Rather than using a direct entry date field in my form how do I go about adding in a pop up calendar. Can this be done easily?
Thanks
i cant hide the calendar when u open the form and i cant click a date without an error appearing help please
Hi all.
I'm trying tosetup a pop up calendar in my Access Database for users to select start and finish dates of activities. I have a calendar from here: http://www.utteraccess.com/forums/showflat.php?Cat=&Board=codearchive&Number=413286
Here is my problem, When I run the database 'Calender2000' it works fine. The calendar is displayed, but when I import the database (using get external data), and try running the calander, I get the following error:
'The expression you entered has a function name that Microsoft Office Access can't find.@.'
I am fairly new to Access, and currently using Access 2007. Any help appreciated (I can follow instructions in Access 2003 format).
sugar05
I am getting myself into knots trying to solve this can anyone help:
I need a calender so that the user can book and check availability of courses for each date. ie course 1 has 5 places on this date, once one is booked then there should be 4 places left.
Does anyone know if there is a graphical form available which I can use for this function and serve the dual purpose of data entry?
Hi, I have find this calendar, wich is great for me as my ACCESS program is in italian and all calendars I have find gives me back date and month values in italian, this one I can set it either italian or english!!!
What I need is to make it visible on double clicking on the date on a form and once opened selecting the dae on the calendar it returns the value onto my date field on the form.
Thanks
Marco
I would like to create a text box that when it has focus a calendar pops up, allows the user to select a date and then disappears after a date is selected, leaving the date (mm/dd/yyyy) in the textbox. Anyone know where code may be available -- I am willing to pay for it? Thanks ...
Please pardon my ignorance, but how do I set up a ActiveX calendar in Access? The help files are missing from the version of Access 2000 I am using, and I really don't know what I am doing. I would be grateful for any help with this.
Thanks.
Hi,
I've created a database to keep track of schedules, and have created a report that displays like a calendar.
Similar to Pat's example here
http://www.google.com/url?sa=D&q=http://www.access-programmers.co.uk/forums/showpost.php%3Fp%3D288791%26postcount%3D17
What I would like to do now, is create a DAP that will display in a similar format. But because the report uses subreports, it doesn't just tranfer over.
Does anyone have any ideas on how to create a simlar calendar format, within a DAP?
We want to use this on our intranet, so everyone can see each others schedules, and this is the only thing left I have to do. I just can't seem to get anything to work.
thanks
Chris.
Help!
I just created a calendar pop-up for data entry in Access Version 2002 and it does not work with Access 2003. Any help from anybody would be appreciated!
Does anybody know if MSCAL.Calendar.7 can be set so that Sunday shows as the first day of the week instead of Monday.My company uses a timesheet with a week begginning on Sunday.
Thanks
Is there a way to insert a calendar on a form from which a user can select a Month year and day similar to using the calendar on Outlook or Lotus Notes to set up or view appointments or meetings?
I use the Calendar ActiveX to select a date.
The calendar have a dropdownlistto post the selectede date?
I the calendar to dissapear after the date is selected. The selected date should remain in the drop down list.
I think that the control have a dropdownlist to show the selection, but i didn't found it.
Thanks,
Richard
Trying to add to my DB. Looking to be able to keep track of time worked on stock parts on a weekly basis. Would like to be able to enter time at the end of the week, by week. IE; On the week of Sept 10th 29 hours were dedicated to restocking our shelves with stock parts. Is there an easy way to accomplish a calendar setup like this, as I seem top be over complicating the issue I think. If someone could point me in the basic direction on this that would be great.
I have been trying to find a calendar that I can put on a form to set up reminders, notes, and other things. I have had no luck finding such a thing.
I tried using Calendar Control 9.0, but that will not work for my needs.
If anyone knows where I can get a calendar like this, or if there is some sort of code that will make this happen, please let me know.
Thanks in advance,
PuJo
'On The Bayou'
Hi,
I was wondering if there was a way to make a calendar in Access 2003? I work in a group of 60 employees and we track their vacation, and personal days in a web-based application. The web-based application is going away, as it it no longer supported. Could I use Access to create a calendar for the 60 employees and have it require a user name and password for them to log into the database to look at what vacation they have?
Would Visual Basic or C++ be a better program for this?
Thanks,
Chris
Not sure if this is the right place
But do any of the calendar's available open a day to a time slot type expanded daily record.
i've seen one that lets you put notes on a whole day.
Hope you get what I mean
Hello everybody,
I have a simple calendar on form. I would like my program to perform some action as I change the dates on the calendar, for instance assign the value of that specific date that I click to a 'txtBoxA' which is on the same form. How would I do this.
The calendar data property says:
Control Source _______________
OLE Class Calendar
Class MSCAL.Calendar.7
Thank you very much.
I am looking to place a calendar in a form. I am using access 2000. When I go to calendar control in ActiveX Control, the options are: Close, Regiser.., Unregister. When I click register it opens up a window where I can choose a control, when I choose the calendar control from C:Program FilesMicrosoft Office and hit OK, nothing happens.
Could the pop-up calendar, launch by a command button from a switchboard be used to change dates [beginning date - ending date] for a query to retrive records for a specific period with the other criteria in the query remaining the same.
Add a mini monthly calendar to your spreadsheet and use it to enter dates or the current time. Highlight dates from a selected range, choose different themes, toggle the size, show week numbers, or change the calendar system (US or ISO).
[ For Office 2013 and 2016 ]
This app for Excel is useful for working with time sheets, schedules, project plans, logs, and registers where you frequently need to refer to a calendar. The date picking function makes it easy to enter dates or the current time into the currently selected cell. You can highlight dates in the calendar by selecting a range of dates in your spreadsheet. You can also toggle the size of the calendar, show week numbers, change the calendar system (U.S. or ISO), and choose a different theme (blue, green, etc.).
FAQ ยป
(Update 12/6/2016): The app has been updated and changed to a FREE app. If you purchased the app back when it was not free, thank you very much for your support!
Although this is a useful add-in, it would be MUCH better if a mini Date Picker was a built-in feature of Excel. If you agree, then go to excel.uservoice.com to vote for this feature:Vote for a built-in Date Picker
This is a very useful feature, particularly if you are using a time sheet and want to highlight holidays and other non-working days.
When you change a date in the bound range, it will update in the calendar.
By clicking on the 'world' icon, you can change the calendar system to one of the following:
You can toggle the display of the week numbers on and off. When you are using the ISO 8601 calendar system, the week numbers will be based on that calendar system, where week #1 is the week starting with Monday that contains the first Thursday of the year. Otherwise, week #1 is defined as the week containing Jan 1.
It is often convenient to place the calendar in the header of a spreadsheet and use freeze panes so that the calendar is always shown. In these cases it may be useful to change to the smaller version of the calendar.
We've provide a few built-in themes so that you can choose the color scheme for the calendar. Just click on the theme icon to toggle between the different themes.
Most of the available themes are represented in the various screenshots shown on this page.
The example below shows the calendar embedded inside of Vertex42's free Time Sheet Template. Clicking on the clock icon will insert the current time into the currently selected cell. You can download the Excel template with the app already inserted, by clicking on the button below.
The example below shows the mini calendar embedded at the top of a check book register template. In this case, we can use freeze frames on row 9 so that we can scroll through the transactions in the table and still have access to the calendar at the top of the worksheet to insert the date of the transaction.
The Office Store still has a few bugs to work out. Currently, this problem occurs when the purchase is made on the web outside the context of the app. The current workaround to refresh the app token is to either:
a. Load the app inside Excel. Click on the Trial notification. Click the Buy Now button. Ignore the browser window where the app page online opens up, and go back to Excel. You should see a Refresh button at this time. Click the Refresh button to reload the app with the paid token
b. Navigate to this folder after replacing the <Your User> tag with the appropriate location: C:Users<Your User>AppDataLocalMicrosoftOffice15.0Wef. Clear the contents of this folder entirely. Then retry the whole process. This should force a refresh of the token as well.
[From this forum thread]This is another Office Store problem (not a problem with the app itself). It is usually solved by refreshing your apps. Go to Insert > Apps for Office > See All > Refresh. If the refresh doesn't work, you can try procedure (b) in the previous answer.
Unfortunately, writing to a spreadsheet from an Office app breaks the UNDO chain, just as normal VBA macros do. This is currently a limitation of Excel - not the app itself.
There are a LOT of rows in Excel, so avoid choosing ranges like columns that will require the app to process too large of a data set.