method or data member not found (1 Viewer)

calgarian

New member
Local time
Yesterday, 23:40
Joined
May 13, 2013
Messages
3
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
 
Last edited:

Beetle

Duly Registered Boozer
Local time
Today, 00:40
Joined
Apr 30, 2011
Messages
1,808
You have most likely misspelled a field or control name. Double check the spelling of all your objects.

Also, please post your questions in the appropriate section. This section is for introductions.
 

CJ_London

Super Moderator
Staff member
Local time
Today, 06:40
Joined
Feb 19, 2013
Messages
16,553
Also you are using the underscore to continue on the next line - ensure you have allowed for the required spaces
 

pbaldy

Wino Moderator
Staff member
Local time
Yesterday, 23:40
Joined
Aug 30, 2003
Messages
36,118
FYI I deleted your duplicated thread and moved this one.
 

calgarian

New member
Local time
Yesterday, 23:40
Joined
May 13, 2013
Messages
3
Thanks Pdaldy.

I checked the line restriction and mine lines are under 15 now. But still getting same error. Any other help.

Fields and table names are checked twice and seem to be okay.

Calgarian
 

calgarian

New member
Local time
Yesterday, 23:40
Joined
May 13, 2013
Messages
3
No I am getting :

Object does't support this property or method Run-time 438

error any help on that? I am still still unable to insert data into the table.
 

pbaldy

Wino Moderator
Staff member
Local time
Yesterday, 23:40
Joined
Aug 30, 2003
Messages
36,118
Looks like the other guys have gone offline. This may help:

http://www.baldyweb.com/ImmediateWindow.htm

Also, I notice some issues with delimiters, either the wrong ones or mismatches. This may help there:

http://www.baldyweb.com/BuildSQL.htm

As Sean mentioned, that error is typically due to something misspelled or not on the form. If you continue to get it, you might build the string up a control at a time to find out which one is causing the problem.
 

pbaldy

Wino Moderator
Staff member
Local time
Yesterday, 23:40
Joined
Aug 30, 2003
Messages
36,118
Looks like we were posting at the same time. What line throws the new error?
 

Users who are viewing this thread

Top Bottom