468,249 Members | 1,511 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,249 developers. It's quick & easy.

focus on a button, one at a time...

I'd like to add an 'Admin' form to my db, just a plain and simple (!) form
with 7 buttons, each button just runs macro1, macro2, macro3 and so on.
But - I'd like each button to only have focus after the preceding button
has been pressed (and the macro run). I'd like to fire this form up from
the db's startup form, and allow only 2 or 3 users to be able to operate the
button which runs the admin form. Any help mucho appreciated.

Thanks,
Lap


--
Thanks,
Chris
cc****@NOSPAMeclipse.co.uk
Nov 12 '05 #1
2 2493
Lap,

Set the Enabled property of all the command buttons to No.

To restrict access to the form, perhaps some sort of password entry
could be required, following which the first button is enabled. The
details of how to do this would depend on a number of factors, such as
whether it's just access to these buttons that you want to control, or
permission to open the form itself, and whether you would have
separate passwords for each of the 2 or 3 chosen ones, and whewther
the passwords would need to be changed periodically etc.

After that, you could enable the next button from the macro on the
previous button, e.g. use a SetValue action as the last action in
Macro1 to set the value of [Button2].[Enabled] to Yes, and so on.

- Steve Schapel, Microsoft Access MVP
On Tue, 9 Sep 2003 17:58:33 +0100, "Lapchien"
<cc****@NOSPAMeclipse.co.uk> wrote:
I'd like to add an 'Admin' form to my db, just a plain and simple (!) form
with 7 buttons, each button just runs macro1, macro2, macro3 and so on.
But - I'd like each button to only have focus after the preceding button
has been pressed (and the macro run). I'd like to fire this form up from
the db's startup form, and allow only 2 or 3 users to be able to operate the
button which runs the admin form. Any help mucho appreciated.

Thanks,
Lap


Nov 12 '05 #2
Thanks, I'll give it a go.
--
Thanks,
Chris
cc****@NOSPAMeclipse.co.uk

"Steve Schapel" <sc*****@mvps.org.ns> wrote in message
news:ip********************************@4ax.com...
Lap,

Set the Enabled property of all the command buttons to No.

To restrict access to the form, perhaps some sort of password entry
could be required, following which the first button is enabled. The
details of how to do this would depend on a number of factors, such as
whether it's just access to these buttons that you want to control, or
permission to open the form itself, and whether you would have
separate passwords for each of the 2 or 3 chosen ones, and whewther
the passwords would need to be changed periodically etc.

After that, you could enable the next button from the macro on the
previous button, e.g. use a SetValue action as the last action in
Macro1 to set the value of [Button2].[Enabled] to Yes, and so on.

- Steve Schapel, Microsoft Access MVP
On Tue, 9 Sep 2003 17:58:33 +0100, "Lapchien"
<cc****@NOSPAMeclipse.co.uk> wrote:
I'd like to add an 'Admin' form to my db, just a plain and simple (!) formwith 7 buttons, each button just runs macro1, macro2, macro3 and so on.
But - I'd like each button to only have focus after the preceding button
has been pressed (and the macro run). I'd like to fire this form up from
the db's startup form, and allow only 2 or 3 users to be able to operate thebutton which runs the admin form. Any help mucho appreciated.

Thanks,
Lap

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Philip Townsend | last post: by
11 posts views Thread by Alex.Svetos | last post: by
3 posts views Thread by jan.loucka | last post: by
reply views Thread by kermitthefrogpy | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.