Search results

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

that is exactly what I'm trying to do for my project .Can you give me more details and hints to know what to do or steps to learn Very appreciate your help Mr Gizmo

Thank you so much Mr Gizmo i will try your tool In the past i used a free pos software for the business. but i need more features than what those software has>So i came up with the idea that i will learn Access and use VBA to write a POS system for myself. i started with creating a Checkout...

Thank you uncle Gizmo if I put only 1 UPC in the stock table, we don't have space to put more than 1 barcode number when the supplier change the barcode of item and we still have the previous barcode in stock I'm glad to learn more about your tool .How can I contact you ,sir?

Thank you for your reply Mr the DBguy This is my stock tabe structure .The reason why I created 3 fields of UPC is because UPC is for company code(that is for managing inhouse system). UPC1 & UPC2 are the number on the barcode of the items i got from the suppliers . But sometimes they change the...

Hello everyone I'm trying to make a POS cashing form(i have a database table).i have 3 fields(UPC,UPC1,UPC2) in the table with different codes. I would like to create a form that contains a text box and a list box when i input a code into text box , it will automatically search in UPC then UPC1...