Recent content by Khalil Islamzada

Dear all, Thanks for your nice comments, I went through the database itself and finally changed my back-end computer to a server hardware and software, fortunately the problem is solved now and the speed is normal. Thanks again for your nice comments and ideas. Best, Khalil

Dear all, Thanks for your kind reply, I have an idea to install a server computer for back-end data, do you think it will help? Khalil

Dear all :), I have developed an access database for customer management of a utility, which nearly 65,000 customers have been recorded with more than 200,000 billing and payment records. Beside around 25 users are working with this database at the same time. - The database is split into...

Hi, I have an access database for customers, which I need to have running sum. I already used the DSUM formula but it is really slow, I need about 5 minutes to run this query. the columns are as follow: ID Year Month Customers Rsum 1 2012 1 10...

Hi Pat Hartman, Thanks for your comment, I think I should say it this way, I have created a billing database for a water utility, all the billing and payments process are fine and have no problem, only issue I have now is that the water meter is asset of the water utility and they bill...

Actually this figure should appear once a year automatically, for example if a customer was billed in January 2015, he should be billed in January 2016 or after that time. because sometimes billing don't occur on the same date. maybe next time billing would be February 2016. Please if anyone...

Dear all, I have an access database which use to print bill for customers. one of the fields which I have is meter rent, I want that automatically once a year this field fills by 100, can anyone help me? For your more information, I have many other fields including current date/time. Best,

Thank you very much arnelgp, my problem solved. Best,:):):):):):)

Dear all: I have below code; Private Sub CusCard_No_AfterUpdate() Dim lngBillNo As Long Dim lngOldMeter As Long lngBillNo = Nz(DLast("[Trn_No]", "Water_Journal", "Cus_Card_No=" & Me.Cus_Card_No), 0) lngOldMeter = Nz(DLookup("[Current_Meter_No]", "Water_Journal"...

Hi, Check out this youtube link, it will help you. https://www.youtube.com/watch?v=CKUYHqZQhiw Khalil

Dear Plog: Thanks again for your helps, I did the following; 1. In form created a control box 2. I did the dlookup formula as you said But as you can see in attached database, It is good that in a new record you will see the remaining balance of each customer. But the problem is if you see...

Dear Plog, As you said I illustrated the DB and uploaded, now I have two questions; 1. In transaction form, where should I add remaining balance of the customer? 2. How to do Dlookup? Many thanks for your help in advance. Khalil

Dear Plog; Many thanks for your advice, is it possible for your to do the query and dlookup in database I uploaded that I can use it, because I am not that familiar in access. Many thanks Khalil

Dear Arnel: Please when you have time check below link, I really appreciate your previous advises and helps. http://www.access-programmers.co.uk/forums/showthread.php?p=1514539#post1514539 Thanks, Khalil

Dear All I have a table called transaction with below fields; Cust_id, Debit, Credit and Rbalance (remaining balance) columns. I created a query and can have the balance of all and each customer, now I have a form and want automatically calculated balance appears every time I create a bill...