Results 1 to 4 of 4
  1. #1
    orange's Avatar
    orange is offline Moderator
    Windows 10 Office 365
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,870

    Ms Access main Nav window trying to rename a query


    I have O365 latest Access with latest updates. For a while now, if I misspell or mistype a query name, and try to rename/correct it on the main window, Access stops the rename almost immediately before I can adjust the name. I got around this by creating my own MyRename function, BUT I was wondering if anyone has a solution that allows me to use rename in the Nav window.
    orange

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,550
    currentdb.querydefs("qsBadQryName").name = "qsNewQryName"

  3. #3
    orange's Avatar
    orange is offline Moderator
    Windows 10 Office 365
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,870
    Thanks ranman, but I have a function. What I really want to know is if others have the same issue with rename closing immediately or is there a setting somewhere that I have missed.I'd like to do the rename on the main window.

  4. #4
    isladogs's Avatar
    isladogs is offline Access MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    6,204
    Hi Jack
    No I don't have your issue using A365
    Have you checked your Name AutoCorrect options?
    Colin Riddington, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I know I don't know, I keep quiet!

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

Similar Threads

  1. Replies: 1
    Last Post: 05-09-2018, 05:07 PM
  2. Replies: 10
    Last Post: 12-05-2017, 01:14 AM
  3. Replies: 5
    Last Post: 10-29-2017, 06:46 AM
  4. How to remove main access window?
    By ciccierrr04 in forum Forms
    Replies: 1
    Last Post: 10-20-2012, 12:47 PM
  5. 2 questions about Access' main window
    By nford in forum Access
    Replies: 16
    Last Post: 02-28-2010, 02:47 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