A2010 Query property sheet

#1

I create a new query in A2010 and add a table. If I right-click in the
table area and select Property sheet or press the button for Property
sheet from the ribbon I might get a sheet that shows properties for
"Query Properties" or perhaps a property sheet for "Field List".
There's no indication, when one selects Property Sheet, if it will be
for the query of for the field list.

Is there a way to predict with property sheet will be displayed in the
query builder?

#2

?"Salad" wrote in message
news:_oCdnfQ63K-Z3dLQnZ2dnUVZ_uCdnZ2d (AT) earthlink (DOT) com...

Quote:

I create a new query in A2010 and add a table. If I right-click in the
table area and select Property sheet or press the button for Property sheet
from the ribbon I might get a sheet that shows properties for "Query
Properties" or perhaps a property sheet for "Field List". There's no
indication, when one selects Property Sheet, if it will be for the query of
for the field list.

Is there a way to predict with property sheet will be displayed in the
query builder?

I not aware this has changed. This works the same as in all pervious
versions of access.

The way this works is as follows:

If you right click on the table, you get property sheet for the table.

If you right click on a blank area in the diagram area of the query
builder, you get properties for the query and not the table.

I am not aware that this works any different for the last 5 versions of
access. I do not have access 97 handy, but I thinking that it also worked
this way too? (anyone??).

It is very possible I am not understanding your question, but a simple right
click on the table, or a simple right click in the blank query area is what
determines what the property sheet will display, and I not aware this has
changed for the last many past editions of access.

As a side note, if you do have the property sheet displayed in query design
mode, then you can toggle what the sheet displays by simply clicking on
tables, or clicking on an blank area in the query graphic area of the query
builder.

--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
Pleasenospam_kallal (AT) msn (DOT) com

#3

Albert D. Kallal wrote:

Quote:

?"Salad" wrote in message
news:_oCdnfQ63K-Z3dLQnZ2dnUVZ_uCdnZ2d (AT) earthlink (DOT) com...

I create a new query in A2010 and add a table. If I right-click in
the table area and select Property sheet or press the button for
Property sheet from the ribbon I might get a sheet that shows
properties for "Query Properties" or perhaps a property sheet for
"Field List". There's no indication, when one selects Property Sheet,
if it will be for the query of for the field list.

Is there a way to predict with property sheet will be displayed in the
query builder?

I not aware this has changed. This works the same as in all pervious
versions of access.

The way this works is as follows:

If you right click on the table, you get property sheet for the table.

If you right click on a blank area in the diagram area of the query
builder, you get properties for the query and not the table.

I am not aware that this works any different for the last 5 versions of
access. I do not have access 97 handy, but I thinking that it also
worked this way too? (anyone??).

It is very possible I am not understanding your question, but a simple
right click on the table, or a simple right click in the blank query
area is what determines what the property sheet will display, and I not
aware this has changed for the last many past editions of access.

As a side note, if you do have the property sheet displayed in query
design mode, then you can toggle what the sheet displays by simply
clicking on tables, or clicking on an blank area in the query graphic
area of the query builder.

Hi Albert:

My Access may be a bit different. In the gray area I right click. It
will pop-up for Field List properties. Maybe the next time Query
properties. I find that if I right click below the table I might get
FieldList prop window and then right click to the right of the table the
QueryList. Maybe the next time it will be FieldList. It's almost like
a toggle on which window I get. Yesterday I kept getting FieldList
props each time.

Regarding your side note, that works like a champ.

#4

?"Salad" wrote in message
news:teidnRXYbIFc7tLQnZ2dnUVZ_hWdnZ2d (AT) earthlink (DOT) com...

Quote:

Hi Albert:

My Access may be a bit different. In the gray area I right click. It will
pop-up for Field List properties. Maybe the next time Query properties. I
find that if I right click below the table I might get FieldList prop
window and then right click to the right of the table the QueryList. Maybe
the next time it will be FieldList. It's almost like a toggle on which
window I get. Yesterday I kept getting FieldList props each time.

I have no doubts that you are experiencing what you say you are
experiencing.

I was just trying to determine if this is any different then past editions
for me, and it seems not.

I keep my eyes open, as for example in 2003, I still on occasion find that
tables do not select correctly in the ER diagram, and I never been able to
figure this out, and it only happens quite rare.

--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
Pleasenospam_kallal (AT) msn (DOT) com

#5

Albert D. Kallal wrote:

Quote:

?"Salad" wrote in message
news:teidnRXYbIFc7tLQnZ2dnUVZ_hWdnZ2d (AT) earthlink (DOT) com...

Hi Albert:

My Access may be a bit different. In the gray area I right click. It
will pop-up for Field List properties. Maybe the next time Query
properties. I find that if I right click below the table I might get
FieldList prop window and then right click to the right of the table
the QueryList. Maybe the next time it will be FieldList. It's almost
like a toggle on which window I get. Yesterday I kept getting
FieldList props each time.

I have no doubts that you are experiencing what you say you are
experiencing.

I was just trying to determine if this is any different then past
editions for me, and it seems not.

Same with me. Works as you said with my version of A2003. With A2010,

I have no idea what property window I'm going to get when clicking in
the gray area.

Quote:

I keep my eyes open, as for example in 2003, I still on occasion find
that tables do not select correctly in the ER diagram, and I never been
able to figure this out, and it only happens quite rare.

Perhaps you can answer a quick question. When Access starts one can
select a "blank database" or "blank web database". Is there an easy way
to determine which type one selected? I guess one method is to look at
AllObjects in the NavigationPane and if no Modules you know it's web.

#6

?"Salad" wrote in message
news:M7mdnWTTycziFtLQnZ2dnUVZ_sqdnZ2d (AT) earthlink (DOT) com...

