Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Apr 2001
    Location
    Chapel Hill, North Carolina, USA
    Posts
    138
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Post

    In Access 2003, there was a easy method to create a new query from an open table or query (this was a drop-down item on the toolbar which allowed easy creation of new forms, queries, etc). This was very helpful when creating a 'cascade' of queries, each built on the previous one. Is this feature available in Access 2007? (I'm embarrassed but can't find it).

    Thanks!

    Larry

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts
    Unfortunately the 2007 team left a number of the nice developer features from 2003 out of the product, and that is one of them. Allen Browne's website has a pretty comprehensive list of what's gone, though I'm not sure this is on the list.
    Wendell

  3. #3
    5 Star Lounger AndrewKKWalker's Avatar
    Join Date
    Apr 2001
    Location
    Cambridge, UK
    Posts
    1,020
    Thanks
    0
    Thanked 3 Times in 3 Posts
    Yep.
    In 'my opinion', Access was the Product that went backwards in 2007.
    Although it had some nice features, it was a big step backwards from a developer view.
    Maybe 2010 will redress the balance.
    Andrew

  4. #4
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts
    If you run the Query Wizard with an existing query or table open it assumes you want to be base the new query on the open table/query.
    Regards
    John



Posting Permissions

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