Search results

Dear arnelgp; I found the rout, you made a code for after update, thanks again you really solve my problem. Thanks again Khalil:):):)

Dear arnelgp: Thank you very much for your effort, but can you explain how you did it, can I have your skype, yahoo or another messenger to talk. I really appreciate your help bro. Khalil

Maybe mistakenly did it, so can you please help me???

It is a desktop app.

Dear Galaxiom; I still get the error "Compile error" So, I uploaded the database, can you plz work inside the database and upload it again or give the correct formulae. Many thanks Khalil

Hi arnelgp: Thanks for your reply but, 1. I couldn't find "before insert" i can find "before update" 2. When I give the code i received error "Compile error Expected list separator or) Can you plz help me. Khalil

Yes they are the same meter. for your more information, for sure you have water tap in your home and the meter reader is reading your meter so there is a degree which always change and your will be charge according to your water consumption.

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

Hi Arnelgp: Thanks, but can you do it in my attached database and upload it, because I did but couldn't get result, Thanks for your help.:)

Many thank for your reply Ranman256: Can you please guide me how to do it? Thanks Khalil:)

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

Many Thanks CJ for your reply, I have only one table which contain billing info, because i don't want a person to record readings, we want to get meter reading info from billing, so the last number of meter and current is in one table called subtable, please also tell me where should i write...

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 guys; I am developing a new database for a water utility and one part is billing of customers, now my problem is that when I want to create a new bill for a customer the following should come to bill fields automatically. 1. when I enter a customer number the last number of its meter should...

how to create this facility, please help me through...

Uncle Gizmo, I didn't make this option to record user logon event, which I need it too.

I have a table in my access database called USERS

I don't record user logon too, which I need it as well.

Users which I defined in access user table, which are different from windows logon users.