Results 1 to 4 of 4
  1. #1
    AmanKaur123 is offline Advanced Beginner
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jan 2017
    Posts
    47

    Make just the startup form visible to the users

    Hi All



    I have designed quite a big database with lots of forms,reports,queries and linked tables to it.

    I have set the start-up form to "FrmHome" so when the database is opened then the users can see FrmHome
    on the screen but also when the move the leftmost slide to the right then they can see everything.

    How to make the other objects hidden for the users?

    Any help will be much appreciated.

    Thanks

  2. #2
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    for the benefit of responders, crossposted here with answers https://www.access-programmers.co.uk...d.php?t=294300


    @Aman - please read this like about the etiquette of cross posting http://www.excelguru.ca/content.php?184

  3. #3
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442
    right click on the object (form/query/table) choose 'hide in this group'
    you may also want to consider hiding the ribbon bar and the navigation pane when the database starts, just be aware that anyone with a solid knowledge of access will be able to get around these simple hurdles.

  4. #4
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,016
    You could also do this in code, on the Form that shows on opening the database:

    Code:
    Private Sub Form_Load()
      DoCmd.NavigateTo "acNavigationCategoryObjectType"
      DoCmd.RunCommand acCmdWindowHide
    End Sub


    To bypass this, so that you can use the Nav Pane, you'll have to open the db while holding the <Shift> Key down; this will keep your 'opening Form' from opening, and the Nav Pane will show.

    Once again, a really savvy user could subvert this, but I think it's unlikely that the average user would know to use <Shift> Key to not show the opening Form, or that doing so would keep the Nav Pane from 'hiding.'

    Linq ;0)>
    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

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

Similar Threads

  1. Replies: 2
    Last Post: 06-12-2016, 07:53 AM
  2. Replies: 1
    Last Post: 02-27-2015, 10:01 AM
  3. Make form visible from VBA code
    By GraeagleBill in forum Programming
    Replies: 6
    Last Post: 12-16-2014, 04:19 PM
  4. Replies: 6
    Last Post: 08-22-2013, 05:35 AM
  5. Replies: 8
    Last Post: 10-26-2012, 09:17 AM

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