1
00:00:01,030 --> 00:00:03,370
i'm ok taxes 2013 22 rooms

2
00:00:03,370 --> 00:00:06,950
in this video I'm gonna be talking to you about temp variables

3
00:00:06,950 --> 00:00:10,259
to gonna play along follows the link below the video to down a section

4
00:00:10,259 --> 00:00:12,689
website that axis 2013

5
00:00:12,689 --> 00:00:15,750
TP 21 and

6
00:00:15,750 --> 00:00:19,800
fiction for 2013 herky-jerky

7
00:00:19,800 --> 00:00:23,980
so in the last video more we should done

8
00:00:23,980 --> 00:00:29,278
was recruited a report called report cast activity which listed

9
00:00:29,278 --> 00:00:34,350
guests hand in it listed have any activity that the guest has been

10
00:00:34,350 --> 00:00:38,170
doing so the a.m. looking separate drop dent

11
00:00:38,170 --> 00:00:42,399
print preview that you get a sense so he's got the guest and then

12
00:00:42,399 --> 00:00:46,030
down they've got the information and as you stroll along

13
00:00:46,030 --> 00:00:50,219
test information now wanna do

14
00:00:50,219 --> 00:00:54,530
today's a 10 be able to restrict

15
00:00:54,530 --> 00:00:57,789
the information is shown in that sub full which is

16
00:00:57,789 --> 00:01:01,448
called report booking details by guess up that a moment

17
00:01:01,448 --> 00:01:04,868
everything that's in table booking details coming up

18
00:01:04,868 --> 00:01:10,200
this is based on query booking details extended well when it is on a restricted

19
00:01:10,200 --> 00:01:10,740
a

20
00:01:10,739 --> 00:01:14,170
so I wanna give a date range I want to say to

21
00:01:14,170 --> 00:01:18,680
the query that I am I want all these fields by only more records where

22
00:01:18,680 --> 00:01:21,950
the check in date check out they fall within the state ranks

23
00:01:21,950 --> 00:01:25,689
and today's are going to use Tempe variables so what up to rivals

24
00:01:25,688 --> 00:01:29,508
every variables are very used to store data

25
00:01:29,509 --> 00:01:33,478
and ok locally available to the application so you might have attempted

26
00:01:33,478 --> 00:01:34,359
very vocal

27
00:01:34,359 --> 00:01:37,868
temp start a and yeast or today if the

28
00:01:37,868 --> 00:01:41,519
the first to june 2013 an

29
00:01:41,519 --> 00:01:44,599
if you access temp start a

30
00:01:44,599 --> 00:01:47,899
that information which is cases

31
00:01:47,899 --> 00:01:52,310
for stitching 2013 is available from anywhere in the application seeking

32
00:01:52,310 --> 00:01:52,960
access

33
00:01:52,959 --> 00:01:57,489
that temper variable from a fall from a report from a macro from McQueary and

34
00:01:57,489 --> 00:01:58,519
I'm gonna be using

35
00:01:58,519 --> 00:02:01,899
the ability to access it from a query I'm

36
00:02:01,899 --> 00:02:04,960
staff meeting but temporary pools are you can set them

37
00:02:04,959 --> 00:02:08,299
and removed him wish macros and with the PA

38
00:02:08,300 --> 00:02:12,180
and to set them with a Mac to use a set to be very blog

39
00:02:12,180 --> 00:02:16,110
should be looking at to remove turn this three-way sir move to be very well you

40
00:02:16,110 --> 00:02:16,780
can I for

41
00:02:16,780 --> 00:02:20,810
used to remove temper verbal argument apostle name you can use to remove all

42
00:02:20,810 --> 00:02:22,280
temporary bill arguments

43
00:02:22,280 --> 00:02:25,409
we can close application goal to give those were loosed

44
00:02:25,409 --> 00:02:29,020
at least one specific temporary rule I am

45
00:02:29,020 --> 00:02:33,219
and the max amount to very we can have any

46
00:02:33,219 --> 00:02:37,289
given time is 250 5 I do believe so

47
00:02:37,289 --> 00:02:40,939
run information okay so what are we

48
00:02:40,939 --> 00:02:45,439
gonna do we're gonna this closes for second we've got a report

49
00:02:45,439 --> 00:02:49,300
parties report guest activity let us create

50
00:02:49,300 --> 00:02:54,580
a form I'm gonna call this form report a former for

