C
crich21
This db is driving me crazy.
The problem I have is this:
I need to be able to change the cost of a part from the frmvendors
However the price comes from a table that is created by a query. Goo
design? I have no idea. I couldn't think of another way. So when th
price is updated I need to be able to update the tblcurrentcost an
show the new prices in the frmvendors, but the tblcurrentcost is locke
because it is in use. Does anyone have a suggestion how I can wor
around this. Also I might have to run the qryupdatecurrentcost in th
on open event of frmvendors so the prices are current when opened. Als
is there a way to eliminate the acces error of "This table will b
deleted" everytime the qryupdatecurrentcost is run.
maybe I shouldn't be using a make table query but I couldn't figure ou
how to update an existing table with a query.
Any suggestions would be greatly appreciated. I may be going about thi
all wrong. But the main purpose is to be able to view the most curren
cost that is not a future cost and be able to edit it from th
frmvendors.
Thanks in advance
+----------------------------------------------------------------
| Attachment filename: costdemo.zip
|Download attachment: http://www.MSAccessForum.com.com/forums/attachment.php?postid=277631
+----------------------------------------------------------------
The problem I have is this:
I need to be able to change the cost of a part from the frmvendors
However the price comes from a table that is created by a query. Goo
design? I have no idea. I couldn't think of another way. So when th
price is updated I need to be able to update the tblcurrentcost an
show the new prices in the frmvendors, but the tblcurrentcost is locke
because it is in use. Does anyone have a suggestion how I can wor
around this. Also I might have to run the qryupdatecurrentcost in th
on open event of frmvendors so the prices are current when opened. Als
is there a way to eliminate the acces error of "This table will b
deleted" everytime the qryupdatecurrentcost is run.
maybe I shouldn't be using a make table query but I couldn't figure ou
how to update an existing table with a query.
Any suggestions would be greatly appreciated. I may be going about thi
all wrong. But the main purpose is to be able to view the most curren
cost that is not a future cost and be able to edit it from th
frmvendors.
Thanks in advance
+----------------------------------------------------------------
| Attachment filename: costdemo.zip
|Download attachment: http://www.MSAccessForum.com.com/forums/attachment.php?postid=277631
+----------------------------------------------------------------