Recent content by ppsandy

I'm still using Access 2003 to manage our membership database, is it possible to lock a field(member's name) if the membership is equal to withdrawal or terminated? Kindly help!!! Possible to use "on click"?

Thank you very much!! how about use "IIf"? I try this formula below but nothing display...anything wrong? IIf[Void]="True",0,[ChequeAmount] Pls. help again!!

Dear All, Kindly help me to do it..... 1. Cheque Amount 2. Actual Received Amount 3. Void (this is a check box and will click it when the cheque cannot present) How can I set the "Actual Received Amount" value to "0" when the "Void" = "Yes"? Otherwise the value will same as "Cheque...

I have "Access 2003" & "PDF Creater" installed and it can help me to save the report's pages in single pdf file. Now, I have to save the filename with the report field value (e.g. customerid + receipt_no)!! Anyone can help me PLS!!

I have "PDF Creater" installed and it can help me to save the report in single pdf file. But I need to save the filename with the report field value (e.g. customerid_receipt_no)!! Anyone can help me PLS!!

Yes, I select the wrong section! I'm still in searching...

I'm using access 2003 and want to export the report to pdf format(each page one file), is it possible to use the field value to name the file? How can I do this?

Hi All, I'm the beginner of access, pls. help to suggest how can i count the selected countries by group(Area) & Total? is it possible to do it? e.g. I selected China, Japan & Korea then the counter box in Asia can show "3" & also can show the numbers in the "Total Box" at the right bottom...