51
00:02:54,580 --> 00:02:59,280
guests annexed to former going to use to house guest reports

52
00:02:59,280 --> 00:03:02,408
I'm so process Forte probably she

53
00:03:02,408 --> 00:03:06,169
make sure the drop their menus of form got a former

54
00:03:06,169 --> 00:03:09,818
and we want to get rid of record selectors

55
00:03:09,818 --> 00:03:14,049
I'm Russa don't want navigation buttons and we're gonna

56
00:03:14,050 --> 00:03:17,830
at into here couple of combo boxes

57
00:03:17,830 --> 00:03:20,830
the way to use as a start and a

58
00:03:20,830 --> 00:03:27,830
supposed a contract respond startling

59
00:03:30,580 --> 00:03:34,879
clicking here

60
00:03:34,878 --> 00:03:39,009
to arrange cancer right answer right answer right back to design

61
00:03:39,009 --> 00:03:42,209
collect and track can so that

62
00:03:42,209 --> 00:03:45,979
call this one and a

63
00:03:45,979 --> 00:03:52,639
stretches out a little bit a.m.

64
00:03:52,639 --> 00:03:57,289
arrange insert Ryan so right first answer

65
00:03:57,289 --> 00:04:04,289
space and will put a bug cancel that causes

66
00:04:04,739 --> 00:04:11,039
up to okay

67
00:04:11,039 --> 00:04:14,378
I'm gonna name these combo boxes to cook on this one

68
00:04:14,378 --> 00:04:19,129
so cool calm buzzer with a cooler CPO start

69
00:04:19,129 --> 00:04:23,759
day this summer gonna call I guess

70
00:04:23,759 --> 00:04:27,960
she can CDO penned state okay this bar on

71
00:04:27,959 --> 00:04:31,060
we will Cu see in the uptake so we gonna do

72
00:04:31,060 --> 00:04:34,100
is for one other thing sorry took in

73
00:04:34,100 --> 00:04:37,110
this comic books pest control click in this one C can actually set

74
00:04:37,110 --> 00:04:40,490
some properties for them at the same time can save time

75
00:04:40,490 --> 00:04:45,418
transformer to short day

76
00:04:45,418 --> 00:04:49,418
and well let's just say East former college form

77
00:04:49,418 --> 00:04:53,389
I'm tool 4s reports guess report

78
00:04:53,389 --> 00:04:56,400
casts for forecasts

79
00:04:56,399 --> 00:05:02,579
okay so let's pick value

80
00:05:02,579 --> 00:05:07,569
I sort of very city thinks the supposed to be text books in a comic books is

81
00:05:07,569 --> 00:05:09,329
alright so easy fix

82
00:05:09,329 --> 00:05:13,478
click on it right click a.m. change to text books

83
00:05:13,478 --> 00:05:16,909
pregnant right click Change text books

84
00:05:16,910 --> 00:05:23,910
and a.m. sorry stationing to txt and a a txt start they

85
00:05:27,370 --> 00:05:30,889
okay so now if you go to form you able to exceed

86
00:05:30,889 --> 00:05:37,430
choose to take 60 for the social system may actually

87
00:05:37,430 --> 00:05:41,160
and the and me back to levy

88
00:05:41,160 --> 00:05:44,820
tonight is that we set the temp you very false /code superficie

89
00:05:44,819 --> 00:05:48,329
should having clicked a Upoc in detail here

90
00:05:48,329 --> 00:05:52,180
on click marker builder

91
00:05:52,180 --> 00:05:56,120
just tap inset T you get set to be very bold

92
00:05:56,120 --> 00:05:59,410
press Return so name to be variable empty

93
00:05:59,410 --> 00:06:02,419
MP star today

94
00:06:02,418 --> 00:06:05,418
expression equals txt

95
00:06:05,418 --> 00:06:08,709
start a is gonna take the value text art day

96
00:06:08,709 --> 00:06:12,469
missing attribute it to temp start a

97
00:06:12,470 --> 00:06:15,630
I'm set to be very evil TMP and

98
00:06:15,629 --> 00:06:19,659
today and this was gonna be txt

99
00:06:19,660 --> 00:06:23,400
and take for me so far

100
00:06:23,399 --> 00:06:26,409
is a closer now on see me to do

101
00:06:26,410 --> 00:06:30,569
reached to a subform control and who will actually be a sub

