Recent content by WIL

Using Inner Select Query Solved This. I made 3 table Queries Table1 No Payee SlAccoun Debit Credit CkCode Table2 No Payee Date Table3 No Payee SlAccoun Debit Credit CkCode Date Fdate: (Select DATE From Table2 where Table1.No = Table2.NO and Table1.Payee=Table2.Payee) Or Under SQL SELECT...

This is great... But is there any work around? I tried to export this table to excel Using Ado VBA IN EXCEL SQL = "SELECT * FROM TBLQUERY seems like the recordset does not capture data in the calculated field

Hi I have a Calculated Query Table name DataQuery like Date / RJournal / AMount where Rjournal is a calculated field Rjournal : DLookUp("REFjournal","DV","ChckID > 0 and Payee = '" & [Payee] & "' and Dvnumber = " & [Dvnumber] & "") And it works fine. But since MS Access is my Database and...

IsRecordBusy wont work Even if Setting Recordset to Nothing. Here below is my code still its only up to 2 simultaneous Multi Users. Option Explicit Sub ImportJEData() Dim cnn As ADODB.Connection 'dim the ADO collection class Dim rst As ADODB.Recordset 'dim the ADO recordset class Dim...

True sorry for that, And Thank You I wander if Setting Recordset To nothing rather than closing it will trigger the code Isrecordbusy. Seems Like I close Recordset Twice that is why It cant go beyond 3 users.

Hi Im making a Excel Form in which my Database is an access. First I Encode data in Excel then Using Command Button to Post these data. The code within the Command Button.. first get the Max Number from Access and use that Number to Complete the Data in Excel to be exported to Access. The...

Seems Like the Data will store it as Text and if I convert it to Cdate(DLookUp("DATE","DV","CKcode > 0 And Payee='" & [Payee] & "' And [date] >= " & Format([date], "\#mm\/dd\/yyyy\#"))) Some Blanks returns to Error And if I add up IIF(ISNULL([DATA]),NULL,DATA) It will work but it slows down if...

Works Great! Thank You so Much

Hi all I have A table like this No |Payee |SLaccoun |Debit |Credit |CKCode |Date 1 |ARCEGA |Expenses |50 |0 |0 |10/4/2019 1 |ARCEGA |Remittance |0 |5 |0 |10/4/2019 1 |ARCEGA |Cash |0 |45 |1 |10/13/2019 1...