[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 618
  • Last Modified:

Calendar

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
davcos
Asked:
davcos
  • 6
  • 5
  • 2
  • +1
3 Solutions
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
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
 
davcosAuthor Commented:
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
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
davcosAuthor Commented:
"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
 
GRayLCommented:
>there is a small calendar that pops up.< - is not the popup in the form of a month?
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
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
 
davcosAuthor Commented:
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
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
"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
 
davcosAuthor Commented:
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
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Not sure.  Not on my A2010 system until tonight.

mx
0
 
BCipolloneCommented:
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
 
davcosAuthor Commented:
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
 
davcosAuthor Commented:
Thanks!
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
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

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

  • 6
  • 5
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now