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

[Lapchien]

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

[Steve Schapel]

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

[Lapchien]

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