where is the data coming from?

On Mon, 31 Dec 2007 08:00:03 -0800, kwgwynn wrote:

this is what I found for the query
SELECT DISTINCTROW PreferredPositionQuery.PreferredPositionID,
PreferredPositionQuery.PreferredPosition
FROM PreferredPositionQuery;

Once again, any help for this newbie is really appreciated!!! (happy new year)

"fredg" wrote:

On Mon, 24 Dec 2007 07:42:01 -0800, kwgwynn wrote:

Thanks for everyone's help thus far. Here's where I stand.

I've checked the properties on the combobox.

The Row/Source type is Table/Query and the Row Source is something called
SELECT DISTINCTRC.

I assume that is either a table or a query. I do not see any options for
finding either tables or queries when I'm looking at all the menu options.
Best I can find are the tables that are displayed when I look at the
Relationships report, and there isn't anything by this name there. So where
do I go from here?

"fredg" wrote:

On Thu, 20 Dec 2007 10:55:02 -0800, kwgwynn wrote:

Okay, good news. I can access the design view (its an .mdb file) and the
properties show the data is coming from a Table/Query.

Now...?

"Steve Schapel" wrote:

Kwgwynn,

If you go to the design view of the form, select the combobox, and look
at the Properties, you will seea property called Row Source. This
defines where the combobox's drop-down list of items comes from. You
will see it is either the name of a table or query in your database, or
else it is a list of items typed directly into the property box. So
that will tell you where you need to go in order to edit the list.

