Recent content by simonyu

Hi Paul, I tried but there was RED line so it could not execute. Thank you, simonyu

hi the_doc_man, I use below line and it works. rs.FindFirst "table_id=" & Me.id & " AND category_id=" & Me.category_id Thank you very much, simonyu

Hi pbaldy, These datatype are Integer. I tried your suggestion, however the line turn to RED and could not run. Set rs = db.OpenRecordset("SELECT * FROM TRIAL_BALANCE WHERE [table_id]='" & Me.id & "' AND [category_id]=" & Me.Cat_id") MajP, MarKK, I intend to find the record and Edit then...

Hi there, I try to use Findfirst to search for records. However it only works when I use Findfirst with 1 criteria but not with 2 criteria.:confused: Did I do something wrong? :confused:Here is the code. Thank you for your help:) There are 2 tables, TRIAL_BALANCE and BILL_ITEMS tables. In...

Hi everyone, I am working on a bookkeeping system. It frustrates me because my Access knowledge does not make my program working. Hope to have help from you guys. Thank you in advance. SimonU