Solved

Calendar

Posted on 2010-11-10
14
608 Views
Last Modified: 2012-05-10
Why can't I find the built in calendar in access 2010.  I'd like to insert it in a form.  Widows 7(64bit)
0
Comment
Question by:davcos
  • 6
  • 5
  • 2
  • +1
14 Comments
 
LVL 13

Accepted Solution

by:
BCipollone earned 84 total points
ID: 34106311
0
 
LVL 75

Assisted Solution

by:DatabaseMX (Joe Anderson - Access MVP)
DatabaseMX (Joe Anderson - Access MVP) earned 41 total points
ID: 34106585
MSCAL.ocx has been removed in O2010 because Access 2010 has a built in calendar control now.

If you want MSCAL.ocx, I can up loaded it to you, which I did a couple of days ago for another Q.  You can just put it in any folder and set a Reference to it.

mx
0
 

Author Comment

by:davcos
ID: 34106642
I did see that article when I fist got the calendar errors in Access 2010.  I see now that in the fields that I have formated as dates, there is a small calendar that pops up.  I'm just trying to get that "month view" in a form without installing more software.  I guess I don't really understand why the calendar is not built in to Access?  Makes no sense.  I would expect to see it right there with "Combo Box" and "Chart"  I had another "expert" here say that there was a "built in" calendar yesterday, but I can't find anything about it.

Again, I have very limited knowledge of visual basic and my database consist of mostly of tables queries and forms that I created through the built in wizards...  This database was started in 1993 with the first version of Microsoft Office Professional.

0
Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

 

Author Comment

by:davcos
ID: 34106683
"MSCAL.ocx has been removed in O2010 because Access 2010 has a built in calendar control now." DatabaseMX


So, how do you use the "built in" calendar control, is it just a part of the "date" formated field?

Thanks,
0
 
LVL 44

Expert Comment

by:GRayL
ID: 34106690
>there is a small calendar that pops up.< - is not the popup in the form of a month?
0
 
LVL 75
ID: 34106756
I haven't used it yet.

Since you already have forms with the old calendar control, to jump start yourself with this ... why not just use the old OCX?

Rename the extension on the upload from MDB to OCX.

mx
MSCAL.mdb
0
 

Author Comment

by:davcos
ID: 34106796
My concern was why MS decided that the OCX file wasn't good for the database.  There must be a reason that they have decided not to include it any longer, right?
0
 
LVL 75
ID: 34106817
"reason that they have decided not to include it any longer, right?"
The reason is because there is a built in calendar in Access itself.  Nothing to do with 'good or bad'

mx
0
 

Author Comment

by:davcos
ID: 34106908
That's kind of back to the original question, how do I find it?  Is it only accessible through VB?  I don't see any mention of it in the help file...
0
 
LVL 75
ID: 34106933
Not sure.  Not on my A2010 system until tonight.

mx
0
 
LVL 13

Assisted Solution

by:BCipollone
BCipollone earned 84 total points
ID: 34113845
Microsoft recommends using something else for the calendar functions. They removed it so below are some alternative options.

1.Use datepicker. Here is an example on the datepicker- http://office.microsoft.com/en-us/access/HA102835451033.aspx 

2.Use other 3rd-party calendar controls that are available on the Web. Here are a couple of community  provided calendar controls:
¿http://www.granite.ab.ca/access/calendars.htm
¿http://www.accessmvp.com/JConrad/accessjunkie/calendars.html
0
 

Author Comment

by:davcos
ID: 34113960
BCipollone, I did look at some of those, but wasn't thrilled with some of the installation instructions, just trying to keep things simple.  The mscal.OCX file DatabseMX sent will work for now.  I've looked again at the "built in" and I think it's just the calendar that pops up with the "date" field, and the current help file says it was there in Access 2007, which I do believe is correct.

Thanks for looking at this
0
 

Author Closing Comment

by:davcos
ID: 34113967
Thanks!
0
 
LVL 75
ID: 34115670
This is my favorite 3rd party calendar (free) ... generated completely on the fly from code with a LOAD of features:

http://www.lebans.com/monthcalendar.htm

mx
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Search for text in a .txt file 14 40
Access query expression 6 19
FrontEnd tools to create web database application 7 53
Calculation in Access 5 22
The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

815 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now