Yeah, seriously, I have no clue what revision I'm on. If however I am to count backups of my FE and prupose that I performed a backup just prior to a major addition or prior to a bug fix, then this would be the 58th iteration of the matrix. Neo got nothin' on me.

This is and isn't a massive change from my first post back in Jan '10. But you'll certainly see more content.

The splash page allows a user to set their default division/area of interest. This info is saved in the FE's DB properties. There is no security considerations at this point in development/use so I don't need to eliminate access, just make it friendlier.
Header and footers of all forms come from two sub forms and the name of the company (bot left) and division (top right) are pulled from the properties of the application. And the RTB button in the footer dynamically detects what form you have open and closes it appropriately.
I set the nav pane as shown with a custom category and hidden objects "not visible" to keep the confusion/curiosity level down.
The Location Switchboard section from my main page will be (sorta) dynamic depending on your default division.
Garage 49 switchboard is a pretty typical interface for my store's data entry/reporting home screen. The combo's are built from VBA code on the "On Got Focus" event so that the form loads more quickly. You'll note that the report section's command buttons are not enabled. That is until the corresponding combo box is populated. This allowed me to allow the reports to be generated with ALL data unless filtered. An option that would result in a very long generation process.
The audit switchboard will probably go through some changes in the next revision so as to be more dynamicly generated. Allowing cascading combos to drill down from div level to store level to time period etc. Right now, the two stores are the only ones that require these reports.
The satistics form is a back patting, ego stroking page that has no real value. The cmd button for the relationships table view does open a report I produced from the BE's Relationship view of tables, along with the stats listed and a few choice items from DB properties page.
Lastly the Application Maintenance and Contract Admin pages are what I had prepared to replace me when I stop working on the application and any Joe will be able to set-up their Div/stores and all necessary fields.

Hope you enjoy.

Scot,

Kudos - nice job. I'm suspecting the statistics page may generate more interest than you may give it credit. Along those lines, I'm wondering if you might be able to add one (or several) more statistic(s). Is it possible to calculate utilization/percent of capacity (I'm making an assumption this is a parking garage)? And calculate that over a meaningful period - a week or a month?

Outside of that, you're right - Neo ain't got nothin' on you!


AvgJoe (IMG:style_emoticons/default/hat_tip.gif)

You got it Joe. There are some things that just dont fit into our daily and monthly reporting. App Statistics became a kind of holding ground for anything that I might want to play with. Also it let me kind of "at a glance" remind myself of where my current BE was set to and what size things were at.

Clever and good looking! (IMG:style_emoticons/default/thumbup.gif)

+1