I am getting method of data member not found for the following code when inserting values to a table. Form has three frames, any help will be appreciated also let me know if further information required. Add/Insert is on OnClick Event.
MsgBox "First Value, " & Me.txt_FSNo
CurrentDb.Execute "INSERT INTO BackchargeLog (BC_FSNo, BC_FContract, BC_FPurchaseOrder, BC_FProjectArea, " & _
" BC_FTitle, BC_FDetailDescription, BC_FSupplierToBeCharged, BC_FSupToBeChargedNumber, BC_FSTBCContactName, BC_FSTBCContactNumber, " & _
" BC_FSTBCContactEmail, BC_FIncidentReportedDate, BC_FInitiatedDate, BC_FEstimateAvailable, BC_FBackchargeable, BC_FEstimateAmount, " & _
" BC_FAdminFee, BC_FGSTFee, BC_FSupplierNotified, BC_FTotalEstimatedAmount, BC_FSourceDocType, BC_FSourceDocName, BC_FSourceofDocOthers, " & _
" BC_CurrentBuyerName, BC_FIncidentReportedBy, BC_FContract, BC_FPurchaseOrder, BC_RProjectArea, BC_RTitle, BC_RDetailDescription, " & _
" BC_RSupplierToBePaid, BC_RSupToBePaidNumber, BC_RSupplierContactName, BC_RSupplierContactNumber, BC_RSupplierContactEmail, BC_RWorkCompletedDate, " & _
" BC_REWOKnown, BC_RWorkCompleted, BC_RActualCostKnown, BC_RSupplierNotified, BC_RActualCost, BC_RAdminFee, BC_RGSTFee, BC_RTotalActualCost, BC_RCurrentBuyerName, " & _
" BC_RSourceDocType, BC_RSourceDocName, BC_RSourceofDocOthers, BC_BNegoInProgress, BC_BFNoticeSent, BC_BSNoticeSent, BC_BFNoticeSentDate, BC_BSNoticeSentDate, " & _
" BC_BFResponseReceived, BC_BSResponseReceived, BC_BFResponseReceivedDate, BC_BSResponseReceivedDate, BC_BFNoticeNumber, BC_BSNoticeNumber, BC_BSupplierInvoice, " & _
" BC_BNegotiatedAmount, BC_BAmountToBeInvoiced, BC_BAdminFee, BC_BGSTAmount, BC_BTInvlicedAmount, BC_BBLinkToWDrive, BC_BAssignedBCName, BC_BReasonToClose, " & _
" BC_BStatus, BC_BAccountingNotified, BC_BRemarks, BC_BAccoutingNotifiedDate, BC_BBCClosingDate) " & _
" VALUES(" & Me.txt_FSNo & "','" & Me.txt_FContract & "','" & Me.txt_FPurchaseOrder & "','" & Me.txt_FProjectArea & "','" & _
Me.txt_FTitle & "','" & Me.txt_FDetailDescription & "','" & Me.txt_FSupplierToBeCharged & "','" & Me.txt_FSupToBeChargedNumber & "','" & Me.txt_FSTtxtContactName & "','" & Me.txt_FSTtxtContactNumber & "','" & Me.txt_FSTtxtContactEmail & "','" & Me.txt_FIncidentReportedDate & "','" & _
Me.txt_FInitiatedDate & "','" & Me.txt_FEstimateAvailable & "','" & Me.txt_FBackchargeable & "','" & Me.txt_FEstimateAmount & "','" & Me.txt_FAdminFee, Me.txt_FGSTFee & "','" & _
Me.txt_FSupplierNotified & "','" & Me.txt_FTotalEstimatedAmount & "','" & Me.txt_FSourceDocType & "','" & Me.txt_FSourceDocName & "','" & Me.txt_FSourceofDocOthers & "','" & _
Me.txt_CurrentBuyerName, Me.txt_FIncidentReportedBy & "','" & Me.txt_RContract & "','" & Me.txt_RPurchaseOrder & "','" & Me.txt_RProjectArea & "','" & Me.txt_RTitle & "','" & _
Me.txt_RDetailDescription & "','" & Me.txt_RSupplierToBePaid & "','" & Me.txt_RSupToBePaidNumber & "','" & Me.txt_RSupplierContactName & "','" & Me.txt_RSupplierContactNumber & "','" & _
Me.txt_RSupplierContactEmail & "','" & Me.txt_RWorkCompletedDate & "','" & Me.txt_REWOKnown & "','" & Me.txt_RWorkCompleted & "','" & Me.txt_RActualCostKnown & "','" & _
Me.txt_RSupplierNotified & "','" & Me.txt_RActualCost & "','" & Me.txt_RAdminFee & "','" & Me.txt_RGSTFee & "','" & Me.txt_RTotalActualCost & "','" & Me.txt_RCurrentBuyerName & "','" & _
Me.txt_RSourceDocType & "','" & Me.txt_RSourceDocName & "','" & Me.txt_RSourceofDocOthers & "','" & Me.txt_BNegoInProgress & "','" & Me.txt_BFNoticeSent & "','" & _
Me.txt_BSNoticeSent & "','" & Me.txt_BFNoticeSentDate & "','" & Me.txt_BSNoticeSentDate & "','" & Me.txt_BFResponseReceived & "','" & Me.txt_BSResponseReceived & "','" & _
Me.txt_BFResponseReceivedDate & "','" & Me.txt_BSResponseReceivedDate & "','" & Me.txt_BFNoticeNumber & "','" & Me.txt_BSNoticeNumber & "','" & Me.txt_BSupplierInvoice & "','" & _
Me.txt_BNegotiatedAmount & "','" & Me.txt_BAmountToBeInvoiced & "','" & Me.txt_BAdminFee & "','" & Me.txt_BGSTAmount & "','" & Me.txt_BtxtClosingDate & "','" & Me.txt_BBLinkToWDrive & "','" & _
Me.txt_BAssignedtxtName & "','" & Me.txt_BReasonToClose & "','" & Me.txt_BStatus & "','" & Me.txt_BAccountingNotified & "','" & Me.txt_BRemarks & "','" & Me.txt_BAccoutingNotifiedDate & "','" & _
Me.txt_BBCClosingDate & "')'"
Regards,
Calgarian
MsgBox "First Value, " & Me.txt_FSNo
CurrentDb.Execute "INSERT INTO BackchargeLog (BC_FSNo, BC_FContract, BC_FPurchaseOrder, BC_FProjectArea, " & _
" BC_FTitle, BC_FDetailDescription, BC_FSupplierToBeCharged, BC_FSupToBeChargedNumber, BC_FSTBCContactName, BC_FSTBCContactNumber, " & _
" BC_FSTBCContactEmail, BC_FIncidentReportedDate, BC_FInitiatedDate, BC_FEstimateAvailable, BC_FBackchargeable, BC_FEstimateAmount, " & _
" BC_FAdminFee, BC_FGSTFee, BC_FSupplierNotified, BC_FTotalEstimatedAmount, BC_FSourceDocType, BC_FSourceDocName, BC_FSourceofDocOthers, " & _
" BC_CurrentBuyerName, BC_FIncidentReportedBy, BC_FContract, BC_FPurchaseOrder, BC_RProjectArea, BC_RTitle, BC_RDetailDescription, " & _
" BC_RSupplierToBePaid, BC_RSupToBePaidNumber, BC_RSupplierContactName, BC_RSupplierContactNumber, BC_RSupplierContactEmail, BC_RWorkCompletedDate, " & _
" BC_REWOKnown, BC_RWorkCompleted, BC_RActualCostKnown, BC_RSupplierNotified, BC_RActualCost, BC_RAdminFee, BC_RGSTFee, BC_RTotalActualCost, BC_RCurrentBuyerName, " & _
" BC_RSourceDocType, BC_RSourceDocName, BC_RSourceofDocOthers, BC_BNegoInProgress, BC_BFNoticeSent, BC_BSNoticeSent, BC_BFNoticeSentDate, BC_BSNoticeSentDate, " & _
" BC_BFResponseReceived, BC_BSResponseReceived, BC_BFResponseReceivedDate, BC_BSResponseReceivedDate, BC_BFNoticeNumber, BC_BSNoticeNumber, BC_BSupplierInvoice, " & _
" BC_BNegotiatedAmount, BC_BAmountToBeInvoiced, BC_BAdminFee, BC_BGSTAmount, BC_BTInvlicedAmount, BC_BBLinkToWDrive, BC_BAssignedBCName, BC_BReasonToClose, " & _
" BC_BStatus, BC_BAccountingNotified, BC_BRemarks, BC_BAccoutingNotifiedDate, BC_BBCClosingDate) " & _
" VALUES(" & Me.txt_FSNo & "','" & Me.txt_FContract & "','" & Me.txt_FPurchaseOrder & "','" & Me.txt_FProjectArea & "','" & _
Me.txt_FTitle & "','" & Me.txt_FDetailDescription & "','" & Me.txt_FSupplierToBeCharged & "','" & Me.txt_FSupToBeChargedNumber & "','" & Me.txt_FSTtxtContactName & "','" & Me.txt_FSTtxtContactNumber & "','" & Me.txt_FSTtxtContactEmail & "','" & Me.txt_FIncidentReportedDate & "','" & _
Me.txt_FInitiatedDate & "','" & Me.txt_FEstimateAvailable & "','" & Me.txt_FBackchargeable & "','" & Me.txt_FEstimateAmount & "','" & Me.txt_FAdminFee, Me.txt_FGSTFee & "','" & _
Me.txt_FSupplierNotified & "','" & Me.txt_FTotalEstimatedAmount & "','" & Me.txt_FSourceDocType & "','" & Me.txt_FSourceDocName & "','" & Me.txt_FSourceofDocOthers & "','" & _
Me.txt_CurrentBuyerName, Me.txt_FIncidentReportedBy & "','" & Me.txt_RContract & "','" & Me.txt_RPurchaseOrder & "','" & Me.txt_RProjectArea & "','" & Me.txt_RTitle & "','" & _
Me.txt_RDetailDescription & "','" & Me.txt_RSupplierToBePaid & "','" & Me.txt_RSupToBePaidNumber & "','" & Me.txt_RSupplierContactName & "','" & Me.txt_RSupplierContactNumber & "','" & _
Me.txt_RSupplierContactEmail & "','" & Me.txt_RWorkCompletedDate & "','" & Me.txt_REWOKnown & "','" & Me.txt_RWorkCompleted & "','" & Me.txt_RActualCostKnown & "','" & _
Me.txt_RSupplierNotified & "','" & Me.txt_RActualCost & "','" & Me.txt_RAdminFee & "','" & Me.txt_RGSTFee & "','" & Me.txt_RTotalActualCost & "','" & Me.txt_RCurrentBuyerName & "','" & _
Me.txt_RSourceDocType & "','" & Me.txt_RSourceDocName & "','" & Me.txt_RSourceofDocOthers & "','" & Me.txt_BNegoInProgress & "','" & Me.txt_BFNoticeSent & "','" & _
Me.txt_BSNoticeSent & "','" & Me.txt_BFNoticeSentDate & "','" & Me.txt_BSNoticeSentDate & "','" & Me.txt_BFResponseReceived & "','" & Me.txt_BSResponseReceived & "','" & _
Me.txt_BFResponseReceivedDate & "','" & Me.txt_BSResponseReceivedDate & "','" & Me.txt_BFNoticeNumber & "','" & Me.txt_BSNoticeNumber & "','" & Me.txt_BSupplierInvoice & "','" & _
Me.txt_BNegotiatedAmount & "','" & Me.txt_BAmountToBeInvoiced & "','" & Me.txt_BAdminFee & "','" & Me.txt_BGSTAmount & "','" & Me.txt_BtxtClosingDate & "','" & Me.txt_BBLinkToWDrive & "','" & _
Me.txt_BAssignedtxtName & "','" & Me.txt_BReasonToClose & "','" & Me.txt_BStatus & "','" & Me.txt_BAccountingNotified & "','" & Me.txt_BRemarks & "','" & Me.txt_BAccoutingNotifiedDate & "','" & _
Me.txt_BBCClosingDate & "')'"
Regards,
Calgarian
Last edited: