how do i get a macro/code to open a specific switchboard page
in [General]
|
From: Booksbio15 on 9 Mar 2010 12:26 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 9 Mar 2010 12:58 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 9 Mar 2010 13:04 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 13 Mar 2010 12:33 "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 17 Mar 2010 09:18
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 |