placement of code

  • Thread starter Thread starter Brigitte P
  • Start date Start date
B

Brigitte P

I have a user who does not have a form to open the
database but goes directly to the tables. I now want to
set Application.SetOption "Show WindowsInTaksbar", False
but don't know where to place this code. For users who
open the database with a startup option form, I placed the
code in the Load Event of the startup form which seems to
work fine, but I don't know what to do when there is no
startup form.
Thanks for any help.
Brigitte P
 
If you create a macro called AutoExec, it will run automatically when the
MDB is opened. There is a RunCode macro action you can use to execute code
stored in a standard module.

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.
 
All runs fine when I click on the macro or run the code by
itself but it DOES NOT execute automatically. Didn't make
a typing error; I named the macro AutoExec. Any idea what
I'm doing wrong.
The code is in a module named TaskbarOptions

Option Compare Database
Function GlobalOptions()
Application.SetOption "ShowWindowsInTaskbar", False
End Function

The macro is obviously named AutoExec
Action Run Code
Function GlobalOptions()

I think I did it all right, but don't know. If all else
fails, I can create an invisible dummy form with the code
behind and set it as the Start Up form. But I like the
option of an AutoExec macro because I could put all kinds
of thing in the code regardless of startup forms.
Thanks for helping with this.
Brigitte P.
 
I think I found the problem but don't know how to fix it.
The user must hold down the Shift Key to open the
database, thus the AutoExec macro is bypassed. Normally,
this is a fully secured database (has all our salaries in
it)and has code that allows me to get into the database
window via Macro and Code (supplied by Frank Miller via
the newsgroup), but the one user who is in charge of
budget, don't want a startup form but only the tables. I
left the code to run the bypass key enabled, so when she
holds down the shift key, the database window opens. A
user who doesn't know this, would only get a blank screen.
I suppose I overdid it with securing this database and
just allow her to get in without holding down the shiftkey
(her version is also fully secured). But maybe there is a
way to run the AutoExec Macro or invoke the code another
way, which is independent of the Shift Key.
Help is appreciated.
Brigitte
 
You can disable the shift key by-pass. But, then this means that all users
will NOT be able to use the shift key option...
 
In this scenario, there is no way for you to automatically run this code
when the user opens the database. The best that you could do would be to
create an 'AutoKeys' macro so that the user can set the option with a key
combination. I haven't done any work with AutoKeys macros recently, so can't
offer any details, but you should find the basics in the help file, and if
you get stuck I'm sure someone else here will be able to advise you.

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.
 
Back
Top