Form not write?

  • Thread starter Thread starter Matthew
  • Start date Start date
M

Matthew

I have a form based on a query:
SELECT lumber.price, psub.turning, psub.milling, psub.fluting, size.height,
size.width, psub.SKU, psub.Price AS psub_Price,
(([psub.turning]+[psub.milling]+[psub.fluting]+[lumber.price])*1.5) AS Expr1
FROM woodtype INNER JOIN (([size] INNER JOIN lumber ON
size.ID=lumber.sizeID) INNER JOIN psub ON size.ID=psub.sizeID) ON
(woodtype.ID=lumber.woodtypeID) AND (woodtype.ID=psub.woodtype_ID);

The form beeps instead of updating the data.

I tried making the form over, based on all the separate tables (not the
query) and it still didn't work.

Any ideas?

Matthew
 
Can you update the data when viewing the datasheet of the query?
Are the join fields based on Primary Keys on one side of the JOIN?
 
I cannot update the data in the datasheet of the query.

All of the join fields have one side as the primary key.

Matthew

Duane Hookom said:
Can you update the data when viewing the datasheet of the query?
Are the join fields based on Primary Keys on one side of the JOIN?

--
Duane Hookom
MS Access MVP


Matthew said:
I have a form based on a query:
SELECT lumber.price, psub.turning, psub.milling, psub.fluting, size.height,
size.width, psub.SKU, psub.Price AS psub_Price,
(([psub.turning]+[psub.milling]+[psub.fluting]+[lumber.price])*1.5) AS Expr1
FROM woodtype INNER JOIN (([size] INNER JOIN lumber ON
size.ID=lumber.sizeID) INNER JOIN psub ON size.ID=psub.sizeID) ON
(woodtype.ID=lumber.woodtypeID) AND (woodtype.ID=psub.woodtype_ID);

The form beeps instead of updating the data.

I tried making the form over, based on all the separate tables (not the
query) and it still didn't work.

Any ideas?

Matthew
Click to expand...
Click to expand...
 
I have a form based on a query:
SELECT lumber.price, psub.turning, psub.milling, psub.fluting, size.height,
size.width, psub.SKU, psub.Price AS psub_Price,
(([psub.turning]+[psub.milling]+[psub.fluting]+[lumber.price])*1.5) AS Expr1
FROM woodtype INNER JOIN (([size] INNER JOIN lumber ON
size.ID=lumber.sizeID) INNER JOIN psub ON size.ID=psub.sizeID) ON
(woodtype.ID=lumber.woodtypeID) AND (woodtype.ID=psub.woodtype_ID);

The form beeps instead of updating the data.
Click to expand...

If you open this Query directly in datasheet view, is it updateable?
Note that a three-table Join often won't be; at the very least you'll
need to be sure that the joining fields (size.ID, woodtype.ID) have
unique Indexes in the "one" side table.
 
You may need to remove some tables from the query. Most of my forms are
built from just one or two tables. Other tables are added to the form as:
1) subforms
2) row sources of combo boxes or list boxes.

--
Duane Hookom
MS Access MVP


Matthew said:
I cannot update the data in the datasheet of the query.

All of the join fields have one side as the primary key.

Matthew

Duane Hookom said:
Can you update the data when viewing the datasheet of the query?
Are the join fields based on Primary Keys on one side of the JOIN?

--
Duane Hookom
MS Access MVP


Matthew said:
I have a form based on a query:
SELECT lumber.price, psub.turning, psub.milling, psub.fluting, size.height,
size.width, psub.SKU, psub.Price AS psub_Price,
(([psub.turning]+[psub.milling]+[psub.fluting]+[lumber.price])*1.5) AS Expr1
FROM woodtype INNER JOIN (([size] INNER JOIN lumber ON
size.ID=lumber.sizeID) INNER JOIN psub ON size.ID=psub.sizeID) ON
(woodtype.ID=lumber.woodtypeID) AND (woodtype.ID=psub.woodtype_ID);

The form beeps instead of updating the data.

I tried making the form over, based on all the separate tables (not the
query) and it still didn't work.

Any ideas?

Matthew
Click to expand...
Click to expand...
Click to expand...
 
Back
Top