D
dbguy_atlanta
I'm evaluating a jump from Access 2002/2003 to 2007 for complex Access
applications (many forms, many reports, significant amount of code, etc.).
I'm aghast at the poor performance, odd latencies, and massive (mostly
needless) reorganization of 2007 but still considering it for various
reasons. At the moment I'm more concerned with something I (think) I've found
that I find very ominous. When you look at what Microsoft has done and not
done as far as custom menus, toolbars, and ribbons in 2007, it almost seems
as though they want to discourage serious application development with
Access. Hopefully I'm wrong and have missed something in 2007. Please confirm
if the following is correct or not...
1. Custom toolbars and menus created in earlier versions of Access work fine
(for the most part) in 2007 but there's no way to modify them (other than
with VBA) in 2007? Microsoft's answer is to use previous versions of Access
for this purpose? Huh?
2. Microsoft provides no way to easily create and modify custom ribbons??
I've seen references to third party tools and a messy manual approach (adding
rows to some table and writing XML) but unless I've missed something
Microsoft felt this was not really necessary? Again, huh?
I'm hoping I'm wrong on both counts and somebody can point me in the right
direction to customize a menu system in 2007.
I know some would suggest a switchboard instead but with previous versions
of Access I've been able to write applications that look and behave like
commerical applications and I'd like to continue that approach.
Thanks in advance.
applications (many forms, many reports, significant amount of code, etc.).
I'm aghast at the poor performance, odd latencies, and massive (mostly
needless) reorganization of 2007 but still considering it for various
reasons. At the moment I'm more concerned with something I (think) I've found
that I find very ominous. When you look at what Microsoft has done and not
done as far as custom menus, toolbars, and ribbons in 2007, it almost seems
as though they want to discourage serious application development with
Access. Hopefully I'm wrong and have missed something in 2007. Please confirm
if the following is correct or not...
1. Custom toolbars and menus created in earlier versions of Access work fine
(for the most part) in 2007 but there's no way to modify them (other than
with VBA) in 2007? Microsoft's answer is to use previous versions of Access
for this purpose? Huh?
2. Microsoft provides no way to easily create and modify custom ribbons??
I've seen references to third party tools and a messy manual approach (adding
rows to some table and writing XML) but unless I've missed something
Microsoft felt this was not really necessary? Again, huh?
I'm hoping I'm wrong on both counts and somebody can point me in the right
direction to customize a menu system in 2007.
I know some would suggest a switchboard instead but with previous versions
of Access I've been able to write applications that look and behave like
commerical applications and I'd like to continue that approach.
Thanks in advance.