1
00:00:00,719 --> 00:00:03,310
hello of taxes 2013 tutorials

2
00:00:03,310 --> 00:00:06,939
initially only showing you how you can open up reports dynamically using

3
00:00:06,940 --> 00:00:10,900
navigation forms social play-along follow the link below the video to the

4
00:00:10,900 --> 00:00:13,500
intersection website and access 2013

5
00:00:13,500 --> 00:00:18,670
the beach 24 ok

6
00:00:18,670 --> 00:00:23,000
so in the last video betrayed a summary report

7
00:00:23,000 --> 00:00:26,140
which is Donna Summer

8
00:00:26,140 --> 00:00:30,820
ansel guess summary

9
00:00:30,820 --> 00:00:34,710
the issue we've got the moment is to actually good for main

10
00:00:34,710 --> 00:00:38,520
I'm gonna reports because she's guests

11
00:00:38,520 --> 00:00:42,040
I'm by the problem got his too

12
00:00:42,039 --> 00:00:45,289
we've got more than one guess report locust activity in guess summary

13
00:00:45,289 --> 00:00:49,189
to overdo it onto a combo box he Iran able

14
00:00:49,189 --> 00:00:55,058
to change the combo box it will change the actual report the recent hit simple

15
00:00:55,058 --> 00:00:56,479
right well

16
00:00:56,479 --> 00:01:00,218
must-see is con simple who is about protease

17
00:01:00,219 --> 00:01:03,239
okay so let's get honest tougher sinks

18
00:01:03,238 --> 00:01:06,319
were there we can eat is units create table which were gonna call table

19
00:01:06,319 --> 00:01:08,329
reports on weekly uses table

20
00:01:08,329 --> 00:01:11,429
as the row source for the combo box

21
00:01:11,430 --> 00:01:16,650
create a table design and

22
00:01:16,650 --> 00:01:20,200
we will the first so we're gonna need is going to be

23
00:01:20,200 --> 00:01:24,810
report name and this is where we're actually going to store the actual names

24
00:01:24,810 --> 00:01:25,868
to report so

25
00:01:25,868 --> 00:01:30,438
here which store for example forecasts activity report summary

26
00:01:30,438 --> 00:01:34,469
I am where thing gonna need the

27
00:01:34,469 --> 00:01:37,640
so that's a name for the report we need T

28
00:01:37,640 --> 00:01:43,460
so you can call caption which is a name that we're gonna show you too

29
00:01:43,459 --> 00:01:46,609
the a.m. user and

30
00:01:46,609 --> 00:01:49,929
last thing we're going to need group

31
00:01:49,930 --> 00:01:55,689
so we can not just have this suggestion for speaking to a group for example for

32
00:01:55,688 --> 00:02:00,709
I'm rooms for bookings essential missile become clear soon enough

33
00:02:00,709 --> 00:02:04,868
we turn read any

34
00:02:04,868 --> 00:02:10,459
shoe store as a primary key tell me stories from issues

35
00:02:10,459 --> 00:02:17,459
this weekend look blacked out from over there goes the overseas imagining things

36
00:02:18,060 --> 00:02:19,199
okay see Table

37
00:02:19,199 --> 00:02:22,979
reports

38
00:02:22,979 --> 00:02:29,979
does it known my staff houses are provided the table tonight look like I

39
00:02:31,639 --> 00:02:32,238
was able

40
00:02:32,239 --> 00:02:37,569
just get rid of table for she started on a scooter stable reports

41
00:02:37,568 --> 00:02:42,128
okay my site skirted the issue

42
00:02:42,128 --> 00:02:46,719
a case if report name Asha report cast activity

43
00:02:46,719 --> 00:02:51,310
caption

44
00:02:51,310 --> 00:02:54,568
bees cast

45
00:02:54,568 --> 00:02:59,609
act tutsi likes it is connected to see

46
00:02:59,610 --> 00:03:04,769
and groups will be one I'm

47
00:03:04,769 --> 00:03:08,209
and next only one his report cast summary:

48
00:03:08,209 --> 00:03:13,289
which corresponds summary

49
00:03:13,289 --> 00:03:19,090
and one so the group one will refer to any guests reports

50
00:03:19,090 --> 00:03:23,310
so safe to close to I'm

51
00:03:23,310 --> 00:03:27,098
and we will open up

52
00:03:27,098 --> 00:03:30,098
you know if not gonna open up case reports

53
00:03:30,098 --> 00:03:37,098
44 tests this one so gonna drop comic books in here

54
00:03:39,650 --> 00:03:43,159
units today I am

55
00:03:43,159 --> 00:03:47,960
mostly

56
00:03:47,960 --> 00:03:54,960
suffered

57
00:03:58,860 --> 00:04:05,160
something like this cyst Saunders reformer and

58
00:04:05,159 --> 00:04:10,340
changes some other sizes the boxes in the empty shelves like a cigar cutter

59
00:04:10,340 --> 00:04:10,950
design

