By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,164 Members | 969 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,164 IT Pros & Developers. It's quick & easy.

My Access applications are getting messy.

P: n/a
I have a database of Access tables on the server and ODBC links to
legacy systems.
This is not too much of a problem as, at least, I have my tables/files
in 2 distinct places.
Unfortunately as seperate applications are required, separate program
databases have been created.
Some users have their desktops littered with short cuts pointing to
applications or parts of applications.
What I want is an all-encompassing menu system (with favourites, a bit
like web search engine) that can open any of the access applications.
Then I would have one start point for all programs and can tidy up the
desktops.

Any help/suggestions would be appreciated.

Mike
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Mike:

What I often do in cases like this is integrate the various screens of
each program into one, sometimes eliminating duplicated procedures or
even complete screens. This is basically the process of "condensing"
your applications. If you still need multiple apps, then create an
add-in that will allow each user to use the common functions/utilities
from each existing app in any database that needs them (e.g.:
CompactThisDB(), UpdateAttribute(strAttribName,varAttribSetting),
ExportToCSV(), etc.) This is work, no denying that, but the long term
order is well worth it.

Additionally, if you must leave things as they are but still want
shortcuts to specific screens, you can right click on a form and click
on "Create Shortcut...", which will create a shortcut on the desktop
or wherever you want. You can then put all of your shortcuts in a
common folder.

HTH.
JV

gi******@hotmail.com (Mike Ridley) wrote in message news:<e5**************************@posting.google. com>...
I have a database of Access tables on the server and ODBC links to
legacy systems.
This is not too much of a problem as, at least, I have my tables/files
in 2 distinct places.
Unfortunately as seperate applications are required, separate program
databases have been created.
Some users have their desktops littered with short cuts pointing to
applications or parts of applications.
What I want is an all-encompassing menu system (with favourites, a bit
like web search engine) that can open any of the access applications.
Then I would have one start point for all programs and can tidy up the
desktops.

Any help/suggestions would be appreciated.

Mike

Nov 13 '05 #2

P: n/a
In the Northwind sample database they have a switchboard, a form with
buttons that open other forms, like a table of contents. Maybe you
could start with something like that.

Unfortunately I don't know how to do Favorites as you suggest - unless
you make the whole thing web-based?

gi******@hotmail.com (Mike Ridley) wrote in message news:<e5**************************@posting.google. com>...
I have a database of Access tables on the server and ODBC links to
legacy systems.
This is not too much of a problem as, at least, I have my tables/files
in 2 distinct places.
Unfortunately as seperate applications are required, separate program
databases have been created.
Some users have their desktops littered with short cuts pointing to
applications or parts of applications.
What I want is an all-encompassing menu system (with favourites, a bit
like web search engine) that can open any of the access applications.
Then I would have one start point for all programs and can tidy up the
desktops.

Any help/suggestions would be appreciated.

Mike

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.