Search results

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...

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,

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"...

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...

Dear All: I want to develop a database for customer management as below details. 1. Customer tbl (contain cusomter info) 2. Billing tbl (contain billing info) 3. Payment tbl (contain payment info) Now, in billing form I have a field called "remaining ", I want it automatically calculate the...

Dear all; I am developing a customer management database for a water utility, therefore I need to add billing option to database but I have one problem and hope you can help me. I have a table and a form for billing with following fields CustomerID CurrentMeterNo LastMeterNo and other...

Dear All; I am developing a database, with following tables and queries for a customer management. Table and query for customer registration Table and query for billings Table and query for payments Now what I need is; 1. a query which shows the balance of customers 2. in a form that I do...

Dear all; I just searched a lot in internet but couldn't find what I want, so I want to share it with you and hope you can help me. I am developing an access database as follow; 1. I have table called "customer info" 2. another table called "customer type" 3. A table for billing Now, in...

Dear All; I am developing an access based database for a water utility. everything is going fine with my database except two issues which I am sure you can help me. For billing of customers I need that the last figure of its meter appears automatically when I enter the new figure. also if...

Hi Everyone; I am developing a financial database in access program, I have one problem and hope you dears help me out; I want to add Audit Trail option, that when any user enter, edit or delete data from database form, it will be recorded, I have searched already but the I found some audit...

Hi everyone, I have made an accounting database, in journal entry form I have total of Debit and total of credit, I create button for new, next, first and last record also in build event i ordered that if text26 is not equal to zero (which is different between Dr. and Credit columns), don't go...

Dear all; I have an access database which has the following tables; tbl1) customer info tbl2) billing info (more than 5 years) tbl3) payment info (more than 5 years) In the first table I have info from all my customers, in the 2nd table information about billing amount and date and in the 3rd...

Dear all; I have made a database for salary payments and I want to add the salary advance/loan to this database, so what i did is as follow; Table for staff ID Table for staff salaries Month Year .... For the salaries I don't have problem,but 1. I have a table for salaries which contain salary...