60
00:04:10,949 --> 00:04:15,339
have a comic books instruct and

61
00:04:15,340 --> 00:04:20,209
tokamak change its report click on the comic books for civ 4

62
00:04:20,209 --> 00:04:25,230
and change it to you see dealer for okay

63
00:04:25,230 --> 00:04:28,569
so with this comic books be wrong to

64
00:04:28,569 --> 00:04:32,519
store the name of the report but we want to show you

65
00:04:32,519 --> 00:04:36,579
the caption corrupt table reports

66
00:04:36,579 --> 00:04:40,479
who wants to love this but we want to show you this

67
00:04:40,480 --> 00:04:44,240
to some we do a lot calmer boxes gonna data

68
00:04:44,240 --> 00:04:47,689
to Rosso's click on the alexis

69
00:04:47,689 --> 00:04:52,279
and to contain reports

70
00:04:52,279 --> 00:04:55,729
so you can store this search for those first column

71
00:04:55,730 --> 00:04:59,169
on the show this I am on

72
00:04:59,168 --> 00:05:02,240
to remix sorted

73
00:05:02,240 --> 00:05:05,569
reports so to run at the moment really wanna show

74
00:05:05,569 --> 00:05:09,800
reports number one so the criteria number one

75
00:05:09,800 --> 00:05:13,040
from a change to to troops runner

76
00:05:13,040 --> 00:05:16,270
we get stir which is good

77
00:05:16,269 --> 00:05:21,789
and from mars saudis and save

78
00:05:21,790 --> 00:05:25,160
close to he got format concha

79
00:05:25,160 --> 00:05:29,910
to 0 for nah forget a form to you

80
00:05:29,910 --> 00:05:34,840
see we've got activity or someone who actually click on one

81
00:05:34,839 --> 00:05:39,529
what a combo box stories report guest activity in for click on this one is

82
00:05:39,529 --> 00:05:40,500
actually storing

83
00:05:40,500 --> 00:05:44,899
report guess summary I can prove to

84
00:05:44,899 --> 00:05:48,000
by change in the congress

85
00:05:48,000 --> 00:05:51,439
summit like to into so you can see

86
00:05:51,439 --> 00:05:54,680
when you click here

87
00:05:54,680 --> 00:05:58,090
you got two columns and store in the first column

88
00:05:58,089 --> 00:06:01,379
bar I wanna see the first column site

89
00:06:01,379 --> 00:06:05,439
hide it my c0 and four stand kinda stuff

90
00:06:05,439 --> 00:06:10,060
okay the next thing you want to show me update the combo box

91
00:06:10,060 --> 00:06:13,478
you want to actually change what's in here so

92
00:06:13,478 --> 00:06:17,659
you ready can do that through the update on circling update on pressure forming a

93
00:06:17,660 --> 00:06:18,400
rope that

94
00:06:18,399 --> 00:06:25,399
macro requires

95
00:06:25,879 --> 00:06:30,098
tackle such issues touched off a temp

96
00:06:30,098 --> 00:06:33,930
sorry don't parts are now is a mistake

97
00:06:33,930 --> 00:06:37,530
okay then Tokyo she

98
00:06:37,529 --> 00:06:40,639
so what do we need to Newnan of the writer

99
00:06:40,639 --> 00:06:44,310
browse to action which is gonna be bit of pain

100
00:06:44,310 --> 00:06:47,680
she

101
00:06:47,680 --> 00:06:52,288
me full organist do

102
00:06:52,288 --> 00:06:55,879
make a browse to action is so we got four main

103
00:06:55,879 --> 00:07:02,139
followed by form reports

104
00:07:02,139 --> 00:07:06,019
she's not

105
00:07:06,019 --> 00:07:09,089
followed by former for

106
00:07:09,089 --> 00:07:13,000
guests and then this here honkala

107
00:07:13,000 --> 00:07:17,810
alright serves give a coach side clinical after update

108
00:07:17,810 --> 00:07:22,439
create a macro and three simple were gonna say

109
00:07:22,439 --> 00:07:26,719
browse to okay so you jobs tops for the name

110
00:07:26,720 --> 00:07:33,050
gonna equal CVR force lives in CV a report that's what we want to show some

111
00:07:33,050 --> 00:07:33,750
point

112
00:07:33,750 --> 00:07:37,038
Joe the exercise and the way condition

113
00:07:37,038 --> 00:07:40,228
soap of the subform control is tricky yes

114
00:07:40,228 --> 00:07:45,860
form mine she

115
00:07:45,860 --> 00:07:51,000
cation sub form right arrow

116
00:07:51,000 --> 00:07:54,579
form ports

117
00:07:54,579 --> 00:07:57,740
20 t'as right arrow

118
00:07:57,740 --> 00:08:02,360
former for guest Singh

119
00:08:02,360 --> 00:08:08,310
talk TS

120
00:08:08,310 --> 00:08:11,360
asking

121
00:08:11,360 --> 00:08:15,850
some as his former for guests on this one thing

