Solved

New to Access 2010 - opening an exisiting query in design view

Posted on 2013-05-22
2
437 Views
Last Modified: 2013-05-22
Hi EE,

Below is a screen shot of an accdb when it opens

       the design button is greyed out

Can you pls walk me through the steps of opening the query in design view:

    - double click query - opens in view mode to see the record set
    - the design button is clickable
    - then click on design icon in left upper corner


In A2003,  the design icon was alway available when opening the mdb

   i would single click the object and then click the design icon
             w/o having to open the object first

                    ( in a 2010, i put the design icon in the quick start, did you do the same?)

pls advise....

tx for your help, sandra
2013-05-21-font.bmp
0
Comment
Question by:mytfein
2 Comments
 
LVL 119

Accepted Solution

by:
Rey Obrero earned 500 total points
ID: 39188379
right click on the query and select  Design view
0
 

Author Comment

by:mytfein
ID: 39188410
Hi Cap,

great, tx very much,  s
0

Featured Post

Complete Microsoft Windows PC® & Mac Backup

Backup and recovery solutions to protect all your PCs & Mac– on-premises or in remote locations. Acronis backs up entire PC or Mac with patented reliable disk imaging technology and you will be able to restore workstations to a new, dissimilar hardware in minutes.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Loop within Select Case 3 25
Multiple queries for a form 14 22
Help with SQl and UNION 7 16
Syntax using Declare 3 11
I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now