hello i'm ok taxes 2013 tutorials
this video is gonna be the first in a series videos discussing continues forms
and we're gonna be using continuous forms where he continues form in a very
specific way
to do a very specific saying for us
in this database so edition of a long follow that blood video to them a
section website and on the Texas 2013 DB 55
and then not in 2013
take password is password
sure you can read Chris what we actually trying to do
that we're gonna need continuous forms for well as you can see
we've got I'll wherein process and making
a database or hotel and we're locking bookings
and if we'd looked she takes pic for can I deal at number nine we can see that
one single booking contains
a multiple rooms so for example booking ID number nine
room 502 I am
was someone checked in on the 30th July and checked out the 25 August
a.m. and is actually two other rooms so say to that
booking wanna do is we want to create
form where we couldn't see
wherever a room is books a specific day
however it isn't but said be a essentially visual representation of the
data
I'm going to be using continuous forms to achieve that
so what we're gonna to in this tutorial
is just gonna create the a very a basic continues for mitch is gonna
contain information about basically each individual room ima gonna
in the future tutorials work from there so
close to the first things first we've got
a query for rooms which is grooms or sending
which is fine takes a rich
we only want to be displaying active rooms
compromise inactive for maintenance reasons so this is
almost a free one so gonna keep my life simple we're going to Kona
actually is checked for a number type question is: fight so we're gonna
click on a control C control face was gonna copier
how gonna call it query rooms
a.m. active scored firms active
easy as pie right and then we're gonna click
on a continuous form now we're continues for more do for clicking clear objective
is actually display every single record
flowing down the page I'm not
in a sense dissimilar to date sheet but you conduct does a lot more
functionality
you can use it for and ralph let me try and explain everything ok just
show you the videos go on so click on clearance active go to create a
anklet call more swarms and
multiple items Texas display multiple items
makeup smaller so as you can see stake in exactly the same information here
basis displayed it animal so traditional form
way sonnets clueless should Sheila
I'm and begin
to he's we r
going to his way gets really good if you
dropped into design view is actually only one
rose information which is the detail section is just
generate at most four times depending on how many records terror
the facts love you which is to confirm it.
range click on Insert below so we can actually
widan share little bit and twosome
interesting stuff down the line as an actress said to the bishop
before we do that let us had some bonds to the top
as a concert in August horizontal split horizontal
to just gonna make
for bonds here so design and just have fun
Ste cancel cancel yet we're gonna cancel that one as well
guess we're gonna do this you can select got F's for
Banco to format and picture
we warn G go to
first this farm
picture we will go to
previous I think or lost
no not lost seasonal go to previous then
there's there it was thirties
this only one go to next
stencils go to last okay I love the song gonna do is gonna make much sense in
this particular video
just bear with me I am but gonna be using these bonds to click through
dates again what dates meaning that new dates so
because I just have to bear with me
to to
to Scotians
now we're going to do is scan had a spitzer
scan had a text books
she's gonna be star today
Ambleside had a text books
there
she's going to be and day and thus make this
lots more
practice law in action
doesn't speak for his wife
passes I okay
%ah so that's a top lines are going to be using
these to give us some or Rangers dates and
start date to the end date we're gonna be using the Cisco free today
X and what we want to do down here
well we're going to I am for Swiss men's room I D down
moving on room number
in there going on tie
in there so moving these labels down into the actual
detail section anything even a detail section or repeat
so for example cost per night at the moment is in the
had two sections that is a new one and a fun movie down here
i gather notes frankly we could get rid of am cashing service
active SLE convertible with that garbage k click on tight
go range insert left click on course tonight
concert left and
cost tonight change it charge
yeah K and
mmm work on those process for
Brougham border-style: transparent
a.m. 2001 by accident gonna
but on this hot links for 12 your to leave the label for a mighty in and
smooth firm idea
here split horizontal
spawned us and just make room
ID visible night
okay say we've done basically what we wanted to do to save time called up
commercial charged
okay so we don't want to do for this video
and on Lost thing
which 1.5 okay so we've got
continues form we wanted now many to do the slightly more difficult thing is
we're gonna
at I'm rather's text boxes up here for Leafs
15 to 20 but nada rose text boxes here
and we're gonna be reading information from the bookings
I'm gonna be looking up whether for example particular day which had been
his text books
and a particular room number form part for booking and if they
do will be writing the name for gestational
will be blank its so then we'll stop to get that concept
visual representation of data everything we're gonna do
is we're going to get it so that we can click on of a single double twin
and also to the form so if you become single to show the single rooms
and and river numbers will also get it if you click on
room number will filter the form by the floor now the floor is determined by the
star room number so
to second floor 30 third floor forceful slow
such such a standard hotel fair okay
that sold in future videos so this is just a the basic conception of the
Sharjah
a.m. and thank you watchin see you can actually a