122
00:08:15,850 --> 00:08:20,889
strong former forecasts

123
00:08:20,889 --> 00:08:24,329
and this is called DS I hope it is

124
00:08:24,329 --> 00:08:29,269
favorite form reports make sure this is cool

125
00:08:29,269 --> 00:08:36,269
DS as well it is a test RYA see go for main

126
00:08:37,120 --> 00:08:40,198
reports casts

127
00:08:40,198 --> 00:08:47,198
and then I work to owner

128
00:08:49,100 --> 00:08:56,100
fantastic form

129
00:08:57,089 --> 00:09:03,880
forecast straight up way

130
00:09:03,879 --> 00:09:06,879
if I miss something in the macro

131
00:09:06,879 --> 00:09:12,429
house to form object name CVR for

132
00:09:12,429 --> 00:09:15,859
seeger for uses

133
00:09:15,860 --> 00:09:21,060
for may not know you harness change object name is just pick

134
00:09:21,059 --> 00:09:24,629
summary

135
00:09:24,629 --> 00:09:28,679
out a ridiculous thing I've done a

136
00:09:28,679 --> 00:09:31,899
Ste should be allowed out as a reform

137
00:09:31,899 --> 00:09:35,078
Navigant not

138
00:09:35,078 --> 00:09:42,078
a case report

139
00:09:43,559 --> 00:09:47,269
tonight from 4-9 on on true using the Floyd for

140
00:09:47,269 --> 00:09:50,319
object of his report the name he could see video

141
00:09:50,320 --> 00:09:53,379
but for saving close

142
00:09:53,379 --> 00:10:00,379
okay side close on this trial that total brain 3.size:

143
00:10:01,899 --> 00:10:08,899
hey worked haha exhausted me as I K

144
00:10:10,259 --> 00:10:13,720
so Todd Myers

145
00:10:13,720 --> 00:10:17,310
what we do former pool

146
00:10:17,309 --> 00:10:21,769
guests free trade the comment box to remember very important restoring the

147
00:10:21,769 --> 00:10:22,409
name

148
00:10:22,409 --> 00:10:26,409
actual name the report I'm showing a caption associated with it

149
00:10:26,409 --> 00:10:29,409
return ven on the

150
00:10:29,409 --> 00:10:32,600
comment box as a browse to then

151
00:10:32,600 --> 00:10:36,070
and we're telling the

152
00:10:36,070 --> 00:10:40,200
fourth in excess of to be update this combo box we want to change the report

153
00:10:40,200 --> 00:10:41,020
in here

154
00:10:41,019 --> 00:10:44,799
yeah by said a bit more complicated than that

155
00:10:44,799 --> 00:10:50,419
for because preseason navigation for Nikon to say i watch for a change to

156
00:10:50,419 --> 00:10:51,149
report in

157
00:10:51,149 --> 00:10:56,590
former poor guess just actually provide the hope of to the subform control

158
00:10:56,590 --> 00:11:01,500
and the very out a form is cool for mine which is this one

159
00:11:01,500 --> 00:11:04,889
and so we say four main

160
00:11:04,889 --> 00:11:08,769
navigation some form so we start I started the name in the first for the

161
00:11:08,769 --> 00:11:10,169
navigation subform

162
00:11:10,169 --> 00:11:14,209
I'm and forget reports just

163
00:11:14,210 --> 00:11:17,259
for former Chisholm division to sub for map

164
00:11:17,259 --> 00:11:20,490
forms before reporters for my navigation subform

165
00:11:20,490 --> 00:11:25,850
dole former forts not for main

166
00:11:25,850 --> 00:11:29,970
top navigation subform right arrow form report doctor yes because that's the

167
00:11:29,970 --> 00:11:33,940
subform control here in a move in now we end up placing

168
00:11:33,940 --> 00:11:38,130
former force guess is quite complicated browse to subjects one

169
00:11:38,129 --> 00:11:41,710
to see three forms for all skin to browse to and two containers

170
00:11:41,710 --> 00:11:45,920
I did a little thing earlier on navigation

171
00:11:45,919 --> 00:11:50,439
forms I'm not sure which video fish go back as you can check that one out

172
00:11:50,440 --> 00:11:54,100
to give you an idea and that's how you update dynamically

173
00:11:54,100 --> 00:11:57,889
and as you add reports you just add them to use the

174
00:11:57,889 --> 00:12:00,990
table reports

175
00:12:00,990 --> 00:12:06,360
toxic group one is for guests in and if you want to add

176
00:12:06,360 --> 00:12:09,669
reports rooms be something reform room activity

177
00:12:09,669 --> 00:12:14,860
caption activity crew to so use you're able to shoot down with common boxes

178
00:12:14,860 --> 00:12:19,379
okay a.m. that's it that's video okay thanks for tonight

179
00:12:19,379 --> 00:12:22,659
and happening confuse you too much closer to confuse myself

180
00:12:22,659 --> 00:12:24,029
and I'll see you next video