Results 1 to 3 of 3
  1. #1
    Madmax is offline Advanced Beginner
    Windows Vista Access 2007
    Join Date
    Jun 2011
    Posts
    80

    Autoexec

    Does anyone have a simple Autoexec Macro or code with instructions on where to put it to run just like the macro. Just looking for it to close the ribbon and navigation pane and open the switchboard form. Please let me know if you have something. thanks.

    max

  2. #2
    jgelpi16 is offline Expert
    Windows XP Access 2010 32bit
    Join Date
    Mar 2010
    Location
    Charlotte, NC
    Posts
    544
    Why do you want to use a Macro vs. VBA code? I'm not well versed in Macros. However, if you use the below code in a form it will hide the ribbon. The Navigation pane can be hidden by going to File -> Options -> Current Database and then un-checking the "Display Navigation Pane" button under the "Navigation" category. What I would do is set up your AutoExec macro to open your "switchboard" form and in the Open even of the form place the ribbon hide code below. This should accomplish what you want.

    Code:
    On Error Resume Next
        If Application.CommandBars("Ribbon").Height >= 100 Then
            SendKeys "^{F1}", True
        End If

  3. #3
    Madmax is offline Advanced Beginner
    Windows Vista Access 2007
    Join Date
    Jun 2011
    Posts
    80
    thanks perfect!

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 06-20-2011, 09:20 AM
  2. AutoExec Mistake
    By HawkGuru in forum Programming
    Replies: 1
    Last Post: 04-23-2011, 04:48 AM
  3. Out of control loop in autoexec macro
    By accessnewbie in forum Programming
    Replies: 2
    Last Post: 08-19-2010, 04:31 PM
  4. Using parameter in autoexec macro
    By lchurch in forum Queries
    Replies: 0
    Last Post: 03-04-2009, 06:22 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums