Ok, so I'm looking at Access 2007, and I have imported my existing Access 97
application. I'm feeling a bit overwelmed in what to do here. In my original
97 application, I had one form: Mainmenu, which contained a header area /
customer selection area, and a subform. I had a custom toolbar that had a
button for each major screen. So clicking Customers would load the customers
form into the subform of the mainmenu. By choosing a customer in the header
area, it would then load the info into the subform.
I designed the system to follow along with the customer. So if you had
selected a customer in the header area of Mainmenu, then clicked the
"Invoices" screen button, the Invoice form would load into the subform of
mainmenu and you would see the history of all invoices created for the
current customer.
Here's a screen picture so you can see what I mean:
http://www.pcesoft.com/newres.html
Now, in 2007, I'm having ideas, but am still feeling lost as what to do. My
first thought was to abandon the mainmenu / submenu concept, and somehow
build a ribbon with the customer selection (header area of main screen), and
build a ribbon with a button for each screen name to replace the toolbar.
I've tried creating a sample ribbon, and as yet, cannot even get it to show,
even if I go under options for current database and select the ribbon. If I
set it to be the ribbon of the mainmenu form, it will show for a minute, but
then will be replaced by the default access ribbon.
Design-wise, and looking at the screenshot, I am just lost on how to
re-design such a complex screen to make it easier for the user!! Yikes...
I realize this is a lot to read, but would definetely appreciate the help of
a 2007 Access pro. Feeling a bit lost with 2007. I know I can't continue to
use the main design I have in the screenshot, and need to refresh the look
with ribbons, etc. But, wow, what a task this will be!
Thanks!
Andy
