Recent content by haresh

Hi jdraw, Thanks for reply on my query This to info you that, while update in access query present in this manner only. Why exactly are you using LEFT JOIN?- I want to match all case and then need to update as others record is also available in the table , if i am not using then it wiil...

update Query - UPDATE BNPARB_EOD_Sum LEFT JOIN Trades ON (sgn(BNPARB_EOD_Sum.Position)=sgn(Trades.TradePosition)) AND (BNPARB_EOD_Sum.ChildAccount=Trades.Account) AND (BNPARB_EOD_Sum.CTCLID=Trades.NNFComplianceId) AND (Cdate(BNPARB_EOD_Sum.[Trade Date])=Cdate(Trades.TradeDate)) AND...

Please find below code is using for dump text file into table . Dim NOTISCn As New ADODB.Connection Dim NotisRs As New ADODB.Recordset Dim Tradefiledate As String NOTISCn.ConnectionString = "Provider=" & Provider & ";Data Source= " & Mdbfilepathname & "" NOTISCn.Open NotisFile =...

i am createing Table directly from backed with help of text file (SELECT INTO command) (Create from back end) - following points 1.Command is - strSQL = "SELECT * INTO [Testing].[" & TblName & "] FROM [Text;HDR=NO;DATABASE=" & FileFullPath & "].[" & filename & "]" 2.Command for dumping data...

' i have done throgh command button ---- '1 .sub CMDNOTIS and '2. Public Function Public Sub CMDNOTIS_Click() Dim NOTISCn As New ADODB.Connection Dim NotisFile As String NOTISCn.ConnectionString = "Provider=" & Provider & ";Data Source= " & Mdbfilepathname & "" NOTISCn.Open NotisFile...

I think we need to change registry setting as i found some information from net there setting in registry for disable and enable of edit of CSV, text, paradox date thanks

HI, Please help me how i can edit text file if i add as link table as i don't want to import and export text file. also have problem on link table to edit text file which is in comma (,) separated showing error " updating data in a linked table is not supported by the ISAM"

you can try with "Is NotNull" insted of "isNotNull"