Microsoft Access 2007 upgrade

[Book]

I have Access 2000 on my computer and I was wondering if I bought the Access
2007 update would I have any issues upgrading since Access 2000 is a much
older version?

 

[Douglas J. Steele]

Take a look at what Allen Browne has at
http://www.allenbrowne.com/Access2007.html

 

[GP George]

Keep in mind that MS has announced the release date for Access 2010--> May
12th. You might want to take that into account in deciding on your upgrade
path.

 

[roccogrand]

Great news GP,

Do you know if MS added ActiveX controls, specifically the calendar control,
back into the product?

David

 

[GP George]

No. The calendar control is probably gone for good. However, the native date
picker introduced in 2007 is quite good, IMO.

The biggest new features IMO are the addition of data macros, which are
similar to triggers on SQL Server, and, of course, Access Web Services which
allow you to create browser based applications to run on SharePoint.

George

 

[roccogrand]

Thanks GP.

I may finally have to drop off the development sphere completely. I am
using multiple calendars in my reports to show important project dates, and
the date picker isn't the right solution for my dashboards.

David

 

[GP George]

Arvin Meyer has a good solution done with Access forms that you might
consider as an alternative.

http://www.rogersaccesslibrary.com/forum/topic461.html

 

[roccogrand]

Thanks again GP,

I'll check for non-MS tools like the Calendar when I try A2010.

But I want objects that I can insert into Reports and size according to the
number of such objects that I need in the Reports.

In my current application, I have six calendars in one report. Each calendar
is about two inches wide and 1.5 inches high. I can envision, having as many
as nine calendars in that report. When I copied Arvin's objects from his
Form into a Report, there is no calendar.

If there is another way to do this, please let me know.

David

 

[Tony Toews [MVP]]

But I want objects that I can insert into Reports and size according to the
number of such objects that I need in the Reports.

In my current application, I have six calendars in one report. Each calendar
is about two inches wide and 1.5 inches high. I can envision, having as many
as nine calendars in that report. When I copied Arvin's objects from his
Form into a Report, there is no calendar.

There might be something at the Calendar Tips page at my website
http://www.granite.ab.ca/access/calendars.htm

Duane Hookum has an awesome and simple calendar in a report. See the
Calendar Reports sample section at
http://www.access.hookom.net/Samples.htm

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
Granite Fleet Manager http://www.granitefleet.com/

 

[Peter Hibbs]

David,

Not quite sure what sort of calendar display you need for your reports
but perhaps this site may give you an idea :-

http://www.rogersaccesslibrary.com/forum/report-calendar-demo_topic540.html

HTH

Peter Hibbs.

 

[roccogrand]

Thanks Tony,

Duane's examples do some very nice things. Now I'll really have some new
code to learn from on vacation next month. It looks like Duane has probably
addressed a graphics positioning issue that caused me a problem last night.
I look forward to testing his code and I will credit him in my application if
I use it.

Thank you Peter. I checked out Roger's examples and none of them seemed to
work in my application, where as the ActiveX calendar is the perfect
solution. I hate to see it disappear in A2010.

David