102
00:06:30,569 --> 00:06:34,360
report control amps is cookin

103
00:06:34,360 --> 00:06:38,150
anywhere on the sly gotta range insert below

104
00:06:38,149 --> 00:06:41,239
click in anywhere on this new line you try it purchase

105
00:06:41,240 --> 00:06:44,470
answer below once more so kick in bomb one

106
00:06:44,470 --> 00:06:48,610
Co to select Road Praga merch

107
00:06:48,610 --> 00:06:52,479
and 22 whitener

108
00:06:52,478 --> 00:06:56,050
to update split protect so we've got

109
00:06:56,050 --> 00:06:59,509
or y8 ish comic books

110
00:06:59,509 --> 00:07:03,069
because of how I'm recording I don't get the full screen if the them

111
00:07:03,069 --> 00:07:07,949
database a monocular squashed hope you should go to get the full screen

112
00:07:07,949 --> 00:07:11,400
seeming you home why would you be whites-only

113
00:07:11,399 --> 00:07:14,698
what we gonna drop in here a mother to report guess activity in

114
00:07:14,699 --> 00:07:18,788
at the moment because it's not be obvious we've we've she would correctly

115
00:07:18,788 --> 00:07:23,079
Thomasina to he's droppin report booking details

116
00:07:23,079 --> 00:07:26,629
by guest K go to

117
00:07:26,629 --> 00:07:31,490
form to you disco who these bookings now known to restrict it

118
00:07:31,490 --> 00:07:35,139
for remember we're clicking this button for saying that every variable so what

119
00:07:35,139 --> 00:07:36,720
we need to do

120
00:07:36,720 --> 00:07:40,770
is me to go to the query which is creeping details extended

121
00:07:40,769 --> 00:07:44,519
could design view to make any use D

122
00:07:44,519 --> 00:07:47,788
Tempe variables in the criterion talk I just have to think about this what I

123
00:07:47,788 --> 00:07:48,318
want to do

124
00:07:48,319 --> 00:07:52,389
I wanna make sure the any day of the booking

125
00:07:52,389 --> 00:07:56,418
falls within any day of the

126
00:07:56,418 --> 00:08:00,728
for timeperiod say might be the first at the time period is

127
00:08:00,728 --> 00:08:04,598
the lost I have to check out they have a booking us 218 food in that time period

128
00:08:04,598 --> 00:08:08,120
two women to do that so no criteria here

129
00:08:08,120 --> 00:08:11,769
for the list of the check in date so the check in day

130
00:08:11,769 --> 00:08:16,209
is gonna be past gonna need to be less than 0 equal to

131
00:08:16,209 --> 00:08:20,279
temp farce TMP

132
00:08:20,279 --> 00:08:24,989
end date: not start a and a

133
00:08:24,990 --> 00:08:28,598
and the check-out date is gonna need to be

134
00:08:28,598 --> 00:08:35,278
greater than or equal to to empty vase

135
00:08:35,278 --> 00:08:38,559
a to stock today

136
00:08:38,559 --> 00:08:42,619
this ensures from from the sprite check out day

137
00:08:42,620 --> 00:08:46,480
has to be greater than the start take and the check in date

138
00:08:46,480 --> 00:08:51,740
yep that works

139
00:08:51,740 --> 00:08:56,680
on 30 know if that doesn't work sure that works

140
00:08:56,679 --> 00:08:59,859
okay so 3 the idea would be oversee the

141
00:08:59,860 --> 00:09:03,330
to district is down as he stripped the dates more more less and less rose come

142
00:09:03,330 --> 00:09:03,778
up

143
00:09:03,778 --> 00:09:07,759
but almost and i miss u just update the temporary pools

144
00:09:07,759 --> 00:09:11,700
in order to actually I'm get some new information here we have to tow

145
00:09:11,700 --> 00:09:16,970
the underlying query to require review information so as to affect

146
00:09:16,970 --> 00:09:20,139
on click event just here were actually

147
00:09:20,139 --> 00:09:24,129
sorry kicking your subform controls the United

148
00:09:24,129 --> 00:09:30,809
and we never named should be called something like child something

149
00:09:30,809 --> 00:09:34,719
or not a hookah owed

150
00:09:34,720 --> 00:09:38,360
hermano

151
00:09:38,360 --> 00:09:41,379
you know I did something I don't want to do tactic in the

152
00:09:41,379 --> 00:09:45,049
a.m. sub full control

153
00:09:45,049 --> 00:09:48,399
Ste two liter

154
00:09:48,399 --> 00:09:51,929
range insert below same again

155
00:09:51,929 --> 00:09:55,689
terms of my today citro merch

156
00:09:55,690 --> 00:09:59,750
track it down want to add an actual Centro

157
00:09:59,750 --> 00:10:03,909
which is here click on that shop in there

158
00:10:03,909 --> 00:10:10,189
get rid of this leaguer okay and we're gonna make this DS

159
00:10:10,190 --> 00:10:13,560
daschle assessed chin-ning yes it would limit the SS

160
00:10:13,559 --> 00:10:20,559
consistency purposes okay and now you get a data

161
00:10:21,919 --> 00:10:25,179
today to for the TS

162
00:10:25,179 --> 00:10:30,409
and choose so subject report talk to strip for

163
00:10:30,409 --> 00:10:33,419
booking details everything seems to be the same but

164
00:10:33,419 --> 00:10:37,669
there are some subtle differences so shocked to read to right now

165
00:10:37,669 --> 00:10:41,039
backed up tight event pick in here so we've got a set

166
00:10:41,039 --> 00:10:46,429
to be very was now in it is required every and we can recruit DS

167
00:10:46,429 --> 00:10:49,778
safe that closed should now

168
00:10:49,778 --> 00:10:56,220
before kicking cicada said the temporary was getting require resist

169
00:10:56,220 --> 00:10:59,278
26th yeah 60

170
00:10:59,278 --> 00:11:06,208
think I did it 36 economics is for the first

171
00:11:06,208 --> 00:11:09,859
is an ex anyone booking that falls within that time period

172
00:11:09,860 --> 00:11:14,050
so we look to be safe in the first inmate at 23rd May

173
00:11:14,049 --> 00:11:17,049
for example this bookings in the 50 to 90 so

174
00:11:17,049 --> 00:11:20,458
all it takes is booking actually forth in this time period

175
00:11:20,458 --> 00:11:23,489
the second booking the first

176
00:11:23,490 --> 00:11:26,570
3 nice 20 21 22

177
00:11:26,570 --> 00:11:29,990
23 actually first four nights fall within the

178
00:11:29,990 --> 00:11:33,049
they region and its third looking

179
00:11:33,049 --> 00:11:36,208
who takes full VIN the region as you expand

180
00:11:36,208 --> 00:11:40,069
the dates you get more and more bookings

181
00:11:40,070 --> 00:11:45,100
a.m. this one again writing three on 06 August 28 to May

182
00:11:45,100 --> 00:11:49,139
to the 31st July to get the full within the book it

183
00:11:49,139 --> 00:11:52,649
at least a couple with a stoner okay so the idea of Tempe variables is to the

184
00:11:52,649 --> 00:11:55,610
global variables are available for out the application the really useful

185
00:11:55,610 --> 00:11:56,789
they're accessible for

186
00:11:56,789 --> 00:12:00,159
at by with macros and VBA even with

187
00:12:00,159 --> 00:12:03,870
not using VBA and squire the

188
00:12:03,870 --> 00:12:07,060
comment oMG assaults a strict quality techniques for

189
00:12:07,059 --> 00:12:10,750
using for RAM touring down takes reports

190
00:12:10,750 --> 00:12:13,850
and lost in a minute to

191
00:12:13,850 --> 00:12:16,870
is when a girl at your moms gonna change

192
00:12:16,870 --> 00:12:20,028
sore subject for the data

193
00:12:20,028 --> 00:12:23,189
can to a

194
00:12:23,190 --> 00:12:26,910
for guest activity go back to

195
00:12:26,909 --> 00:12:31,110
FormView and it's not resolve this now the issue

196
00:12:31,110 --> 00:12:34,528
right to change this to the 23rd still

197
00:12:34,528 --> 00:12:39,649
the guests but the accident summation

198
00:12:39,649 --> 00:12:42,740
just storing is not there

199
00:12:42,740 --> 00:12:46,440
okay so think useful caught on video

200
00:12:46,440 --> 00:12:49,579
and I'll see you an extra day we'll be talking

201
00:12:49,578 --> 00:12:53,078
so we'll be talking about probably

202
00:12:53,078 --> 00:12:55,939
for every print preview art in