Recent content by hohai610

Thank you for your patience Answer to your questions 1.All of my units are apartments (for sure ) 2.we have meters for each apartment just for Electricity ( Water and serviced fee are constant ) 3.At the beginnign they pay rent in advance and At the end they pay utilities before check out and...

First , English is not my mother tongue language . So sorry if i made any misunderstand or unclear info . I have a rental business that my house have a lot of ....(don;t know what to call rooms or apartments but it's a unit has all convinient in there like) .All of them is for long term renting...

ok . i noted it thank you

Actually i don't know if the way I'm doing it is right or not so i will explain all my plan about billing system for my database. IF ANYONE HAS ANY IDEAS OR OPINIONS (no matter VBA or query) .Please GIVE!!! I would like to create payment system ( A form that i can input consumption for...

Thank you so much for your advice .Never use UNion query because (most of my time i work on VBA ).But now i think i need to learn more about queries and table design minset. I will take a look on Union query .

Yes Mr The_Doc_Man .That is what i meant. As i wrote , because it is mixed up ( utilities for last month be on the same bill of upcoming rent fee) .So i dont know how to design tables (rent, water , electricity and other fee) .Most of my access database , I'm doing by VBA .But it would be nice...

So For example .The Tenants signs with me a 6 month contract (monthly payment) . I would like to make a payment reference number for each month(which is combined by month range and contract # that on the contract) .But that would be mixed up because First month utilities and second month rent...

Hello everyone I'm working on my own MS Access for rental apartment database. I 'm getting stuck at the payment table. So basicly I have rent and serviced charges( electricity, water) need to be collected . But the first month , Tenants only pay Rent ( begining of the month ) and pay the rest...

thank you so much this help a lot

Im currently using 2013 Ms Access 64bit i 'd like to create a form with treeview control that can show houses and apartments (apartment renting database) Please give any help (alternatives)

Hello everyone I'm trying to create a Table of contents in a Ms Access Form that can have drop down lists like the picture. Is this possible to do so ? Please give advices Thank you so much

can you give me an easy example for keypress events please ? thank you

HELLO EVERYONE ,PLEASE HELP ME ON THIS I HAVE A TEXT BOX IN A FORM. I WOULD LIKE TO ADD AND DELETE QUANTITY INSIDE THE SUBFORM BY THAT TEXT BOX. THIS IS WHAT I WANNA DO. ADD :I WILL INPUT A NUMBER FOR QTY AND PRESS "+" (RIGHT KEYPAD) . DELETE : I WILL INPUT A NUMBER FOR QTY AND PRESS " - "...

good day Uncle Gizmo I was looking over your code and your video . But to be honest to you , I really doesn't have any ideas how to create those forms or what are those variables in the code use for ? Can you please elaborate more for me please? like what type of forms that you use and name of...

I thank you so much for your opinions and your experience . I will follow those steps and see how much i can learn These are very useful with new person like me