Search results

DB enclosed. The problems are so varied and the development keeps happening, so creating sanitised data is not feasible Anyway DB enclosed. Look forward to some help. The problem is in the form frmCustRFQHdr which has a sub form containing the 2 command buttons in question

Will sanitise, with relevant tables only and share

I tried me.recorset.requery Forms!frmCustRFQHdr.frmRFQDtls.Requery Forms!frmCustRFQHdr!frmRFQDtls.Form.Requery No improvement!

I saw that. It says use me.recordset in the sub form which is what I did earlier. No result

The tables were being updated earlier and even after changing to 0 and -1. The issue of Refresh/Requery remains

Thanks. That is neat. I need to however resolve the requery/refresh issue first. Any advise?

Queries corrected - True and False. Not requerying UPDATE tblCustRFQDtls LEFT JOIN tblCustRFQHdr ON tblCustRFQDtls.RFQHdrID = tblCustRFQHdr.RFQID SET tblCustRFQDtls.Flag = False WHERE (((tblCustRFQHdr.ConsigneeCode)=[Forms]![FrmCustRFQHdr]![ConsigneeCode])); There are 2 command buttons for...

I created 2 Update queries as below and added it to a subform with command button using a wizard. The table was updating but the sub form was not refreshing. I read there is bug in Access on sub form Requery. I tried several methods as suggested in forums , some only are listed below UPDATE...

Does not help I think the issue is the data in qryCoatingRecipeHdr.CoatingCode. If I use tables in a mock qry as enclosed, I don't face any issue

SELECT tblUncoatedFabCost.FGCode, tblUncoatedFabCost.FabCode, tblUncoatedFabCost.LamCode, tblUncoatedFabCost.UncoatedFabCostPerKg AS UFKG, tblUncoatedFabCost.UncoatedFabCostPerSQM AS UFSQM, Val([recipecostperkg] & "") AS RKG FROM tblUncoatedFabCost LEFT JOIN qryCoatingRecipeHdr ON...

Same error. Modified SQL is as below SELECT tblUncoatedFabCost.FGCode, tblUncoatedFabCost.FabCode, tblUncoatedFabCost.LamCode, tblUncoatedFabCost.UncoatedFabCostPerKg AS UFKG, tblUncoatedFabCost.UncoatedFabCostPerSQM AS UFSQM, IIf(IsNull([recipecostperkg]), 0, [recipecostperkg]) AS RKG FROM...

I have a simple query where I use a right join. If an item is not found in the right joined table, it gives an error Many values of Lamcode in the tblUncoatedFabCost are blank. In these cases I get a #Num! error in the query. How can I get 0 instead of the error as I need to use this value in a...

yes

It is very heavy and sanitising it of data and tables etc not required for this query will not be easy. Is it not possible without this?

Yes

I have a main form A and sub form B setup and need to search for a record in the sub form using a cbo say F placed in the header of the sub form. The Master form and sub form link fields are A1 and B1 I want to locate a record in the sub form by searching the value in the field C of the form...

Will try this shortly. Thanks

Ccur function should provide the value in 4 decimal places as I read. However it was providing values in currency with 2 decimal places. Strange. However what it did was it displayed the decimal places row in Properties window as the text converted to number possibly, allowing me to change the...

I have a expression in a query as below QuoteUOM: IIf([UID]=1,

I have a table where I store the specifications of the object. There are 6 specifications, 4 of which are combo boxes and 2 are textboxes The combination of these 6 values needs to be unique. I therefore added an ComboCode in the table to store the conjugated values of these 6 textboxes and set...