How to sell real estate in ms
Real Estate Rental Houses Management System using Ms Access and VBA | FULL TUTORIAL Start to End
0:00 / 0:00
Timecodes:
hi guys
uh welcome to Visual Basic for
application and Microsoft Access
tutorials in this session I'll be doing
a demonstration on how to create a real
estate or rental houses management
system uh so this is how my system works
we launch our system the XX Frets real
estate nakur limited so here I key in my
credentials done
then I am taken to the dashboard when
I'm in the dashboard there are several
things I can accomplish like for example
I can set the month to the next month
like for example we are in January so I
can set February or March then I can
also add tenants but before you do that
we can just hide the ribbon so once we
hide the ribbon I can be reposition to
add a new tenants so I just go to this
GUI here then I can just add a new
tenant right now I will have a new
tenant
my customer name here you can have
Adam's arcade then cell phone you can
just put an imaginary phone number there
then then that date or date of Entry
house number it's gonna have J that's
the house number plot Number let's say
23 terms and conditions you can type
there for the year and the month there
will be Auto generated since I have set
it to be the default values so the
category here is one bedroom location
let's say nakuru and then these ones you
can capture documents like there is the
rental agreement the photo the ID if you
may need then the next of King let's see
Carline
address 34.
accounting of residence kissing deposit
this guy here speed with a deposit of
52. so from here I save the record then
I can cross this so guys when I go to
this one you can see I have a new
customer that is Adam arcade who has
paid 52 pounds for the deposit and this
one was paid by cash
then after doing this I need to feed the
rent for January for this person there
you are you can see for Adam's arcade
he has not paid anything so the rent for
this month let's say it's 5600
then after doing that
there is the water bill probably uh we
we approximate he he used for 20 or
probably everybody else was paying that
then we have the electricity bill you
can capture the electricity bill there
then guys after doing this you'll notice
that um this system will not allow you
to go to the next record since you're
not supposed to add this deactivated
Fields like house number date enter the
deposit tenant Name ID number month and
the year those ones are supposed to be
captured using
and this form and therefore there is no
way you live in a position to add them
here and therefore that's why you see
when I got to this point here even if I
tab I will not be taken today to a new
field I have disabled that then from
there you can print receipt for Adams
again you see this is what Adam's arcade
has uh paid here these are this is his
uh stuff here he has paid rental 5600
January for 20 at electricity this is
the receipt for for this guy here
so after having done that
after having done that one here so you
just need to click again click receipt
in case you need to have that so if I go
to the month of April here we set the
zero for him so he's supposed to have
zeros so that when I go to this point
the receipt can produce the total so we
just go to this point there we are so
you can see now the receipt is complete
uh but later on We Shall Set the the
currency to the currency of your country
so guys this is how now this system
works so in case I want I want to feel a
rent for February here you see there is
no way I can do that unless I set this
one to I set this one to February so I
just click on this one and then I set
that one then I close the system
therefore this one copy to clipboard
save record copy to click code is okay
so if now I restart my system here
if I I restart my system
let me just cancel this
let me cancel this one
I want to use access
2021 instead of that one so re-list it I
open my office
that is my program again so I got done
done there we are so you notice that um
uh for the month of February it is now
ready to accept data so I can just go to
this guy here mode of payment let me say
check he has paid 5600 that's the rent
water bill
we pay
let's see
20 electricity let's see
40 52 that way so you notice that um
when now I save this record here when I
refresh I save this record here
you see now this guys again these ones
have zero zero zero so if I go to
February uh that is to January it will
be zero zero May zero zero
everything will be zero zero zero zero
but now here for April again we have
zero zero so this once you need to also
to do zero zero zero
zero zero zero zero this is zero sorry
this is z zero zero zero
we must set the demand that is left
blank to zero
so this is zero this is zero this is
zero so after doing this if now I go
back to February I click on this guy
journals print receipt there yeah you
see now they received for journals is
complete and you'll notice that January
it is zero zero zero February it has
taken so when we set it again to match
the same case the price and for that
case you realize that the system is
working 100 but if I need to see the
annual payments here we are so you can
be in a position to see
uh some of the payments here this is
only that this one is a bit
Raja this one for the journals but uh if
for example again
we set our system back to January we've
been opposition to see that the the this
one is working like for example if now I
open this the system if I open the
system
and okay that one will not breathe the
hair off until we set the the man so in
case I go again too much go to match yes
yes
like that then I refresh
copy to clickboard then I need to go to
this one
then I come back here you see demand has
changed much
you see now this one's becomes blank
is ready to accept data for the month of
March you see the system is working
perfectly so guys I will be taking you
through step by step on how to create
this system from scratch in my next
video so keep on uh awaiting keep on
watching there it'll be in a position to
to see how that system is actually
created from a scratch so let's let me
just log in again
uh let me just log in
so I just go to this done is the
password and username so hide ribbon
then here you see I'm logged in as done
so when I click on this ones my system
now is active and ready to accept uh
data for the month of March you just
check here so it's been a position to
see redmi feed this guys like now and
feed this guy this is cash cash this one
paid 4500
56
I'm sorry Escape
this one page
that one
turn
then paid 54.
103.52
this paid 5200 paid 230 and 25 16.
this one played at one
is paid 520
this one five
so this one is 7400
this one is 23 this one is 53 then I
needed to double that one so this is the
data we have for demand of uh match so
when you go to this point you need a
position to see the Monday that is the
Mandarin
uh that is the mandri
statement this should be Monday I will
change that later and you see now you
have my interest is in the month of
March you see in the month of March I
can be in a position to see but later on
uh in our next video we should have been
a position also to see how you can now
create a a an annual statement that is
showing January February March Etc so
guys keep on checking I will be back
with part one where we shall start by
creating the tables and queries then
later on we shall proceed to
VBA guys thank you very much for
watching Remember to subscribe if you
haven't done so remember to comment and
also remember to also add more ideas on
what we
you would like me to do next thank you
very much
hi guys let's proceed with
a rental or Real Estate Management
System
uh this time round we shall be doing the
system from scratch so right click go to
new go to folder so we call this folder
real estate
estate
management system
so I opened the folder then right click
inside go to new then access Microsoft
Access so this is this one is our XX
real
estate
rentals
micro Limited
so this is our system I have given
access a real estate rentals so here
I need to access Open Access so I'll be
using access
so I don't access then go to open go to
browse
then I go to desktop I go to
where R is re-listed then launch our
system
so enable Macross then from here we need
to create our tables so we shall create
two tables we shall create tenants and
we shall create payments so what I need
to do is to click on create then I just
go to
table design then here I I do my things
so I'll have payments
PVD stand for payment so you are a half
payment ID number
this one will be text so p
ANS for
payment table
so we have that one then you can have
serial number this is Auto number and
primary key then you can have
which are half January
John
Feb
much
that we April
I mean
June
July
August
said
September
September
October
November
November
December that way
so these ones will be our currency this
is currency I'm topping letter C on my
keyboard using the down arrow key
so these are the payments that will be
done in that month then from there we
shall have the water bills so we shall
have water bill one water bill 2 water
bill green Ortonville 4 water bill 5
water bill
six water bill 7 water bill eight
water bill nine
water bill 10. then you shall have water
be 11 then water bill 12 we have 12
months
then from there we go to electricity
electricity one electricity two
metricity three electricity 4
electricity five
six it is at a seven
eight electricity nine
this really bling trouble
it is at a 9 it is it ten
at least the T level which is the time
now it is 12. so here
uh e
e
stands for electricity
whereas W here w
stands for water
bills
so guys after having done that one
uh we can also include mode of payment
here
mode of payment
avoid space mode of
payments so on the mode of payment we
can use Lookup Wizard so I go down here
go to Lookup Wizard then I go I will
type in the values that I want next
so here I type cache
cache
then we have check
then you're gonna have EFT
you can have mobile
mobile money
and others
others then finish so so far we have
the complete table so I just go to save
then this table of mine will be called
payments table
so after having done that I right click
and close that then I go to create then
again table Design This Time round I'll
be creating the 10 unstable so we start
with the ID number ID number of the
client right click the primary key then
you should have customer name
customer
name that is the tenant then the
telephone there
or we can have the cell phone
each other half
a date
entry
date entry which are half date
exit
date exit
so this is date and time this is the
date and time
then we shall I have
reasons for exit
results for exit then it shall have
house
number
finish at a half
fret number vanisher half terms and
conditions
terms and conditions you can type a
sentence so we need to have wrong text
for memo
finisher half the the tenant year T here
stands for tenant here this number so
this is T
here
means tenants here
it means tenants here
then you shall have three months
demand here stands for
three month
stands for
tenant man
it's important for us to be categorical
so we have the house status
where the house is vacant or not so
house
potatoes so this one is yes or no this
is vacant
or occupied
then we go ahead we have to have the
category of the house category
so category guys we shall use procup
wizard so I go to Lookup Wizard I will
type this is the value number two next
then here I shall have babysitter
babysitter you can have
one bedroom
double
the book you can have
her
so we can have those ones then
having done that you can have documents
that somebody May upload you can have
document one document two
documentary so this one's
uh we shall use attachment
shall use a data type called attachments
you can also have other type code
attachments which are all have another
database called attachment then from
there we can have other feeds like next
of kin
uh next
of kin
next of King
next of kin we can also have address
can have
address
you can also have home County
that is home
home
County
then we can have after home country can
have the amount of deposit deposit
or down payment is currency then last
three can have house location
house
location so guys this is the next table
the wrong ads are also around a table
then you save this one go and save this
one is tenants
maintenance
there we are so these are our two
tablespoons days but we need to
uh have so that uh our system can really
run so from here we need to
we need to
proceed to queries now that we have
created the
we have created the the two tables so
what we need to do is to proceed
is proceed to
we proceed to
queries so create go to query design
here we need to create the query so I go
to show table add tables up here then we
shall have our payment table not and
tenant table so the talent table is the
parent table so I can just pull this
downwards a bit this way like this so I
need to bring these fields first of all
uh make sure you click this minus sign
that one should look like that to avoid
so many unnecessary so many unnecessary
Fields so here I double click I double
click
so that all the data can be entered in
my query
so I need to do these terms and
conditions
then I go to here
here and
house category document one document to
documentary I go to next of King address
I want to see whether they are being
added so you scroll we have home county
deposit
our location then we start for the next
table
for the next table here you have that
one January February
January February can have much
April
May
June
July
August September October November
November December then there's a score
I will proceed what a bill one two three
four five six seven
eight nine ten eleven are off you
continue scrolling
then we go to electricity
we put them
we also
make sure that um
things are running smoothly like that so
I save this one just call it main query
like that
then after doing that
um I cannot proceed to
to the other at the other section
the other section now I just go to
creating joins
ah see what I'm doing here I will just
equate the feeds that are equal so here
I bring the ID number to pin number
double click so I use option number two
include all records from mother to go to
child then I go to here
where is there
I need to go where the ear is
um
okay you need to go go back and add
those ones let's go back to payments
you need to add those fields important
fields for equation so here I need to
have
um
uh here
I just got to
the
tea
p
month
P month
a disputement
P here stands for p
month B
stands for
payments table
then you have P here
v c c this is
A P stands for uh that that one so this
one was missing so cross this go back to
query right click go to design view
uh go to
P month and P I hope I have added them
here they are good so now I can equate I
can just equate p e r to P here
then uh P T man to that one
there there yeah then save so this is my
main query so if I could not display
anything since there are no data that
has been uh added so I go back to this
way for example now I go to tenant I can
add two tenants like for example I can
use any other ID number but it is
important to restrict the ID numbers to
10.
so that somebody may not keen irrelevant
numbers customer name here is have
Adam's
London's cards
date entry
then house number can have house JK 450
fret number one
then here here is 2022 month is
January so to automate the months I can
just go back to here month so I go to
default value
January January
then for the year here come here here
just go to default value then write um
right here
open a bracket
date
open the bracket cross the bracket cross
the bracket
good now that one here this function
will give current year as a default
where you see it gives 2022 so we can
have another gentleman here
here we can have John
Peter
then that you choose from the calendar
house number
and number 451 or 452 fret number
uh
one
then the others will automatically so
this is occupied this occupied like that
so when I go back to my query you see
that it has started it has started
are getting data it has started now
getting data from
the tables so after having done that now
you can duplicate this query you can
duplicate this query by copying and
paste once you paste you can just call
this one something like data entry
that
entry queue like that so we have we have
that one that is the we have the tables
and also we have the the query so guys
that is the the part that I wanted us to
run in part two in my next video I will
be doing uh guis or the data entry forms
so that uh we come in a position to know
and see how that one is supposed to be
done remember to subscribe and also
remember to share my files with your
friends thank you very much
welcome guys to Party 3 in this session
I'll be doing the GUI I'll be doing the
the form that is the dashboard
so the dashboard is getting its data
from data entry queue so what you do you
just go to create then you go to
form design then you can just enrich
this one like that you can give it some
color so go to this point give it some
color then right click go to form header
and footer this portion was missing so I
right click here give this color break
then save this one save this one as
data
button
data entry
data entry
so after doing that
you need to
get data from main query so I just go to
a property sheet here then or here I
choose form so record Source here you
choose data entry then close this save
now from here I can build a position to
have data you see now I have all my data
here this one we agreed you remove those
ticks they should be mine and they
should be plus not minus so this is the
data that I need to put here but before
I do that you had seen there were some
buttons for every month here so I
usually use Togo buttons so you get the
Togo button this is the Togo button then
you draw your first Togo button then
copy
paste now you see I have three
I need the fourth one then I can copy
this copy paste so I bring these ones
here
sorry I undo
I just want to Blink these ones here
then now
those are four times two eight so I need
to copy paste again so that I can have
the the other rod
like that I can also uh paste again
that way so then this one I have give
them different cargo format here shape
just give them color green this is what
I had done then from here remember
you're designing the the GUI that is so
this this is this is January
January
this is February
this is much
this is
April
this is me
June
we have July
half of July this is
August
this is September
this is
October
November
and December
that is what we have then you can just
cross this
here this one can be
show
ribbon
this one can be hide
ribbon
then this one can be something like
cross sorry
I have to double clicked by mistake
cross form
when the sun can be removed so these are
also important buttons that you shall
reuse later on but for that case you can
change their color
to them have different color and also
formats
we have different font of white
so this is what we have so this I am
still working on my GUI how it will look
like then
after doing that you can also assign a
rainbow here form design rainbow
shall have an important variable here
just tap spacebar so that the label
cannot disappear then go to properties
it is called rainbow 16. that is very
important so I save that the next step
is to bring the data here so I go to add
existing data
here then you bring the data you want
I want that one you remove the rainbow
so I need that one
I need to have the ID number I need to
have the customer name you remove the
label
you don't need the reboot so the ID
number
and you need the the customer name
then I also need to have a deposit
deposit deposit
the deposit to this guy paid
we had the deposit listen it was just
reduced the deposit is here so I removed
the remote bring the deposit there
deposit then date entered date of Entry
move the label
that is the date
then we shall have a mode of payments
hold of payment
code of payment
out of payment then you shall have the
house number
the house number
the house number
this one has a number remove the river
we shall have the house number
yeah then from there
the next thing we need this one should
be somewhere there that label the next
thing we need to have is the to have the
water bills just come Point here draw
the rainbow this is the
Cortana
bills
so give it
and also make it something like tutorial
that is that the the water bill then go
back there
take the next Point here you shall I
have electricity
bills
then again go to format
do the same
world give it size 12 so this is the
electricity bill
so after doing that
the last part here we have the month we
shall I have the
demand
command and lastly the ear
there
then again do the same go to format
caravoid World size store
so here I'll just go to this point here
remember we have the T ear so I remove
the rainbow this we have the T here and
also we have the three months don't
forget
you have the tea months
the tea ear and the T month then this is
the T month comes there P year goes
there then don't forget we have the
equation P month P here so I remove the
rebels
I remove the ribose
then make these two invisible these two
highlights go to uh property sheets here
visible not visible
then P month take it on top of p man Pia
on top of the year then after doing that
one we go back again to this end go to
add existing remember we also have PID
equation of this one so I go to P ID
number remove the that one then also
make it invisible
that one is just to allow data flow or
to have relationship or the joints then
after having done that you go to add
existing Fields here
scroll down
first of all bring these ones here bring
this once we have John
all the way to December drag and drop
them here
then drag your mouse on this end remove
the ribose you don't need to have the
robots delete so that you can be left
with that then here we have the water
bills
we shall I have
this one so you shall have to arrange
this one January
that way on top of the other one
this one should be removed this should
not be there so this one should be
arranged on top of the other one
then after you do the coding the coding
will display them the coding will
will just work on that to make sure
which one is
visible at what time
so that one is that way then I go here
arrange December here December should be
there then save on the other hand now we
put the water bills go to add existing
take water
because
certain with water too
we shall have to go back
to the table first of all close this go
to the table payments
you can see what what is here
I don't know where it has disappeared to
right click design view go to this one
you should have order one
don't worry we have put water on
so
probably I have put it together
so I just go back to I add existing here
I go to
uh
close this
go to the query data entry then add
water one
it was missing there
so I go to it click design view I go
back to this so now I'll have to turn
Quarter Two all the way to water 12 I
bring them here
don't forget also tawan is here
so across this remove the rebels these
are the ribose
this one should you you just a drag and
delete them
drag delete to them so again we arrange
this one for water
this one for water you arrange them here
one by one
on top of the other one just like we
have done the other one there remember
guys we are designing the GUI the
graphical user interface or the
dashboard where all operations will be
carried on
so you do this
you also do that well you also do that
one then after having done that we do
for the electricity so for the
electricity it just appear here so go to
add existing go now to replace it one
hold shift key and click the tutorial
bring them here
then from there you drag your mouse here
remove that one so now I will have to
again arrange the requisite there
retricity
I want them to be shattered to be
so we can just bring them here so the
electricity again should be arranged
on top of the other one
just like I'm doing
you see
how we are going on where
good so after doing that guys I come
down here pull this
pull this upwards
pull that one upwards then until it goes
to that point you see then from there I
need to put a button here that will uh
that I took a button click draw a Togo
button you can go to format give it
currents then this is print receipts
which is print
receipt this one will help us to print
the receipt later on we shall see how
that one is accomplished so this is
print receipt then save
so far guys this is what we have
this is our GUI so right click go to
design view
then go to property sheet the first
thing is to make sure that there would
be no data entry here so I go to data
entry additions now additions now you
see now it will not arrive here I see
there is no way you can add data so
again we go back to property sheet go to
or
then scroll upwards go to where default
view single form double click this
should be continuous form now you can
see that as I add guys here they will
appear more and more like now if I go to
tenant stable here and add another
person
here I add
um
James sharks like that I added him today
you see if now I run here and refresh if
I refresh you see I have three guys so
once you set it as running that is
continuous it changes the
it changes the the the format so the
format should look like I have done so
far so then from there just go to this
interview again here
is p
P we said visible no
this one should be visible ID number
should be visible
what should not be visible
is the
is the this one this one should not be
visible
so again I pull this back
Wards then sleeve yeah yeah you see now
this one is visible then we need we need
to disable all these apart from now the
the mode of payment so we go to design
view
you disable
we pull this down
this one can be
taken that way a bit
so that the customer name need to be
longer so I needed to disable all sorry
I pull the mouse I need to disable that
one is so data enabled no
then I go again to house number
enabled no
then we go to
these two months and year unable to know
it should not be enabled because we
don't need them tampered with
then just pull this up see what we have
so far you see now the only uh the only
the only active feeds are the ones we
want to feed so you can see when I'm
trying to select here I can only get a
beep the computer is not Microsoft
accept is denying me so you need to set
data set so I go to data here you choose
the phone
we choose the form
then data set here record Dino set it
should lead in constituents updates now
you see things will change
you see now can be a position to feed
you see now it's changing because I have
changed that then there is this hash
just I think this is the deposit
so we take that back
because it should be increased
like that
yeah therefore you know we can now see
Kenyan shillings so this is how now so
far our graphical user interface looks
like then uh on the next thing is to let
me see
whether probably can at least
and adjust these ones to come somewhere
there
it will be interestingly this one to be
somewhere there so that this ones can
come over
can have
a bigger row yeah like that so this is
our graphical user interface but we need
also to do something here we need to
draw a label here
we go all the way up to somewhere there
so you have ID number
tenant
deposit
date
date entry
mode off
mode of payment
then house number
what's the number
so this one should be somewhere there
house number
so this is what we have
but I need to pull this up
so this one should be format caravoid
and board so this is what I have so guys
if I run this see what I have so far
this is my graphical user interface so
after arranging the graphical user
interface
in my next video I will be doing the
rust and final touches where I'll be
doing the VBA
then later on we shall do the startup
objects like the splash foam and the
login screen then our system will be
complete so guys uh don't run away just
stay on board so that we can be in a
position to do the final part of the
program that is the VBA coding together
remember to subscribe if you you haven't
done so also share these videos with
your friend thank you very much
let's continue with our real estate
rentals management system in our last
session we created the dashboard so
today we shall proceed with the coding
part of the VB so we go to design view I
go to design then I go to properties
then here I will go to form 10 event I
want one of the form roads these buttons
are hidden so I just go to event then I
hit the three dots then from here I need
to do some coding first of all here you
can just include option X preset
explicit explicit then from here just
come to this point we want to disable
are disable electricity
electricity so what you need to do here
is just to have E1 dot visible equals to
false then we have E2 but
visible
equals to force so we can copy these two
just to save on time
copy this
take the cursor here
press enter paste press enter paste
press enter paste then
I will move this one this so this is e
this is e
3 this is E4 this is E5 this is E6 this
is e
7 this is e eight so we paste again this
is E9
electricity 9 this is electricity 10.
um 10.
and we paste again this is electricity
11.
this is actually that 11 this is
electricity 12. so this is to disable
electricity then we go to next uh we
have to disable
disable water
this is the water
so to disable water we have wd1 dot uh
dot visible equals
equals to force
then W2 that is water 2. visible equals
to force
then we have W3 dot visible
Waterbury dots
visible
equals to force then copy these three to
make your work easier copy Ctrl C then
paste paste paste
so this is
actually there so this is the video
three this is W4
W5
it could be your six
W7
W8
W9 is 10.
this should be 11. so I have now
disabled
water so we go to next one we disable
the months uh
disabled
and so for the months you have January
dot visible equals to force then you
have Feb
dot visible equals to false then you
have match dot visible it costs
to false
a pre dot visible equals to force
me dot visible equals to force we have
June
foreign
so guys after having done that one
you'll notice that um
I have records so we go back to save
then hit the access button go home view
realize that the the staff is working
here you see
the electricity water and and demands
the mans were here
have been disabled so the next point is
that um when I press January the January
stuff becomes active when I press
February the February stuff becomes
active but hides January and all other
months so guys we right click we go to
design view here basically go to this
interview then I hit on January now I'm
calling for January of which I repeat
for all the 12 months but I will Quicken
the process once you understand how to
code the first two months then the other
one you can also copy paste so guys just
go to event on click go to event
procedure hit the three dots now what
you need to do as a bright
programmer just copy this there is no
much need of coding so I have that one
then I just come to this point
and I'm in this point I write a comment
that I'm calling this is January
January called
so you paste it there remember January
is the first one so here this becomes
true all the others remains false then I
got water one water one is for January
so this remains true or other remains
first electricity one is for January
this remains true or the others remain
Force so as simple as that I have coded
for January so save that one
now when I go to back to access button
here and hit view then I hit on January
see guys what will happen the January
stuff is activated but all the others
have been hidden so we go back there is
something we have forgotten to do we
need to click when we click on January
this treble here Rebel 16 says January
so I go back to this one then here I
just type that um
Reborn
teen dot caption equals to January
January see so when I click on this
button Rebel 16 says January let's see
whether that one works so I click on the
button then I zoom out then home view so
when I click on January there we are
guys you see it says January but when I
click February it will say February and
open this one's for February allowing me
to capture data for favor for that case
you can just format this one to Center
and that one to Center then red in color
or I think white should work better
quite then go back format there we give
it 16 then save home view so when I
click on January guys you see it says
January so we go back and call for
February
so I got to February then I got to go on
click Event Event procedure hit the
three dots so I paste that
this time round this one is called for
January
God of February
the February
February that is for for easier for up
so this one two two E2 is for February
becomes uh true what are two that is for
Monday 2 February becomes true any other
remains Force then February here comes
true so we shall repeat the same process
whereby all the others will be false
like one is for January two is for
February blah blah blah after 12 is for
December so you will make sure that at
the end of the day your card is
everything here has true but if in a
single occurrence all the others remains
false so that's how we shall go about it
so we go back here
cerebral and rainbow 16 dot caption
equals to February so this one says
February
that says February I saved that one hit
the access button save home view so guys
when I click on January you see it opens
for January and if I take something like
4500 this one I type something like 1200
this one I type something like 1000 that
is for January so when I click on
February you see for February is blank
so I can just come here and feed for
February 2000 this one is 120
electricity I come here and save it 50.
so when I go to back to January see guys
for yourself January and February are
too independent uh that is too
independent months whereby none of the
demand is tampering with the other one
they are being switched by the VBA code
so guys if you have seen that one it
will be now very easier for for you to
call the other months just go to design
view you go to match event
I'm going to click event procedure you
repeat the same like now this one is
called
this is called for match
so I just paste matches Monday number
three so again we just do the same
variable
screen dot caption caption equals to
match as simple as that match so match
is man the number three so this one
becomes true
see once you code once you just recycle
the chord true
W3 that is for March oh yeah true
then we go to match match here and it
becomes two all the others remain false
so that will be the order of the day
whereby again when you save and come
here click on January see February March
you see now the system will allow you to
only feed the month that uh is active
for that Junction
so after having done that one
now you you see that
this one's this is
still
16.
it looks really good so we go back to
this
and go to
him so
if I open this one
and there is this one that is opened
you have to close this one
so if I go to this one you see it's
working April April
April October
okay let's see November
some issues
good now it's working so the next Point
here is to set uh that uh when you feed
data here the data is automatically
updated here without
missing some of the fields so I delete
that one so I need to do a bit of um
that is a bit of
coding so I go to this point now I want
to record on these points here we have
the January January
that is the month so we got one of the
months here like December then go to
design then go to property then you go
to event on roster forecast that means
macro function that runs when a control
or form loses the forecast so I just go
to this point event procedure and lost
Focus I click the delete dots so on Lost
Focus we shall have that PD
that is payment ID number equals to ID
number of the tenant then the month the
payment month becomes the the amount of
the tenant then the the year also
becomes the RT here
so that's what we shall repaid so this
one is for December so I just copy this
yeah just paste it down here then we
change this one to November
this is no
November then again I paste it there
this becomes October
October
that is for October
then again it paste
it becomes for September
then again say for September this is for
August
then we have
July
this will ensure that data is duplicated
in the child table this is called June
if you fail to do that one you notice
that data will not be saved
or it will just be staggered then you
have June we have May
we have
we have April
which is real
we have much
much
we have
February
and last three
we have January
so when you're feeding data for January
January and later months this one when
they they found the
control research Focus the data from the
parent table is equated to uh that one
so I'll save that one then I go to this
point like for example if I just come
here and
in data Forge for that is for January
again 4500
let's see 120 520
electricity 100
this again
5800 then
360 then 520 when I change the Mrs cash
cash
is enough if now I do that
then go to February
again
2300
this is you want to pay this one
that way then this source of cash cash
now uh if I cross this
okay we have not yet assigned the cross
button so when you go to payment table
here
uh you'll notice that uh
payment table you'll notice that the the
figures have been captured apart from
nowadays that means still there is
something we have not done you see it
should also lubricate the
actually lubricate the ID then that
means still there is something that's
why data is disappearing here because
you have not yet assigned the correct
parameters so again we go back to at
this point go to cross go to data entry
here
so I got to
data entry
data entry
I need to go to
design The View
here then I go to
this other functionalities that I
equated we have this ID number demand
and the rest so we have this one
we have payment and command so
hit this one p month you go to design
review go to property sheet then go to
onrost focus here also do the same for
it you paste that I need to remove this
and leave it remove
so this once I copy this
that is 40 month I save
again I go for the the payment
okay
you paste that one
save
again I go to the other one that I
equated the other one I equated is this
one the
ID
20. so I paste
then again I go to this cousin
I paste the same
address 3 which other one did I equate
the P this one the the payment so design
properties
okay sorry they are human
so it is the demand
sign property sheet
okay so after doing that one now it
should work
the work so I bring this back there then
hold this take it upward there then save
so let's try and see
so we have 1200s
500s
5600 this is
cash cash
so you have that one so
this one hasn't worked
why that one might not be the case let's
see let's see let's see
so we also fixed the T here the t e here
is
missing that
you see the T here is missing that save
then you also go to the other one is p
here
sign go to properties
uh event
we also put that one t e r and b any
field that you equated you must type
this that is the equation must be
so I close this take this back
then
take it up
save and run let's see
so first of all we clear the payments
so I go to January cash
cash
then like 8500
this is 8500
and this is 8 500.
and let's say this is too dirty
to that thing
for 50 or 50.
500 500.
that's what we have
so we go to payments
table here
and try to see uh they which are only
say we have succeeded when the P ID is
lubricated here otherwise still we
haven't succeeded in that
so let's check January
here on Lost Focus
let me paste that one
that was the remaining part February
on Rust Focus
paste that one
save
then you have much
Focus test
see you
then we go to April the trust Focus
paste and Save we go to main
the trust focus on Lost Focus paste I
think that was the the remaining part
so we save then just go to this and
clear data you need to create a data
here
you clear that
so
we run this one
you start with January and see you want
to make sure that our system is working
it is giving data to the parent to the
child table otherwise
the system will not be functional
that way so this is cash
cash
that's what we have so here we go to
payment and check there we are you see
now it's working you see for this first
guy here the ID number has been
lubricated this ID number has been
duplicated uh to this one so it is now
functioning that the ID numbers when you
go to the second person or that person
the ID numbers should be duplicated here
so the the record you will be saved the
permanently for that point so you just
go to home and refresh this one then
also go back to our coding and make sure
that everything is intact so we go to
we go to the other months right we have
June
we do the same to June
that is for June
lost Focus
we do the same
you do the same for all the months
children are lost
in the same make sure they equate the
Equator the fields are
done
definitely
then we have October
I'm pasting the equation then I just go
to November
and quit
go to December
also equate that way
so after doing that one your data will
be when you you run your data
when you run your data I can offer this
guy here you see for this guy it is
permanently there since the data has
been captured and duplicated to the
other one then the next thing is to show
you how to create the receipt so further
receipt you need to
to create a report so I can close this
one go to create then I just go to
report
design then you can just make this one
something up to that point save it as
receipts
then once you do that
you can create
like now I can duplicate this one copy
paste then I call it receipt
then for the receipt here
I need to do something so I go to the
receipt I use the ID number here so I go
to criteria and then type forms
exclamation mark
data entry exclamation mark I take the
field I want the field I want is ID
so I scroll until I get the ID
that is the function forms data entry ID
will be reading the ID then I cross I
save that one I close it
then I use that receipt query to be the
source resource for the report so I go
to properties sorry I go to design
properties
sun should have been designed View
so I go to properties I go to
or
then I scroll upwards record Source
should be received save so that I can
see all the feeds I want so I just go to
design go to it add existing list so
from here I can now drag and drop the
things I want I need
I need ID number there
and the ID number somewhere this Design
This one is received
seat
receipt receipt
is it then how much you do
you do format
that is my receipt so this is the ID
number then I need the customer name to
be somewhere there
customer name
then
Group by
customer name
actually group them by customer name
that way then from there you can now
include the fields you want right now I
want this generally to December so I
bring them here January to December
that way
this is January to December
right for example let's let's work with
that one
you can modify your receipt as you want
so this is my receipt
save
okay it may not run since I have fill it
so this is how it will look like you can
add water you can add electricity here
for example
someone else might come and add water
like now you want to add water
you hold shift
to bring you bring the waters here
then remove this
see now I need to remove the rainbows
this one
you need to remove those ones
so I bring the waters here
to sorry
bring the water here
then this is for December
so you can make sure the
October November
this is almost November it's for October
for September
for August
July
June
May April
match
February
like that so later on here you'll add
the missing ones like for example I
can't see what I want later on we shall
added or you just go to research
here make sure that water one is
available
just add it
then when you come here it will be
impossible to be water one is here
so we remove this one and then bring
water and for January
so for the electricity you do the same
so if I run you notice that um
my receipt my receipt is
my receipt is uh
uh will it be here so to display it you
need to go to this field here go to
design view go to this button here this
button then go to property sheet of it
properties then go to event on click you
click the three dots go to macro Builder
go to ok then type open report open
report then choose the report the report
is
here the report is received
there you are then save so after doing
that one if now I run this one when I
run this one go to January for this guy
here when I click on him
then click receipt
there we I see it should reproduce the
receipt for Adam Kids Adam cards only
because the last guy here I see this guy
is Adam Adams so if I go to John Peter
click on his field I see it today b00
John Peters
ID number to be taken and the rest but
uh you'll notice that
data is not being duplicated but you see
now here the the system is working let
me just try to feed more
like if I go home and refresh there is
nothing nobody with any amount so I go
cash cash I go cash
then once I do that I go to
I'm in January I go to John Peter let me
say John Peter has paid 4500
that is the amount of electricity then
this one is 5400 so this is 85 850 solid
8050
this one is 4500 this is 540 this is
450. so uh here you simply you'll see
that um
uh these two guys have been captured
so if I go to this point right now I got
to the first guy here
this one
if I go to this guy
here then click on view receipt you see
the receipt is included now the auto
build here for January for 20 because
now the receipt is working so what you
need to do is to just modify your
receipt uh to be somehow decent and that
one you can just take your time to do
that so design go to properties go to or
um
then we need to back style here should
be transparent so that we remove those
lines not yet so back go to
about the stair transparent
so that you move those lines yeah there
we are guys you see now I have removed
those Trails so in if I add electricity
for this guy design
then go to design add existing then
bring electricity
you have to replace it over here
remove the ribose
remove the rainbows and delete to them
so if I bring the electricity
somehow closer to that
then go to design property sheet remove
the back style to transparent
ly you'll notice that
this guy January rent is this this one
and this is the electricity so you can
still modify that one to recognize and
better then we have
we have the
click the Discord this code is for
cross button you can copy it I paste it
in the description so this is
real
estate
row
so I copy this code here I copy this
copy
then I cross this I want to have the
cross button functioning so I just go to
this point cross button then go to event
then on click event procedure click the
three dots paste the code so this code
this code of mine is for
copy this code again
go to this one
we undo paste it there then change this
part here to real estate
Pro
make that so you can have this code from
my description or you can download copy
of this database from my website and
take all the codes for free so when I
come to this point to see what happens
it is a real estate Pro confirm with
exit now I am retained there
common families it it goes so you can
see the system is
actually functioning well so for that
case in case you want to delete a record
you just press delete from this black
button here then you'll be a question to
see that so from here you can see now
that button is fine then we can code for
this show ribbon and the next the sister
casin or the casting so I just go to
show ribbon right click go to properties
go to event on click what happens so I
go to this point that do CMD dot show
pre brochure
let me just if you don't show Turbo
the turban is ribbon
sorry bone
should not be shown that is a sure
ribbon yes so I called
the ribbon
so I just copy this part of the code and
change yes to no so this is for showing
ribbon so for hide ribbon just go to
event process the three dots paste but
change yes to no
Where We Are so I cross fire home so
surely bone hide ribbon you see ribbon
is hidden surely born reborn is shown uh
confirmed uh this one this goes
on the other hand since I rocked this
one here I rocked this one I need to
have a phone that should be used to feed
the primary data of the tenant so we got
to design The View create we go to
create
from Wizard
I need to create customer ID
I needed to create
date exit listen has number of determine
condition is
three month hospitals category these
ones
and if you have all this data
those ones up to that point so
I then go to next
finish so it will populate for me a
report and a form sorry now this is my
phone
so this is my customers form
of this one this is the one that I'll be
used to capture
this is
tenants tenants
it is capture form so in this form of
mine
I capture the data that should be
displayed in the dashboard so that one
should be done now this is whatever I
have this is my data format
it to be word so that it can be readable
so this is my form
now when I capture
somebody here
and capture even the documents this is
the documents I need then once once I
close this form it should automatically
open this
so here I just need first of all to I
can close this this is the data capture
so I can add a button here go to design
add a button so I'll add a Togo button
that add
tenants
this is my Togo button add channels
it is reading
White
then this one should be 16. so add 10
minutes
then this button I need to copy
something about it properties go to
event on quick event hit the three dots
then what you say here is that 2 CMD
to do CMD dot cross dot cross whenever
you up you click that button it crosses
itself then do CMD
CMD open
touch
open from which form should be opened
data entry sorry
let me just confirm the name of the form
the form is data
just take this copy
you know to remember the sparing paste
so the system will automatically cross
itself and open to that code that one so
I close that
so I save that so you see you see what's
happening it crosses itself and opens
this so the same should happen here when
I cross this one it should cross itself
and open the dashboard so I just put the
button here across
across from you see cross one so this
button when I click on it it will cross
itself it will close itself and
for that juncture open the the dashboard
so we go to coding on click
what happens so blue CMD dot cross
it crosses itself to CMD Dot
Dot
open from which form
it should open data entry data
entry form see that's how that one is
Switched so when I close
you see when I actually click this one
they keep on Switching you see they keep
on Switching that is a very intelligent
way of coding so I got to add tenants I
click I need to put
buttons for adding new here so design
you can draw the button then I go to
record operations add new and then you
have ADD record next
finish so you have this button for add
new
you can change it to that way
so when I when I
save and run add new
there is a bit of functionality not
working
so whenever I add somebody from this
part here whenever I add somebody from
this part this part here
this part I never had somebody from I
don't save whenever I had somebody from
this part here
should be in a position to let me just
cross this one first of all cross
yes let's see
I cross this one then I'll reopen it
again let's see what happens
so I go to data entry
they're not active so let me just open
access
2021 we see whether it will work so we
open that one we go to
entry
so probably
my access is not really functioning on
that but uh what happens when you click
on add new button here and add somebody
here when you add somebody here you'll
be in a position to to get him or her
added here
so in case you want to create something
like the now the statement you just
populate the
you just populate a report from that is
from
other wizard like now I can just go to
report wizard you can just come to this
and populate whatever you want right now
I need to have the payments so you can
just come to this point have the ID
and first of all you can have the serial
number then the ID then now you can have
January February March April this all
month
like that till next next next
then here tabira next then finish you
can have you see now you'll have to
populate something there but now in this
time now you can just make it around
this game to make sure you see or later
on you can just go to design view and
opt to
bring this one to reduce the size right
now you can remove this
see now these sizes are so big
so you just need to do something like
I'm just doing just reduce the size
you should just reduce the size of this
stuff
so that you can have a good
looking statement
you see now you'll have a good looking
statement
for that case
then bring the others
today to December
just pull them
towards this end
so now
then from there probably you'll be in
position to view you see now it's
working so you can be in a position to
come up with a very good a very nice uh
very nice
statement just from here
like that so you just need to bring
these ones closer to each other to make
sure that you save on space and it
defeats on an A4
paper
otherwise you'll need you will need
other other forms of papers
that is over sizes of the papers to
print you see now what I'm doing so from
here I can be in a position to view and
have my report in an A4 page so guys uh
thank you very much for watching
Remember to subscribe you can also copy
or download
this system but basically I will provide
this one this one this one was just to
show you how that one is done so
probably I Avail this one I will Avail
this one for you this is what I reveal
for you this one I will Avail this one
for you so that you can copy the you can
just export the splash form and the
login screen for that case so like
now this one here you just need to this
is the the version that is uh actually
more than whatever I have done
this one so this one is whatever I was
telling you
that you can just copy this there is
nothing hidden so you just need to have
this system from my website and then you
can have the codes you can also use it
for practice the only difference with
whatever I have taken you through is
that that one was really coaching but
this one is a complete system that I
took a lot of time to to really work on
it so guys thank you very much for
watching again and don't forget to
subscribe thank you very much
