Prev: NAS Drive
Next: juhgf
From: Booksbio15 on
hi

i have four switchboards (patient, staff, lists, accounts) with patient
being default

but i need to open the staff switchboard using either a macro or VBA

thanks
From: George Hepworth on
I assume by "switchboard", you are referring to an Access form which is
designed to function as a switchboard-type menu.

This line in a VBA procedure will open the specified form.

DoCmd.OpenForm "staff"

There are additional arguments which can be used to control how the form
opens. Search Access Help for more details.

Where and how you use this, of course, depends and where and how you want to
open the staff switchboard.

I suppose you can do this with a macro as well.



"Booksbio15" <Booksbio15(a)discussions.microsoft.com> wrote in message
news:76D6EF6A-4650-4A7C-9A53-C1EC1FCB77B3(a)microsoft.com...
> hi
>
> i have four switchboards (patient, staff, lists, accounts) with patient
> being default
>
> but i need to open the staff switchboard using either a macro or VBA
>
> thanks

From: Steve on
Switchboards are forms so you ought to be able to use the OpenForm method to
open the Staff switchboard. Put the following code in the Click event of a
button:
DoCmd.OpemForm "Staff"

This assumes the staff switchboard is named Staff.

Steve
santus(a)penn.com



"Booksbio15" <Booksbio15(a)discussions.microsoft.com> wrote in message
news:76D6EF6A-4650-4A7C-9A53-C1EC1FCB77B3(a)microsoft.com...
> hi
>
> i have four switchboards (patient, staff, lists, accounts) with patient
> being default
>
> but i need to open the staff switchboard using either a macro or VBA
>
> thanks


From: De Jager on

"Booksbio15" <Booksbio15(a)discussions.microsoft.com> wrote in message
news:76D6EF6A-4650-4A7C-9A53-C1EC1FCB77B3(a)microsoft.com...
> hi
>
> i have four switchboards (patient, staff, lists, accounts) with patient
> being default
>
> but i need to open the staff switchboard using either a macro or VBA
>
> thanks

From: joelgeraldine on
fhhjjjjk;kk

"Booksbio15" <Booksbio15(a)discussions.microsoft.com> a écrit dans le message
de groupe de discussion :
76D6EF6A-4650-4A7C-9A53-C1EC1FCB77B3(a)microsoft.com...
> hi
>
> i have four switchboards (patient, staff, lists, accounts) with patient
> being default
>
> but i need to open the staff switchboard using either a macro or VBA
>
> thanks

 | 
Pages: 1
Prev: NAS Drive
Next: juhgf