Results 1 to 3 of 3
  1. #1
    deb0and is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Jul 2013
    Posts
    1

    Making a form uisable by different people

    Hi



    I have created a form that I would like to use, I remember years ago I could save the form as a program and send it to people to use. How do I do this in 2007. I would like to be able to send the DB to user and them to click on it, open it up and be able to fill out the details but I remember I used to do this witout having all the tabs and ribbons showing it was just the form that was visible.

    Many Thanks

    Andy

  2. #2
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442
    the easiest way is to capture the username and use that to determine usage but you'd have to have a table within your database that stores the username and the access they are allowed to have.

    Code:
    UserName = Environ("USERNAME")

  3. #3
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,632
    If you want to disable the ribbon tabs, navigation pane, shortcut keys, that can be done with project settings.

    Office button > Access Options > Current Database > select options as desired

    Be aware that holding down shift key when opening db will override most of these optional settings.

    If you want to publish the db as a runtime version that doesn't even show the Access application window, I think that involves fairly complex code.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Making a daily list of people from a database...
    By greentiger in forum Access
    Replies: 5
    Last Post: 02-16-2013, 10:02 AM
  2. Replies: 7
    Last Post: 09-22-2010, 02:32 PM
  3. Replies: 0
    Last Post: 12-28-2009, 12:14 PM
  4. people from table not showing in form
    By corystemp in forum Access
    Replies: 2
    Last Post: 03-26-2009, 08:57 PM
  5. Restrict form access to certain people
    By DannyBoy7783 in forum Forms
    Replies: 2
    Last Post: 06-09-2008, 06:18 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