hello of taxes 2013 tutorials
initially only showing you how you can open up reports dynamically using
navigation forms social play-along follow the link below the video to the
intersection website and access 2013
the beach 24 ok
so in the last video betrayed a summary report
which is Donna Summer
ansel guess summary
the issue we've got the moment is to actually good for main
I'm gonna reports because she's guests
I'm by the problem got his too
we've got more than one guess report locust activity in guess summary
to overdo it onto a combo box he Iran able
to change the combo box it will change the actual report the recent hit simple
right well
must-see is con simple who is about protease
okay so let's get honest tougher sinks
were there we can eat is units create table which were gonna call table
reports on weekly uses table
as the row source for the combo box
create a table design and
we will the first so we're gonna need is going to be
report name and this is where we're actually going to store the actual names
to report so
here which store for example forecasts activity report summary
I am where thing gonna need the
so that's a name for the report we need T
so you can call caption which is a name that we're gonna show you too
the a.m. user and
last thing we're going to need group
so we can not just have this suggestion for speaking to a group for example for
I'm rooms for bookings essential missile become clear soon enough
we turn read any
shoe store as a primary key tell me stories from issues
this weekend look blacked out from over there goes the overseas imagining things
okay see Table
reports
does it known my staff houses are provided the table tonight look like I
was able
just get rid of table for she started on a scooter stable reports
okay my site skirted the issue
a case if report name Asha report cast activity
caption
bees cast
act tutsi likes it is connected to see
and groups will be one I'm
and next only one his report cast summary:
which corresponds summary
and one so the group one will refer to any guests reports
so safe to close to I'm
and we will open up
you know if not gonna open up case reports
44 tests this one so gonna drop comic books in here
units today I am
mostly
suffered
something like this cyst Saunders reformer and
changes some other sizes the boxes in the empty shelves like a cigar cutter
design
have a comic books instruct and
tokamak change its report click on the comic books for civ 4
and change it to you see dealer for okay
so with this comic books be wrong to
store the name of the report but we want to show you
the caption corrupt table reports
who wants to love this but we want to show you this
to some we do a lot calmer boxes gonna data
to Rosso's click on the alexis
and to contain reports
so you can store this search for those first column
on the show this I am on
to remix sorted
reports so to run at the moment really wanna show
reports number one so the criteria number one
from a change to to troops runner
we get stir which is good
and from mars saudis and save
close to he got format concha
to 0 for nah forget a form to you
see we've got activity or someone who actually click on one
what a combo box stories report guest activity in for click on this one is
actually storing
report guess summary I can prove to
by change in the congress
summit like to into so you can see
when you click here
you got two columns and store in the first column
bar I wanna see the first column site
hide it my c0 and four stand kinda stuff
okay the next thing you want to show me update the combo box
you want to actually change what's in here so
you ready can do that through the update on circling update on pressure forming a
rope that
macro requires
tackle such issues touched off a temp
sorry don't parts are now is a mistake
okay then Tokyo she
so what do we need to Newnan of the writer
browse to action which is gonna be bit of pain
she
me full organist do
make a browse to action is so we got four main
followed by form reports
she's not
followed by former for
guests and then this here honkala
alright serves give a coach side clinical after update
create a macro and three simple were gonna say
browse to okay so you jobs tops for the name
gonna equal CVR force lives in CV a report that's what we want to show some
point
Joe the exercise and the way condition
soap of the subform control is tricky yes
form mine she
cation sub form right arrow
form ports
20 t'as right arrow
former for guest Singh
talk TS
asking
some as his former for guests on this one thing
strong former forecasts
and this is called DS I hope it is
favorite form reports make sure this is cool
DS as well it is a test RYA see go for main
reports casts
and then I work to owner
fantastic form
forecast straight up way
if I miss something in the macro
house to form object name CVR for
seeger for uses
for may not know you harness change object name is just pick
summary
out a ridiculous thing I've done a
Ste should be allowed out as a reform
Navigant not
a case report
tonight from 4-9 on on true using the Floyd for
object of his report the name he could see video
but for saving close
okay side close on this trial that total brain 3.size:
hey worked haha exhausted me as I K
so Todd Myers
what we do former pool
guests free trade the comment box to remember very important restoring the
name
actual name the report I'm showing a caption associated with it
return ven on the
comment box as a browse to then
and we're telling the
fourth in excess of to be update this combo box we want to change the report
in here
yeah by said a bit more complicated than that
for because preseason navigation for Nikon to say i watch for a change to
report in
former poor guess just actually provide the hope of to the subform control
and the very out a form is cool for mine which is this one
and so we say four main
navigation some form so we start I started the name in the first for the
navigation subform
I'm and forget reports just
for former Chisholm division to sub for map
forms before reporters for my navigation subform
dole former forts not for main
top navigation subform right arrow form report doctor yes because that's the
subform control here in a move in now we end up placing
former force guess is quite complicated browse to subjects one
to see three forms for all skin to browse to and two containers
I did a little thing earlier on navigation
forms I'm not sure which video fish go back as you can check that one out
to give you an idea and that's how you update dynamically
and as you add reports you just add them to use the
table reports
toxic group one is for guests in and if you want to add
reports rooms be something reform room activity
caption activity crew to so use you're able to shoot down with common boxes
okay a.m. that's it that's video okay thanks for tonight
and happening confuse you too much closer to confuse myself
and I'll see you next video