×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Any Like for Like replacement for Calendar in Access 2003?

Any Like for Like replacement for Calendar in Access 2003?

Any Like for Like replacement for Calendar in Access 2003?

(OP)
I am supporting a site who decided to upgrade some of their machines to Access 365 but leave some using Access 2003, with both versions using the same database.

When trying to create records containing dates in Access 365, the Calendar that appears when using Access 2003 does not appear and without it they are unable to create these records using Access 365. I understand that Microsoft did not support this Calendar in later versions of Access.

Is there such a thing as a list of Calendars that replace the ones used in Access 2003 (I believe it is Calendar 7) that will work in both Access 2003 and Access 365 or some way programmatically of loading different Calendars and their appropriate coding?

RE: Any Like for Like replacement for Calendar in Access 2003?

(OP)
The exact name of the Calendar is MSCAL.Calendar.7.

RE: Any Like for Like replacement for Calendar in Access 2003?

Daniel Pineault has a selection of Access calendar controls that might be of use but I believe this would require a redesign of your forms

Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016

RE: Any Like for Like replacement for Calendar in Access 2003?

I got sick of depending on library controls (and having to redesign every time there was a change), and, I also couldn't depend on said controls being available in secure environments, so I built my own form that emulates the usual calendar control functionality.

What you would assume to be a simple form is quite complicated (skipping through months, years, and ensuring day focus is correct is quite fiddly).
Functionally - it has all you'd require. (Month / year skipping, highlighting 'today', returning to 'this month' etc.).

View the image attachment, if you want a 'text' export of it - let me know.

ATB,

Darrylle

RE: Any Like for Like replacement for Calendar in Access 2003?

Yes calendars has allways been one of access's shortcommings.
I have seen Darrylls calendar before allthough his is one of the nice'r ones and I have a few that I use, some are Darryll look-a-likes, one is with the current date shown in a large orange square below the calendar itself and I even have a booking calendar screen wide incl. all kinds of reports.

But use darryll's as he says it has it all and looks good too, what more do you want smile

Herman
Say no to macros

RE: Any Like for Like replacement for Calendar in Access 2003?

(OP)
Hi Darrylles,

Thanks for your offer, I would appreciate a 'text' export of your calendar.

Hermanlaksko, thanks for your recommendation!

RE: Any Like for Like replacement for Calendar in Access 2003?

Hi torq,

I've uploaded a small app that contains 2 forms only: 1 is the calendar form, 1 is a small example calling form.
All code is documented.

I've had problems with command buttons not being raised (3d); I think it's a local installation problem - hopefully it's fine on yours (although for me - function is more important than form).

If you'd rather have this in another version, or pure text, then let me know.


ATB,

Darrylle

RE: Any Like for Like replacement for Calendar in Access 2003?

(OP)
Hi Darrylle,
Thanks for that - I will let you know how I get on!

RE: Any Like for Like replacement for Calendar in Access 2003?

I've been using a pop-up calendar I got from Access 97 Developer's Handbook and continue to use it in Access 365. It seems to work well for me.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close