Results 1 to 4 of 4
  1. #1
    roselouise is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2012
    Posts
    2

    easy way to move fields in query back to their original positions

    I realize this may have a simple solution but I havent been able to find it anywhere. I have queries on a ACCESS database that the users is constantly dragging & dropping to new positions when viewing the query and putting it totally out of order. Of course then he complains its out of order! Is there an easy way to get the fields back to the original order? I dont want to drag and drop adinfinitium. I cannot find an option to do this. I have gone so far as delete and put the SQL code back in the query but it doesnt change what he messed up. The only thing that seems to work is actually deleting the query entirely and then creating it from scratch. Unfortunaly this is not a valid option as he is constantly doing this and wont stop.
    Thank you in advance - I am on ACCESS 10.

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,902
    There is not.

    Don't let users work with tables and queries. Give them forms and reports to interact with.

    Don't even let them access the navigation pane.
    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.

  3. #3
    roselouise is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2012
    Posts
    2
    thanks but that isnt an option

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,902
    If users can get to objects in the Navigation pane then you can't stop them from doing whatever they want, even screw things up. If they want to be 'power users' then they better understand the consequences of their actions.
    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. Access Reverts Back to Original Data
    By Howardlr in forum Access
    Replies: 5
    Last Post: 05-24-2012, 08:23 AM
  2. Write "Edit List Items.." data back to original form.
    By ngahm in forum Database Design
    Replies: 33
    Last Post: 02-27-2012, 06:54 PM
  3. Calculating race finishing positions
    By Coheeba in forum Queries
    Replies: 4
    Last Post: 09-01-2011, 12:44 PM
  4. Cant move fields around on a form
    By byterbit in forum Forms
    Replies: 3
    Last Post: 02-20-2011, 06:41 PM
  5. Back to original form
    By hawzmolly in forum Forms
    Replies: 4
    Last Post: 09-26-2010, 07:36 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