Quote:

Perhaps you can answer a quick question. When Access starts one can select
a "blank database" or "blank web database". Is there an easy way to
determine which type one selected? I guess one method is to look at
AllObjects in the NavigationPane and if no Modules you know it's web.

Actually, VBA code modules are legal in web based applications.

You note the difference in two ways. First, all web objects and even the
ribbon changes to show web globes.

Here is a screen shot:

http://cid-b18a57cb5f6af0fa.office.l...rrors/web5.png

The above is a screen shot of the IDE when building a hybrid application.
Note the mix of web and VBA objects.

Another way is that when you launch the application, it will inform you
that you are about to connect to an Web Service, and you can hit cancel, or
ok.
(in fact, the problem is remove this prompt once the application been
published - if the application is not published, then
you have to use the first suggestion, but once published, you do get that
prompt).

However, just like when a database is connected to MySql or SQL server, you
cannot tell by just looking at the file name. However in the case
of access Web, there is a ton of visual cues and even backstage shows quite
a few different options. See the above screen shot for
some examples.

You cannot as noted tell by looking at the file name, and I thus right now I
adopted a naming convention with a W in front of all my web based
applications.

--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
Pleasenospam_kallal (AT) msn (DOT) com

#7

Albert D. Kallal wrote:

Quote:

?"Salad" wrote in message
news:M7mdnWTTycziFtLQnZ2dnUVZ_sqdnZ2d (AT) earthlink (DOT) com...

Perhaps you can answer a quick question. When Access starts one can
select a "blank database" or "blank web database". Is there an easy
way to determine which type one selected? I guess one method is to
look at AllObjects in the NavigationPane and if no Modules you know
it's web.

Actually, VBA code modules are legal in web based applications.

You note the difference in two ways. First, all web objects and even the
ribbon changes to show web globes.

Here is a screen shot:

http://cid-b18a57cb5f6af0fa.office.l...rrors/web5.png

The above is a screen shot of the IDE when building a hybrid
application. Note the mix of web and VBA objects.

Another way is that when you launch the application, it will inform you
that you are about to connect to an Web Service, and you can hit cancel,
or ok.
(in fact, the problem is remove this prompt once the application been
published - if the application is not published, then
you have to use the first suggestion, but once published, you do get
that prompt).

However, just like when a database is connected to MySql or SQL server,
you cannot tell by just looking at the file name. However in the case
of access Web, there is a ton of visual cues and even backstage shows
quite a few different options. See the above screen shot for
some examples.

You cannot as noted tell by looking at the file name, and I thus right
now I adopted a naming convention with a W in front of all my web based
applications.

Thanks for the visual clue tip.

I noticed that if you pull a blank database up it too doesn't have the
Modules in the drop down list of objects. One has to create one first
from the ribbon. In the web database, that option isn't available in nav
pane or in the ribbon.

#8

On Feb 6, 8:42*pm, "Albert D. Kallal" <PleaseNOOOsPAMmkal... (AT) msn (DOT) com>
wrote:

Quote:

I am not aware that this works any different for the last 5 versions of
access. I do not have access 97 handy, but I thinking that it also worked
this way too? (anyone??).

It is very possible I am not understanding your question, but a simple right
click on the table, or a simple right click in the blank query area is what
determines what the property sheet will display, and I not aware this has
changed for the last many past editions of access.

Anyone? That's me! :-) In A97, you get Properties such as Creation
Date or Owner for a selected table or query. If you are in query
design mode or SQL view mode, Properties become context sensitive. In
table design mode, the General Table properties are: Description,
Validation Rule, Validation Text, Filter and Order By, regardless of
which field is selected. In SQL View mode, The General Query
Properties shown are Description, Record Locks, ODBC Timeout and Max
Records. In Query Design View, the default Field Properties (General
and Lookup) are: Description, Format, Input Mask, Caption, and Display
Control. If a particular field is selected, the General Field List
Properties are Alias and Source. The "gray area" (no field selected)
General Query Properties are Description, Output All Fields, Top
Values, Unique Values, Unique Records, Run Permissions, Source
Database, Source Connect Str, Record Locks, Recordset Type, ODBC
Timeout, Filter, Order By, and Max Records.

James A. Fortune
CDMAPoster (AT) FortuneJames (DOT) com

#9

Salad <salad (AT) oilandvinegar (DOT) com> wrote in
news:M7mdnWTTycziFtLQnZ2dnUVZ_sqdnZ2d (AT) earthlink (DOT) com:

Quote:

With A2010,
I have no idea what property window I'm going to get when clicking
in the gray area.

What about doubleclicking it? I've always used that to get the
properties sheet in A2003 and before.

Note also that any columns in the grid below have their own
properties. I find A2003 rather unpredictable as to how to get them
to come up, but if I doubleclick the gray area of the top of the
query designer, I get query properties. If I then click on a field,
the properties sheet changes to be for the field properties.

I don't have A2010 on this machine to test your right click issues,
but try using doubleclick instead.

--
David W. Fenton http://www.dfenton.com/
contact via website only http://www.dfenton.com/DFA/

#10

"Albert D. Kallal" <PleaseNOOOsPAMmkallal (AT) msn (DOT) com> wrote in
news:LhN3p.75444$ZS4.1890 (AT) newsfe07 (DOT) iad:

Quote:

Here is a screen shot:

http://cid-b18a57cb5f6af0fa.office.l.../.Public/WebEr
rors/web5.png

Requires a Windows Live logon -- I will not do that just to see your
example. These things belong on publicly accessible websites, or you
shouldn't post examples like this.

--
David W. Fenton http://www.dfenton.com/
contact via website only http://www.dfenton.com/DFA/