Recent content by shery1995

Thank you very much for your help and advice. Fall sick and could not check the message.

SELECT tblApp.DoctorID, tblApp.ClientID, tblApp.AppointTime, tblApp.AppointDate, tblClients.ClientName FROM tblSchedule INNER JOIN (tblClients INNER JOIN tblApp ON tblClients.ClientID = tblApp.ClientID) ON tblSchedule.DoctorsID = tblApp.DoctorID;

SELECT DoctorsID,AppointDate,AppointTime FROM qrySubformAppoints WHERE DoctorsID=1 AND AppointDate=#14/09/2022# many thanks in advance

Thank you for your reply. Still getting error message (Run-time error '3061': Too few parameters. Expected 1.

Hi All I am trying to execute the following SELECT statement on my form but getting error: sql = "SELECT DoctorsID,AppointDate,AppointTime FROM qrySubformAppoints WHERE DoctorsID=" & Me.ID & _ "AND AppointDate=#" & Me.txtAppointDate & "#;" I would be grateful if can help...

Thank you all for your help and suggestions. Finally got it work the way I wanted. Here is the query: Private Sub cboTransaction_AfterUpdate() Dim SQL As String SQL = "SELECT tblClientMatter.MatterID, tblClientMatter.ClientID, tblTransaction.TrxDate, tblTransaction.TrxMode...

Hi All I have following VBA code on Combo box after update but it does not work and showing message syntax error: Private Sub cboTransaction_AfterUpdate() Dim SQL As String SQL = "Select Transaction.[ClientID], Transaction.[MatterID], Transaction.[TrxDate], Transaction.[TrxMode]...

Thank you very much, got your point. Sorry I don't have any. I had a Dos based solicitors accounts somewhere, I purchased in 2006-7 if I found its CD I will share it with you, provided it work with current windows operating system.

Thank you for your efforts, I have noticed that when I insert the value in amount field if amount is credit then I have to enter the amount with - (minus sign), otherwise it will be stored in debit. Is there a way out to just enter the amount and select the amount is debit or credit?

Thank you very much, you have been so kind and helpful.

Thank you very much for your reply. I am trying to work out what you have suggested, if not been successful then will get back to you for further help in detail.

Thank you for your efforts. I will try and see if can get a result I wanted. Many thanks

You are absolutely spot on. That is what I want to achieve.

Thank you for your reply. I will use on all of them you mentioned above.

Hi All I have a table with following fields: MatterID, ClientID, TransactionID, Date, TransactionType, AccountType, Amount_debit, Amount_credit. What I want to achieve is if (AccountType is = Office Account) then Amount_debit and Amount_credit should show under the title of Office Account...