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
|
|
0
|
|
|
|
Reply
|
 Utf
|
3/9/2010 5:26:01 PM |
|
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@discussions.microsoft.com> wrote in message
news:76D6EF6A-4650-4A7C-9A53-C1EC1FCB77B3@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
|
|
|
0
|
|
|
|
Reply
|
George
|
3/9/2010 5:58:23 PM
|
|
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@penn.com
"Booksbio15" <Booksbio15@discussions.microsoft.com> wrote in message
news:76D6EF6A-4650-4A7C-9A53-C1EC1FCB77B3@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
|
|
|
0
|
|
|
|
Reply
|
Steve
|
3/9/2010 6:04:41 PM
|
|
"Booksbio15" <Booksbio15@discussions.microsoft.com> wrote in message
news:76D6EF6A-4650-4A7C-9A53-C1EC1FCB77B3@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
|
|
|
0
|
|
|
|
Reply
|
De
|
3/13/2010 5:33:54 PM
|
|
fhhjjjjk;kk
"Booksbio15" <Booksbio15@discussions.microsoft.com> a écrit dans le message
de groupe de discussion :
76D6EF6A-4650-4A7C-9A53-C1EC1FCB77B3@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
|
|
|
0
|
|
|
|
Reply
|
joelgeraldine
|
3/17/2010 1:18:46 PM
|
|
|
4 Replies
791 Views
(page loaded in 0.102 seconds)
Similiar Articles: how do i get a macro/code to open a specific switchboard page ...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 ... Re: How to do this with macro? - microsoft.public.excel ...how do i get a macro/code to open a specific switchboard page ... hi i have four switchboards (patient, staff, lists, accounts) with patient being default but i need to ... Open a form in filter by form datasheet view from Switchboard ...how do i get a macro/code to open a specific switchboard page ... Open a form in filter by form datasheet view from Switchboard ... I have tried using a macro from the ... Switchboard in Access 2010 - microsoft.public.accesshow do i get a macro/code to open a specific switchboard page ... How do I create a Switchboard form in Access 2010? - microsoft ... how do i get a macro/code to open a ... Switchboard and TreeView - microsoft.public.access.formscoding ...Here is all the code I have in the switchboard form ... and see if we just added an Open Switchboard ... Switchboard Form deleted, how do I get it back? - microsoft.public ... Default Area Code - microsoft.public.outlook.contactshow do i get a macro/code to open a specific switchboard page ..... four switchboards (patient, staff, lists, accounts) with patient > being default ... Load Switchboard Maximum - microsoft.public.access.forms ...Create a macro and name it ... startup I can have it open on maximum. I do have it opening to the switchboard ... Switchboard Form deleted, how do I get it back? - microsoft ... Macro or VB code to Export data to an Excel file? - microsoft ...Export excel sheet as text file with macro code Hi, How do I export a specific excel sheet (say sheet1) as a text file? I would like to do this with macro code. Possible to write a macro to print all attachments with specific ...how do i get a macro/code to open a specific switchboard page ... Possible to write a macro to print all attachments with specific ... In a Form, I want to run a Macro if ... How to maximize the Excel window? - microsoft.public.excel.misc ...This is the macro: Option Explicit Sub Auto_Open() Application ... macros: http://www.rondebruin.nl/code ... is opened by schedule task at specific time. Do you ... how do i get a macro/code to open a specific switchboard page ...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 ... how do i get a macro/code to open a specific switchboard page DataBasehi i have four switchboards (patient, staff, lists, accounts) with patient being default but i need to open the staff switchboard using either a macro o Create and use a switchboard - Access - Office.comThe Edit Switchboard Page dialog box appears. Click ... Go to Switchboard: Opens a secondary switchboard. Open Form in Add Mode ... Run Macro: Runs a macro (macro: An action ... Open the Switchboard maximized (full screen) Microsoft Access... specific ... vb code. My idea is, I want an autoexec macro to do a quick lookup to see which switchboard a user should get, then set that switchboard as default, then open ... SwitchboardFind business and people in Switchboard white and yellow pages directory. ... People Search; Yellow Pages; Reverse Phone; Reverse Address; Area Codes; ZIP Codes 7/26/2012 2:18:35 AM
|
Search |
Post Question |
Groups |
Stream |
About |
Register
71 followers. 