Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    USA
    Posts
    386
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Query Design in MS Access 2013

    Why when I right click and select Design View for a query is it opening in the SQL View rather than the Design View?
    I can then right click the query name tab, select Design View and it will display correctly.

    Is there a setting that would force this to open each time in Design View rather than having to tell it twice to do so?

    Thanks.
    Richard

  2. #2
    WS Lounge VIP access-mdb's Avatar
    Join Date
    Dec 2009
    Location
    Oxfordshire, UK
    Posts
    1,725
    Thanks
    147
    Thanked 156 Times in 149 Posts
    Hmm, I have O2016 and it works as you want. Indeed, I've never seen it where the default opening of a query is SQL view rather than design. I can't find anywhere, where it tells you how to change this behaviour, either by looking in options, properties or Googling.

    Can you remember customising Access at any time?
    Talk is cheap because supply exceeds demand

  3. #3
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts
    Corruption maybe?

  4. #4
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts
    I've notice that also, but it is not consistent. I'm thinking it may having something to do with which mode it was in the last time it was saved.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  5. #5
    WS Lounge VIP access-mdb's Avatar
    Join Date
    Dec 2009
    Location
    Oxfordshire, UK
    Posts
    1,725
    Thanks
    147
    Thanked 156 Times in 149 Posts
    Mark, I've just edited and saved a query on SQL view, and it opens in the same view, whereas another query opens in design view. I've just edited the same query in design view and saved it and it then opens in design view. I think you may have found the cause.
    Talk is cheap because supply exceeds demand

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •