Access always on top

[Mooch]

Hi guys,

Hope you can help.

I've created a database that opens a data entry form, once the requested
code is entered. I've resized the main Access window so that only the
Minimize, Maximize and Close 'buttons' are visible - but not accessible -
when the form is open (essentially, the user can only exit the application
using a command button on the form).

Here's my problem. The form is designed so that it takes up very little
space on the screen, about a tenth of it. However, it's designed for users
that need to have many applications open at any one time, including other MSA
databases of various window sizes. Not only does this mean that my data entry
form will get lost in the background, but the users will have to click on
each MSA tab on the task bar (or use Alt+Tab) in order to locate the form and
restore its view.

Is there a way for me to make the form (or a particular MSA database) be
always on top of other open applications? That would be so great!

Many thanks in advance, guys.

Regards,

PS: I'm using Access 2003/7 on Windows XP/Vista, respectively.

 

[Tony Toews [MVP]]

Is there a way for me to make the form (or a particular MSA database) be
always on top of other open applications? That would be so great!

Yes, I'm sure there is as the Windows Task Manager uses such. I would
suspect it's an API call. Or something that looks among the current
apps, finds the app title bar and brings it to the forefront. Note
that most VB 6.0 code works quite well in Access VBA.

I would suggest though that, like Task Mgr, you give the user the
option to not always force itself to always be visible. I, for one,
can find the program I need when I need it. And I'd be right ticked
at any developer who forced his software choices on me. Unless this
was a condition of employment upon which I'd seriously consider
telling management where they could go and what they could do when
they got there.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Mooch]

Many thanks for your reply, Tony.

I did mean (and should have said, in hindsight) if it was possible to give
the user the option to make a form or database always visible.

You have, however, answered my query; thank you, once again.

.... time now for some more research.