Access Applications

  • Thread starter Thread starter Jordan
  • Start date Start date
J

Jordan

I know that there are many commercial programs on the
market that are based on Access, but unless you knew what
Access was like, you'd never know. For example, I have a
swim meet managing program that I have figured was built
in Access. In fact, I'm sure most databases are like
this. My database is obviously in Access, mostly because
I'm not a highly advanced developer. I know that I can
create my own menus and toolbars and all, but how do I,
for example, make it so that the Database window does not
open? Or how do I make it so my application appears to
Windows as an application instead of a document (and thus
show up on XP Start Menu's recent programs list instead
of recent documents list)? Also, my swim meet program
can create multiple back-end databases and link to any
one of them. Is any of this possible without high-end
programming?
 
To hide the Db window (Acc2000 +)
select tools -> startup & uncheck show Database Window
for Acc97 you need WinAPI calls (available at www.mvps.org/access)

An Access Database *is* a document so your only choice to make it a
*program* would be to make a wrapper program (vb)

No, there's no simple way (but utility.mda and/or mvps should be helpful in
making the code needed)

HTH

Pieter
 
You can complete hide the ms-access interface with NO CODE!

All of the user settings and "stuff" you need to setup an application are in
the tools->startup menu.

Try downloading the 3rd example at my follow temp web site.

http://www.attcanada.net/~kallal.msn/msaccess/DownLoad.htm

If you run that sample application, you will note that none of the ms-access
interface shows..and I did NOT have to write ONE line of code to do the
above. (you can then exit..and use the shift key trick to view the
application).

So, I don't know what you mean by "high end" programming.

For sure, most developers use a split design (front end back end). For sure,
most developers prove a nice interface and means to re-link to that back end
in case you need more then one back end, or even if the system is moved.

I mean, if your users move the database..then how will they re-link? (it
would be silly NOT to provide a nice re-link interface..as you can't assume
your users know how to use ms-access).

There is some nice re-link code at:

www.mvps.org/access

So, between hiding the ms-access interface, and finding some example code to
re-link the tables..that part is quite easy. It is also easy to create
custom menus in ms-access (menus don't requite code to create). I actually
recommend that you start making custom menus for all your
applications..since every other windows program has them too!

However, putting together a nice polished application is a another matter!
(that is just a lot of hard work!).

Here is some tips on making your application easy to use:

http://www.attcanada.net/~kallal.msn/Rides/Why_hcs.html
 
Back
Top