auto query update?

[Humbled Learner]

I have information in my form and tables. Lines 1-3. I built a query. It
correctly reflects the information from lines 1-3.

Now I add infomation (or another line)to my form and close. I see the
information in the table. Say lines 3-5 but...

when I look in the query, it only reflects the lines 1-3 when I built the
query, it won't show lines 3-5 or any other lines when I add them.

After I add information to a form, is there a way to look at the query and
see everything updated?


Thank You

 

[Jeff Boyce]

Access tables store data. Access form display data. Access queries provide
a "view" of the data in tables (and in other queries).

If your query doesn't show all the data in the table, your query isn't
asking for all the data in the table.

Please post the SQL statement of your query -- this will give us more
clues...

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Humbled Learner]

SELECT Customers.ID, Customers.Name, [New Shipment].Date, Items.Items, [New
Shipment].Packages
FROM ((Customers INNER JOIN [New Shipment] ON Customers.ID=[New
Shipment].ID) INNER JOIN Carrier ON Customers.ID=Carrier.ID) INNER JOIN Items
ON Customers.ID=Items.ID;

I used the wizard when I made the query. Thank You for your time.

 

[KARL DEWEY]

If I follow your process as posted you are opening the query to see lines
1-3.
You leave the query open and open the form to add more data.
You close the form and look at the query that has remained open and the
additional line are not visible.

If you situation is as I stated it then to problem is that the query was not
refreshed after the data entry.

If I stated the sequence of actions wrong then post the correct progression.

 

[Humbled Learner]

Nope. If I just open the form fill in one order and close access and reopen,
the query still won't update all orders.

good try though...

 

[Jeff Boyce]

It sounds like Karl nailed it... how does your query know that the table
changed?

Regards

Jeff Boyce
Microsoft Office/Access MVP

SELECT Customers.ID, Customers.Name, [New Shipment].Date, Items.Items,
[New
Shipment].Packages
FROM ((Customers INNER JOIN [New Shipment] ON Customers.ID=[New
Shipment].ID) INNER JOIN Carrier ON Customers.ID=Carrier.ID) INNER JOIN
Items
ON Customers.ID=Items.ID;

I used the wizard when I made the query. Thank You for your time.

Access tables store data. Access form display data. Access queries
provide
a "view" of the data in tables (and in other queries).

If your query doesn't show all the data in the table, your query isn't
asking for all the data in the table.

Please post the SQL statement of your query -- this will give us more
clues...

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Humbled Learner]

I"m not being sarcastic but that's why I'm asking you guys... it won't
update? If i open the form and add info and close the database entirely.
When I reopen it and look at the query, it will only show the original 3
lines... what am i missing?

Sorry...

Thank You

It sounds like Karl nailed it... how does your query know that the table
changed?

Regards

Jeff Boyce
Microsoft Office/Access MVP

SELECT Customers.ID, Customers.Name, [New Shipment].Date, Items.Items,
[New
Shipment].Packages
FROM ((Customers INNER JOIN [New Shipment] ON Customers.ID=[New
Shipment].ID) INNER JOIN Carrier ON Customers.ID=Carrier.ID) INNER JOIN
Items
ON Customers.ID=Items.ID;

I used the wizard when I made the query. Thank You for your time.

Access tables store data. Access form display data. Access queries
provide
a "view" of the data in tables (and in other queries).

If your query doesn't show all the data in the table, your query isn't
asking for all the data in the table.

Please post the SQL statement of your query -- this will give us more
clues...

Regards

Jeff Boyce
Microsoft Office/Access MVP

message I have information in my form and tables. Lines 1-3. I built a query.
It
correctly reflects the information from lines 1-3.

Now I add infomation (or another line)to my form and close. I see the
information in the table. Say lines 3-5 but...

when I look in the query, it only reflects the lines 1-3 when I built
the
query, it won't show lines 3-5 or any other lines when I add them.

After I add information to a form, is there a way to look at the query
and
see everything updated?


Thank You

 

[KARL DEWEY]

TO Humbled Learner --This does not follow with your first post unless your are using different
definitons for terms than I am.
You say you close Access. To me this means you closed the application and
then restart it.
Does the form use the same query you posted? If not then post the source
for the form.

TO Jeff --
I think there is a problem with the query. Notice that AL IDs must equal
ALL other IDs.
That juat ain't right.

--
Build a little, test a little.

It sounds like Karl nailed it... how does your query know that the table
changed?

Regards

Jeff Boyce
Microsoft Office/Access MVP

SELECT Customers.ID, Customers.Name, [New Shipment].Date, Items.Items,
[New
Shipment].Packages
FROM ((Customers INNER JOIN [New Shipment] ON Customers.ID=[New
Shipment].ID) INNER JOIN Carrier ON Customers.ID=Carrier.ID) INNER JOIN
Items
ON Customers.ID=Items.ID;

I used the wizard when I made the query. Thank You for your time.

Access tables store data. Access form display data. Access queries
provide
a "view" of the data in tables (and in other queries).

If your query doesn't show all the data in the table, your query isn't
asking for all the data in the table.

Please post the SQL statement of your query -- this will give us more
clues...

Regards

Jeff Boyce
Microsoft Office/Access MVP

message I have information in my form and tables. Lines 1-3. I built a query.
It
correctly reflects the information from lines 1-3.

Now I add infomation (or another line)to my form and close. I see the
information in the table. Say lines 3-5 but...

when I look in the query, it only reflects the lines 1-3 when I built
the
query, it won't show lines 3-5 or any other lines when I add them.

After I add information to a form, is there a way to look at the query
and
see everything updated?


Thank You

 

[Gina Whipp]

Humbled Learner,

Sounds to me like if you one of those field blank on your form then the
query is unable to show the results. DId you check the tables to insure all
the appropiate fields are filled in?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

SELECT Customers.ID, Customers.Name, [New Shipment].Date, Items.Items,
[New
Shipment].Packages
FROM ((Customers INNER JOIN [New Shipment] ON Customers.ID=[New
Shipment].ID) INNER JOIN Carrier ON Customers.ID=Carrier.ID) INNER JOIN
Items
ON Customers.ID=Items.ID;

I used the wizard when I made the query. Thank You for your time.

Access tables store data. Access form display data. Access queries
provide
a "view" of the data in tables (and in other queries).

If your query doesn't show all the data in the table, your query isn't
asking for all the data in the table.

Please post the SQL statement of your query -- this will give us more
clues...

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[John Spencer]

Karl,
I agree. It looks as if the poster may have used an autonumber field as the
primary key in each of the tables and then is attempting to link on the
autonumber field. I don't see how those tables could all relate directly to
the Customers table.

The relationships might be more on the order of:
Customer To New Shipment (order?)
New Shipment to Carrier
New Shipment to Items

Humbled Learner: Please post some of your table structure.
Customers
== CustomerID Autonumber field
== Name Text field

New Shipment
== ID
== Date Date field

I think

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County