Log in

View Full Version : Is there a feature in access 2010 that can be used to be compatible with access 2007?



wedd
12-09-2011, 06:37 AM
Hi experts!

The Calendar feature is no longer available on Access 2010 as it is in Access 2007... is there an alternative way; I would like a user to click on a date and it displays what activity happened on that day or month or for several years. I am creating a booking scheduling system and would like the user to have the option to search for customer bookings clicking on a calendar's date and it pop-up with a form. Is there a feature I can either download that allows the features in access 2010 to be compatible with access 2007? I know this can be done on access 2007, but I would like to be able to do this on access 2010.

Can this be done, if so how can this be done? Thanks for all your contributions:friends:

HiTechCoach
12-10-2011, 10:56 AM
Hi experts!

The Calendar feature is no longer available on Access 2010 as it is in Access 2007... is there an alternative way; I would like a user to click on a date and it displays what activity happened on that day or month or for several years. I am creating a booking scheduling system and would like the user to have the option to search for customer bookings clicking on a calendar's date and it pop-up with a form. Is there a feature I can either download that allows the features in access 2010 to be compatible with access 2007? I know this can be done on access 2007, but I would like to be able to do this on access 2010.

Can this be done, if so how can this be done? Thanks for all your contributions:friends:

I thin you are referring to the Calendar ActiveX control. I think part of the reason it was dropped is that it was a 32 bot control and would not work with Access 2010 64bit.

Using ActiveX controls like the Calendar control can cause lots of deployment issues unless you have lots of experience in creating installer packages. Lots of people avoid them.

UI use a pop-up calendar created with only native Access controls. I have used it with for about 15 years with Access 2.0, 95, 97, 2000, 200, 2003, 2007, and 2010 with any issues. The only thing that I have changed is the appearance

For alternatives see: Calendar Links (http://www.hitechcoach.com/index.php?view=weblink&catid=78%3Aaccess-dates-tips-and-tricks&id=71%3Acalendar-links&option=com_weblinks&Itemid=23)

wedd
12-12-2011, 07:17 AM
Hi HitechCoach,

are you able to add a form to the UI pop up calendar? For example if a user wanted to schedule what meetings he wanted to do today...he could click on the date on the calendar and a form would pop up where he could write in his schedule or check his schedules for the day. Is this doable on the feature you described to me? Thanks!

wedd
12-12-2011, 10:24 AM
Please ignore the question. Thanks!!! I've managed to find an excellent calendar/schedule that exactly matches what I require. I've exported a copy of a calendar feature into my access 2010 dbase. If I change the code to adapt to my tables I have in my database and add additional field table names; which means I will have to change the queries to adapt to my table and form.. will there be any issues I may encounter when I open the reformatted forms and subforms with the pop up calendars, because it is a form copied into my database ? It seems to work fine but when I make the changes to the code and tables will there be any issues I have to be aware of?

Thanks

Wedd

wedd
12-12-2011, 10:28 AM
The source of the calendar is from CyberCow on UtterAccess.com...an access 2003 dbase.

HiTechCoach
12-12-2011, 03:52 PM
I have looked on CyberCow's time piece stuff. He does great work. I have not tried to incorporate it into any database so I can't give you any advice on what to watch for so you don't break it.

Make sure you have lots of back ups, I would test on a copy of your database (db).