Results 1 to 3 of 3
  1. #1
    Heatshiver is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Dec 2011
    Posts
    128

    Question Checkbox to Permanently Close Form

    I have a simple DB that needs to be distributed to a few computers. I know that they will have to "enable content" the first time they use the DB.

    I would like to make an initial form where there is a checkbox that when checked will ensure that the initial form no longer appears.



    The initial form is just some instructions to explain how to enable the content the first time. The checkbox would set respective parameters to not only allow this first form to never show again, but to make the 2nd form display as the 1st form when opening the DB from then on.

    I am unsure how to make a checkbox (or other viable switch) by macro, in code, or otherwise do the above.

    Please help.

  2. #2
    Robeen is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    Mar 2011
    Location
    Tulsa, Oklahoma.
    Posts
    1,596
    You can have a Table to store the Computer Name or User Name of each user and then have a field in that table that stores the Checked or Unchecked value for the user.

    Then - you can have code in the Form Load Event of your Main Form that hides the Main Form and shows the 'Initial' form if the checked value for that user is False in the Table you created.

    Hope this helps.

  3. #3
    Heatshiver is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Dec 2011
    Posts
    128
    The user doesn't matter and I actually need help specifically with the coding portion.

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

Similar Threads

  1. Replies: 2
    Last Post: 06-20-2011, 03:10 PM
  2. Replies: 2
    Last Post: 04-28-2011, 07:30 PM
  3. Replies: 1
    Last Post: 04-17-2011, 06:57 PM
  4. Replies: 4
    Last Post: 01-02-2011, 08:09 PM
  5. close form
    By taylorosso in forum Forms
    Replies: 5
    Last Post: 08-25-2009, 12:18 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