If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Requerying Automatically
Hello All
I have a query like this: SELECT utblPartListPriceQuery.ID, utblPartListPriceQuery.Partnumber, dbo_PART.ID, dbo_PART.DESCRIPTION, dbo_PART.PRODUCT_CODE, dbo_PART.COMMODITY_CODE, dbo_PART.MFG_NAME, dbo_PART.MFG_PART_ID, dbo_PART.FABRICATED, dbo_PART.PURCHASED, dbo_PART.PRIMARY_WHS_ID, dbo_PART.PRIMARY_LOC_ID, dbo_PART.UNIT_PRICE, dbo_PART.QTY_ON_HAND, dbo_PART.QTY_ON_ORDER, dbo_PART.QTY_IN_DEMAND, dbo_PART.PREF_VENDOR_ID, dbo_PART.BUYER_USER_ID, dbo_PART.PLANNER_USER_ID, IIf([UNIT_MATERIAL_COST] Is Null,0,[UNIT_MATERIAL_COST])+IIf([UNIT_LABOR_COST] Is Null,0,[UNIT_LABOR_COST])+IIf([UNIT_BURDEN_COST] Is Null,0,[UNIT_BURDEN_COST])+IIf([UNIT_SERVICE_COST] Is Null,0,[UNIT_SERVICE_COST]) AS [Our Cost] FROM utblPartListPriceQuery LEFT JOIN dbo_PART ON utblPartListPriceQuery.Partnumber = dbo_PART.ID; notice that the utblPartListPriceQuery Partnumber field is a place where users can type in a new number and if it matches the ID in the dbo_PART table then it would show all the other details from the other fields. this query used to work fine. when the user typed in stuff to the data sheet the other fields would populate fine from the table. i made some modifications to the form and query but changed them back and now the updating has stopped. i looked into an old back up of the forms and query and stuff, that still does what it used to. does anyone have any idea as to what hidden setting i changed for this query? i need it to go back to updating after someone enters a valid part number that matches records in the other table. thinking about just importing from the backup and redoing all the modifications... might be quicker. |
#2
|
|||
|
|||
Requerying Automatically
Hello All
i figured it out. i had set the field in the table utblPartListPriceQuery to be index with no duplicates. changing it back to no indexing causes the list to automatically load field information from the other table. "DawnTreader" wrote: Hello All I have a query like this: SELECT utblPartListPriceQuery.ID, utblPartListPriceQuery.Partnumber, dbo_PART.ID, dbo_PART.DESCRIPTION, dbo_PART.PRODUCT_CODE, dbo_PART.COMMODITY_CODE, dbo_PART.MFG_NAME, dbo_PART.MFG_PART_ID, dbo_PART.FABRICATED, dbo_PART.PURCHASED, dbo_PART.PRIMARY_WHS_ID, dbo_PART.PRIMARY_LOC_ID, dbo_PART.UNIT_PRICE, dbo_PART.QTY_ON_HAND, dbo_PART.QTY_ON_ORDER, dbo_PART.QTY_IN_DEMAND, dbo_PART.PREF_VENDOR_ID, dbo_PART.BUYER_USER_ID, dbo_PART.PLANNER_USER_ID, IIf([UNIT_MATERIAL_COST] Is Null,0,[UNIT_MATERIAL_COST])+IIf([UNIT_LABOR_COST] Is Null,0,[UNIT_LABOR_COST])+IIf([UNIT_BURDEN_COST] Is Null,0,[UNIT_BURDEN_COST])+IIf([UNIT_SERVICE_COST] Is Null,0,[UNIT_SERVICE_COST]) AS [Our Cost] FROM utblPartListPriceQuery LEFT JOIN dbo_PART ON utblPartListPriceQuery.Partnumber = dbo_PART.ID; notice that the utblPartListPriceQuery Partnumber field is a place where users can type in a new number and if it matches the ID in the dbo_PART table then it would show all the other details from the other fields. this query used to work fine. when the user typed in stuff to the data sheet the other fields would populate fine from the table. i made some modifications to the form and query but changed them back and now the updating has stopped. i looked into an old back up of the forms and query and stuff, that still does what it used to. does anyone have any idea as to what hidden setting i changed for this query? i need it to go back to updating after someone enters a valid part number that matches records in the other table. thinking about just importing from the backup and redoing all the modifications... might be quicker. |
Thread Tools | |
Display Modes | |
|
|