Results 1 to 2 of 2
  1. #1
    EddieN1 is offline Competent Performer
    Windows XP Access 2007
    Join Date
    May 2011
    Posts
    316

    Disable Export for a Query


    I want to create a query with "semi-sensitive" information. By that I mean, I want the user to be able to view the query, however, I don't want her to be able to send it to a spreadsheet. Is there a way I can disable the Export buttons at the top of the screen? Thanks, Eddie

  2. #2
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,862
    Here is the VBA to hide and show the ribbon. Maybe you can test it out on a blank DB by building a form with a single Command Button.

    Code:
    DoCmd.ShowToolbar "ribbon", acToolbarNo
    DoCmd.ShowToolbar "ribbon", acToolbarYes
    This will help you to hide the Ribbon but will not, necessarily, prevent someone from copying data from the DB.

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

Similar Threads

  1. Replies: 2
    Last Post: 10-15-2014, 02:23 AM
  2. export query
    By slimjen in forum Forms
    Replies: 7
    Last Post: 06-02-2013, 08:09 PM
  3. Disable query field?
    By b-ballstyle in forum Queries
    Replies: 2
    Last Post: 07-24-2012, 01:38 PM
  4. disable "save export steps"
    By emerrube in forum Access
    Replies: 4
    Last Post: 06-28-2011, 01:22 PM
  5. Export query to CSV
    By daniel.preda in forum Import/Export Data
    Replies: 3
    Last Post: 12-30-2010, 08:52 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