Jan 23 2006, 02:31 PM
I've had a problem with a user's machine . . . and it appears it can't find the 'Available Reference: Microsoft Project 10.0 Calendar Control'.
Is the the standard calendar is access? Or am I asking for a reference beyond access in MS Project?
I've been looking at the reference list and now I'm not sure.
Anyone use this control with or without this reference?
Jan 23 2006, 02:52 PM
It is not in the list of references on the Tools--->References list in the Code Window. However, if you get at it thru the More Controls... button on the Toolbox, that will put the reference in for you.
Jan 23 2006, 06:20 PM
Thanks Frank . . . your suggestion led to the answer . . .although I'm still a bit taken back by it all.
Recently, I had to import all of by FE ojects into a new 2000 db since it wouldn't compile.
That went great . . . everything worked.
But interestingly, rather than reference the MSCAL.OCX for the Microsoft 10.0 calendar control, I found that access referenced (I guess by doing the next best thing?) the Microsoft Project 10.0 Calendar Control instead.
So I've played around at bit as you suggested and found that when I start a new project, I can't see the Microsoft 10.0 calendar control in the reference list until I actually add the control to a form . . . even though I added it to the toolbar. That's just puzzeling . . .
In any event, I can get the reference w/o adding a calendar control by using the Browse button . . . maybe this is the behavior specific to Access 2002 . . . still not intuitive to me . . . if programming is ever!
Suffice it to say that it created problems for those users that didn't have MS Project on their machines . .. since it appears the Microsoft Project 10.0 Calendar Control works like the Microsoft 10.0 calendar control on users with Project.
So I'm redoing the references to a new FE . . . and I hope all will be right with the world!
Just goes to show you that you never stop learning about access . . . thanks again for the tip that lead to the answer!
Jan 24 2006, 10:53 AM
Steve, that sounds like an awful lot to go thru just to get the Calendar Control. I forgot about the Browse button anyway, I dislike navigating when I can just put the control on a form and get the reference.
I guess you're right, heck, for all I know, they both use the same file MSCAL.OCX and that's why it worked. Darned if I know.
Jan 24 2006, 02:09 PM
Best I can tell, when you drag the calendar control onto a form in design view, it makes the reference for you.
Why it doesn't show up in the references before hand is strange . . .
Why it tried subsituting the MS Project Calander references is stanger yet . . . when I imported all the objects into a clean db . . . but I did have a calander control on one form.
In any event, I guess there's no substitute for experience using access . . .one reason this site is so nice to have!
Jan 24 2006, 02:22 PM
Yes, I knew that. My guess is that there is something about the OCX file that keeps it from appearing in the list, there may be some attribute that can be set that controls whether or not it is displayed in the list. Or, possibly, it is one of several controls in the MSCAL.OCX file.
This site is extremely useful for all of us!
Jan 24 2006, 02:29 PM
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here