Hi...
I am New to MS Access and I am Using Access 2013 64 bits...I want to insert userform data into access table using vba code i.e select into table and value...
But the data to insert into table is huge....i.e data field is alomost 56 textbox and i am unable to use all textbox value into vba due to line character limit.
How should i do this...
for example...when i post below code into vbe it shiwing red line
CurrentDb.Execute "Insert Into Group(& b1 & b2 & b3 & b4 &) " & _
" values( """ & Me.branchcbo & """,""" & Me.txtsfoname & """,""" & Me.txtsfoempid & """,""" & Me.txtlafno & """,""" & Me.txtrelationshipname & """,""" & Me.txtmobile & """,""" & Me.txtvoter & """,""" & Me.txtage & """,""" & Me.txtdob & """,""" & Me.txtaadhar & """,""" & Me.txtrationcard & """,""" & Me.txtlightbill & """,""" & Me.txtaadress & """,""" & Me.txtpincode & """,""" & Me.txtclientname & """,""" & Me.Combo398 & """,""" & Me.cborelationship & """,""" & Me.txtkendraid & """,""" & Me.txtcbid & """,""" & Me.txtcbstatus & """,""" & Me.txtnomineename & """,""" & Me.txtvillage & """,""" & Me.txtcbdate & """,""" & Me.txtsuprtnoczhapp & """,""" & Me.txtloanacno & """,""" & Me.txtdvufile & """,""" & Me.txtvillagecode & """,""" & Me.txtnomineeage & """,""" & Me.txtnomineedob & """,""" & Me.txtrelationshipnominee & """,""" & Me.cboinsurancetype & """,""" & Me.txtnamebankpassbook & """,""" & Me.txtifsccode & """,""" & Me.txtaccountno & """,""" & Me.txtbranchname & """,""" & Me.cboloanamount & """,""" & Me.cboloancycle & """,""" & Me.txtpdtname & """,""" & Me.txtgropuordate & """,""" & Me.txtgroupfordate & """,""" & Me.txtfinancialtradate & """,""" & Me.txtgroupappdate & """,""" & Me.TxtDisbDate & ""","
""" & Me.cbobankname & """,""" & Me.TxtPdtcode & """,""" & Me.TxtNeftAmount & """,""" & Me.txtState & """,""" & Me.Txtcluster & """")"