A possible complicating factor could be that there is a macro or VBA
procedure running on the form or elsewhere in the application that
assigns the RowSource of the combobox at runtime... but let's tackle
that op[tion later if it seems that it might apply.

--
Steve Schapel, Microsoft Access MVP

kwgwynn wrote:
I have some Access experience -- creating some simple databases -- and now I
am at a new job where there is an Access database with no "access" to the
author. The database uses forms for data entry (something I've never
programed; don't know if that's an issue here). This is a fairly simple
membership database.

What I'm trying to do is this: there are multiple drop-down lists that
provide choices to idenify a member's interests. However, the choices are out
of date. I want to go in and update these lists. But I can't find them. Where
are these lists? Best I've found are the table descriptions by view the
relationships, and that isn't at all helpful.

Is this going to be a permission thing? Any assistance is greatly appreciate.


What is the actual RowSource property?
If it is a table or query name, then that is where the combo gets it's
data.
If it is a "Select ...etc." then that is where the combo gets it's
data.

If it is blank, then you will need to see the form's code sheet and
search through all the other combo box's AfterUpdate events to see
which one is setting the Rowsource for this combo box. Something like:

Private Sub ComboName_AfterUpdate()
OtherComboName.Rowsource = "Select .......etc."
End Sub
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail


Well, there must be more to the Rowsource than you have written above
(SELECT DISTINCTRC).
That is the rowsource, but you have not posted the complete statement.
Click on that rowsource property line. A little button with 3 dots
will appear. Click on it. The Query by Example grid will open. Click
on View + SQL View.
That is where your combo box is getting it's data from. If you change
something here and exit the grid, you will see the changes in the
rowsource.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail


So you have found your answer.
The combo box gets it's data from the PreferredPositionQuery.
Click on that little button with the 3 dots that appears on that line.
The Query window will appear. Click on the Bang tool button (!). The
query will run and display the appropriate records.

Look up

Select + ALL, DISTINCT, DISTINCTROW, TOP Predicates

in SQL help to see how Select Distinctrow differs from Select and
Select Distinct.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

okay, but what I still don't understand is where the query gets all its data!
Those are the records I want to change! The results of that query. WHERE DOES
THAT DATA COME FROM and how can I change it?????? (cause its wrong)

"fredg" wrote:

On Mon, 31 Dec 2007 08:00:03 -0800, kwgwynn wrote:

this is what I found for the query
SELECT DISTINCTROW PreferredPositionQuery.PreferredPositionID,
PreferredPositionQuery.PreferredPosition
FROM PreferredPositionQuery;

Once again, any help for this newbie is really appreciated!!! (happy new year)

"fredg" wrote:

On Mon, 24 Dec 2007 07:42:01 -0800, kwgwynn wrote:

Thanks for everyone's help thus far. Here's where I stand.

I've checked the properties on the combobox.

The Row/Source type is Table/Query and the Row Source is something called
SELECT DISTINCTRC.

I assume that is either a table or a query. I do not see any options for
finding either tables or queries when I'm looking at all the menu options.
Best I can find are the tables that are displayed when I look at the
Relationships report, and there isn't anything by this name there. So where
do I go from here?

"fredg" wrote:

On Thu, 20 Dec 2007 10:55:02 -0800, kwgwynn wrote:

Okay, good news. I can access the design view (its an .mdb file) and the
properties show the data is coming from a Table/Query.

Now...?

"Steve Schapel" wrote:

Kwgwynn,

If you go to the design view of the form, select the combobox, and look
at the Properties, you will seea property called Row Source. This
defines where the combobox's drop-down list of items comes from. You
will see it is either the name of a table or query in your database, or
else it is a list of items typed directly into the property box. So
that will tell you where you need to go in order to edit the list.

A possible complicating factor could be that there is a macro or VBA
procedure running on the form or elsewhere in the application that
assigns the RowSource of the combobox at runtime... but let's tackle
that op[tion later if it seems that it might apply.

--
Steve Schapel, Microsoft Access MVP

kwgwynn wrote:
I have some Access experience -- creating some simple databases -- and now I
am at a new job where there is an Access database with no "access" to the
author. The database uses forms for data entry (something I've never
programed; don't know if that's an issue here). This is a fairly simple
membership database.

What I'm trying to do is this: there are multiple drop-down lists that
provide choices to idenify a member's interests. However, the choices are out
of date. I want to go in and update these lists. But I can't find them. Where
are these lists? Best I've found are the table descriptions by view the
relationships, and that isn't at all helpful.

Is this going to be a permission thing? Any assistance is greatly appreciate.


What is the actual RowSource property?
If it is a table or query name, then that is where the combo gets it's
data.
If it is a "Select ...etc." then that is where the combo gets it's
data.

If it is blank, then you will need to see the form's code sheet and
search through all the other combo box's AfterUpdate events to see
which one is setting the Rowsource for this combo box. Something like:

Private Sub ComboName_AfterUpdate()
OtherComboName.Rowsource = "Select .......etc."
End Sub
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail


Well, there must be more to the Rowsource than you have written above
(SELECT DISTINCTRC).
That is the rowsource, but you have not posted the complete statement.
Click on that rowsource property line. A little button with 3 dots
will appear. Click on it. The Query by Example grid will open. Click
on View + SQL View.
That is where your combo box is getting it's data from. If you change
something here and exit the grid, you will see the changes in the
rowsource.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail


So you have found your answer.
The combo box gets it's data from the PreferredPositionQuery.
Click on that little button with the 3 dots that appears on that line.
The Query window will appear. Click on the Bang tool button (!). The
query will run and display the appropriate records.

Look up

Select + ALL, DISTINCT, DISTINCTROW, TOP Predicates

in SQL help to see how Select Distinctrow differs from Select and
Select Distinct.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

kwgwynn wrote:
okay, but what I still don't understand is where the query gets all
its data! Those are the records I want to change! The results of that
query. WHERE DOES THAT DATA COME FROM and how can I change it??????
(cause its wrong)

Look at the FROM clause...

FROM PreferredPositionQuery;

That tells you that the data is coming from another query named
"PreferredPositionQuery". You need to look at the structure of that query to
examine its FROM clause. Eventually there will be a FROM clause that names one
or more tables and THAT is where the data comes from.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

On Mon, 31 Dec 2007 08:00:03 -0800, kwgwynn
wrote:

this is what I found for the query
SELECT DISTINCTROW PreferredPositionQuery.PreferredPositionID,
PreferredPositionQuery.PreferredPosition
FROM PreferredPositionQuery;

You should then have a Query in Access' Queries window named
PreferredPositionQuery. Try opening this Query in design view; that should
show you the tables and fields containing the data that the combo displays.

Why the original developer did this "double layer" - putting a SQL statement
which just recapitulates the data in PreferredPositionQuery into the combo -
is anyone's guess.

John W. Vinson [MVP]

well, I don't really understand what is going on here (and I agree with
John's statement: why the original developer did what he did is beyond me),
but I think I can do the changes I need to. When I run the query the result
is a data table. I edited then saved the table and the changes are available
on the form. So I guess that's what is needed.

When I look at the query itself, the FROM statement keeps pointing to
another query statement. There seems to be no end to the querying! I am
queried out and hope that updating these tables is the right thing to do.

Thanks again to everyone who chimed in with a suggestion.

Karen

"John W. Vinson" wrote:

On Mon, 31 Dec 2007 08:00:03 -0800, kwgwynn
wrote:

this is what I found for the query
SELECT DISTINCTROW PreferredPositionQuery.PreferredPositionID,
PreferredPositionQuery.PreferredPosition
FROM PreferredPositionQuery;

You should then have a Query in Access' Queries window named
PreferredPositionQuery. Try opening this Query in design view; that should
show you the tables and fields containing the data that the combo displays.

Why the original developer did this "double layer" - putting a SQL statement
which just recapitulates the data in PreferredPositionQuery into the combo -
is anyone's guess.

John W. Vinson [MVP]