a lot of taxes 2013 shoot or ooze
this video is a continuation all
the shades form making
a.m. and going to be showing you how you going to have to click on
text books and open up a.m.
related looking I Russia 30
so come back says 20 searching DB 61
which is a huge right
and sure where you can go to them a section website
and download this database
follow the link below the video okie dokies
I'm interested in this we are interested however in storm
shoulda and as you can see
scroll to the bottom where the actual conditions for matching works
ministry dozen given the game later
okay yet where the conditional formatting works to rezone
here we're gonna be reduced click on the name this
existing same room 502 on the 17 October
j'mens 9 a.m. we want to bring up the related booking
and if you click in a square doesn't have
a booking I would like to open up
the I am same form
in data entry much region had a record works like this
welcome jameson ok James merchant who happens to be in three different rooms
the same time debts
his wasn't paying much attention to the data
but I'm gonna okay %uh so
past that and then shark in a square
awareness no person staying
we get this bookings for Mike not so how do we
due to actually mister the design do this to one of those things
even due to us become negative range select Road
and missus
change but I just go to is hutch
link display cycling always
as like the most
incredible changed makes a database issue to light
the nice hanting okay so how do we do that strip
to their square vents on this list
macro based even okay
and his how it works I am person when each do
is find out what looking ID's so we September variable
temp looking I T and then this is where we use a deal Cup function
arkansan do market since
and the Diva Cup function is looking up
booking ID in query bookings explode
where the room I G equals a mighty so
that would depend on the particular recorder in and the day
will be temp stopped a plus
in this case is 0 kisses first rose records
com records I should say the second column
will be sub-zero one just
news
J so show usually it does very specifically
looks of here the
necessary dates in here so
bases in LNG day say look up to date resume for sure
1563 lookup room I T
which is here and she finds it
return the key ID I'll let you ever play around
booking left dude
function and next column we have to sing sing
we have one so once actually found the booking
ok so obviously I should mention
yeah we're looking at the booking if he doesn't find the fucking
we I like seeing an old value back we don't really like to do in nobody's
so views the ends at function and then dysfunction works to
whenever you put in the first part which is the dealer cops are returns now you
get to determine
new value shot decided return -1
so dished embossed him back in ninety straighten 0
which means its return to action booking ID not -1
open up for bookings data entry in
user simple where conditions go to the random bookings otherwise we're gonna
saying form but it's going to be in admired okay so that's the general idea
a.m. definitely download image take a look at it
this particular function make sure you understand how this works
and to United
so free to change around break it you can always redownload database
tissue can get it amazing things a.m. denouncing
pot make for me muscle at nine tonga
by then everything worth mentioning is pie using
see long past
day speakers she goes very diffuse slow
I tend to not like to do wish
format it takes an access I find it causes too many problems
because a not so much here is really a good record him if for example the fifty
should attend
2013 skidded shifting October that read
the 10th the night fish the 10th 2013
actually tends to interpret that as
Saturday night October the 10 for September
so why do is I like to use the actual stored value today
which is a long integer here so full 1 562 is how
access stores stay a.m.
and wishes essentially for much version updates
that's why was conveyed long into jazz and use that
okay sis the video nothing major there
but we marching towards finish in this form is almost complete an
next video gonna be try to utilize these buttons to manipulate
the dates thanks thank you for watching a senior next year