1
00:00:01,139 --> 00:00:03,439
and i'm ok taxes 2013 tutorials

2
00:00:03,439 --> 00:00:08,300
in this video I'm gonna be using it day at function and instant

3
00:00:08,300 --> 00:00:12,990
textboxes to the form Chancellor you know from the last video

4
00:00:12,990 --> 00:00:16,640
and are going to be getting it to load up to

5
00:00:16,640 --> 00:00:21,350
dates she don't have any idea on talking I highly recommend you go on walks

6
00:00:21,350 --> 00:00:24,528
previous video if you do am between

7
00:00:24,528 --> 00:00:27,730
so miss open up

8
00:00:27,730 --> 00:00:31,160
this database and if you wanna play along

9
00:00:31,160 --> 00:00:34,289
about that its a

10
00:00:34,289 --> 00:00:39,179
followed link bloody 02 them a section of signed on a Texas 2013 DB 56

11
00:00:39,179 --> 00:00:42,600
tone and okay what we making

12
00:00:42,600 --> 00:00:45,870
making a shoulda whatcha gonna do

13
00:00:45,869 --> 00:00:50,488
well this is for a hotel booking system and what we

14
00:00:50,488 --> 00:00:53,679
want to these crates or a visual representation of

15
00:00:53,679 --> 00:00:56,719
bookings so what we're gonna need is we're going to need

16
00:00:56,719 --> 00:01:01,750
love text boxes along top gonna be

17
00:01:01,750 --> 00:01:05,920
power going to contain it dates and then under here under a number wouldn't have

18
00:01:05,920 --> 00:01:07,079
other text boxes

19
00:01:07,079 --> 00:01:10,469
that will contain a.m.

20
00:01:10,469 --> 00:01:14,489
information about the room so she text books here

21
00:01:14,489 --> 00:01:18,530
able correspond to the day in a textbox here and the room number

22
00:01:18,530 --> 00:01:22,040
tussle over that firms flocked by Donna me confused

23
00:01:22,040 --> 00:01:25,270
I've sure tomorrow to stuff

24
00:01:25,269 --> 00:01:28,589
to go on and you'll see hopefully you see what i'm talking about.

25
00:01:28,590 --> 00:01:32,140
so for successfully at two text boxes no need to be the same size

26
00:01:32,140 --> 00:01:37,460
so mister decision to lay up to you speculative this process

27
00:01:37,459 --> 00:01:41,349
for Anthony to make every text books one point pay

28
00:01:41,349 --> 00:01:44,658
and this case to case 1.8

29
00:01:44,659 --> 00:01:49,149
it's not gonna be suspicion on a doublet 3.60 mi changed

30
00:01:49,149 --> 00:01:52,750
3.6 this one this one

31
00:01:52,750 --> 00:01:58,618
this warm will be 1.8 this

32
00:01:58,618 --> 00:02:02,359
Commission 3.6 this

33
00:02:02,359 --> 00:02:08,050
this English can be 1.8 this farm

34
00:02:08,050 --> 00:02:12,140
sink 1.9 6 hidden

35
00:02:12,139 --> 00:02:16,378
and a swim in this one known to be one point

36
00:02:16,378 --> 00:02:19,378
need anything else without him on afterwards

37
00:02:19,378 --> 00:02:23,169
cakes and now what we need to do need to click on

38
00:02:23,169 --> 00:02:28,030
this text books in split horizontal stickers onto

39
00:02:28,030 --> 00:02:32,360
your split horizontal and we're gonna be adding the

40
00:02:32,360 --> 00:02:36,000
text boxes into the had a section here so

41
00:02:36,000 --> 00:02:40,209
split them horizontal showcasing arose text boxes

42
00:02:40,209 --> 00:02:44,390
and the wrong one point a centimeters wide

43
00:02:44,389 --> 00:02:48,568
now 22 dues add San arose

44
00:02:48,568 --> 00:02:51,919
empty cells a one-point action is what now looking at the text boxes so good

45
00:02:51,919 --> 00:02:52,919
design click on

46
00:02:52,919 --> 00:02:56,030
text books in to its dropped on

47
00:02:56,030 --> 00:03:00,360
in there label I miss go to design G

48
00:03:00,360 --> 00:03:04,730
click on the text box is dragging first control C

49
00:03:04,729 --> 00:03:08,359
controls P talk about manana

50
00:03:08,360 --> 00:03:12,510
control v you'll be careful

51
00:03:12,509 --> 00:03:19,509
trophy try make sure that they go in the layout

52
00:03:25,080 --> 00:03:32,080
string cheese with tuna

53
00:03:34,979 --> 00:03:39,759
see more

54
00:03:39,759 --> 00:03:43,789
remain tournament recommend K

55
00:03:43,789 --> 00:03:47,209
untidy shamanism to sue you if 5

56
00:03:47,209 --> 00:03:54,209
child 1234 5678 910-1112 notice no good

57
00:03:54,740 --> 00:03:57,900
I have arrested two more answer right answer

58
00:03:57,900 --> 00:04:00,920
right on both these to be 1.8

59
00:04:00,919 --> 00:04:07,919
this to them as we go fifteen text boxes

60
00:04:08,560 --> 00:04:12,229
she's pretty cool 10

61
00:04:12,229 --> 00:04:15,409
and which has a name now so this ones gonna be

62
00:04:15,409 --> 00:04:20,180
txt day one sons gonna be

63
00:04:20,180 --> 00:04:25,840
txt day to I guess we need to do among a subject you to me do not determine pause

64
00:04:25,839 --> 00:04:26,979
the video and name them

65
00:04:26,980 --> 00:04:30,060
and then you can do the same if you want toast

66
00:04:30,060 --> 00:04:33,600
txt day and then the number to text books so this is one

67
00:04:33,600 --> 00:04:40,330
to 34 septra if at a work malloy make this txt date 0

68
00:04:40,329 --> 00:04:46,349
make this to txt day 1 there's a reason and on pause video now

69
00:04:46,350 --> 00:04:50,890
a Compaq and I've done it coach Lisa to exceed 80

70
00:04:50,889 --> 00:04:54,918
day one to very for five pools where

71
00:04:54,918 --> 00:04:58,659
I'm missing missing missing

72
00:04:58,660 --> 00:05:01,930
that asked to come on the textboxes goat

73
00:05:01,930 --> 00:05:08,060
to arrange select row selected to love them go to format and former them as

74
00:05:08,060 --> 00:05:11,860
day to say short day and the same for

75
00:05:11,860 --> 00:05:15,139
these two text boxes here

76
00:05:15,139 --> 00:05:19,228
former short day

77
00:05:19,228 --> 00:05:22,389
a cakes in Africa FormView we get sis

78
00:05:22,389 --> 00:05:27,439
free architecturally slower growth in a sexually

79
00:05:27,439 --> 00:05:31,410
sorry sink them so yeah

80
00:05:31,410 --> 00:05:37,430
but appreciate format special effects sunken hurting a little bit nicer

81
00:05:37,430 --> 00:05:41,620
Anna yeah our live with that for the moment

82
00:05:41,620 --> 00:05:45,069
okay so now we're going to do is when we load up

83
00:05:45,069 --> 00:05:48,149
form gonna set this day

84
00:05:48,149 --> 00:05:53,120
said his text books to be today's day and we're gonna settle these text books

85
00:05:53,120 --> 00:05:54,050
is here

86
00:05:54,050 --> 00:05:58,990
to be this would be today's days well in the mississippi plus one

87
00:05:58,990 --> 00:06:02,740
to 34 cetera so let's do that

88
00:06:02,740 --> 00:06:06,220
so good for coated ven and on click

89
00:06:06,220 --> 00:06:10,760
macro filter not click on

90
00:06:10,759 --> 00:06:16,860
Asma talking about I'm in

91
00:06:16,860 --> 00:06:20,990
to form and

92
00:06:20,990 --> 00:06:24,030
up go to load

93
00:06:24,029 --> 00:06:28,219
even does so I meant okay process unless

94
00:06:28,220 --> 00:06:33,599
a.m. set Tempe variable September variable names in the TMP

95
00:06:33,598 --> 00:06:37,110
star say an expression is gonna equal

96
00:06:37,110 --> 00:06:40,229
take fun enough

97
00:06:40,228 --> 00:06:43,779
and then we're going to Sep property

98
00:06:43,779 --> 00:06:50,209
which controlling every txt start a high seems to have gone to txt start a hybrid

99
00:06:50,209 --> 00:06:52,379
name it Sevenoaks are

100
00:06:52,379 --> 00:06:55,569
have noted by okay

101
00:06:55,569 --> 00:06:58,740
txt star day think Joel

102
00:06:58,740 --> 00:07:02,050
and this one is gonna be txt in

103
00:07:02,050 --> 00:07:06,598
day now

104
00:07:06,598 --> 00:07:11,579
form event on load factor macro

105
00:07:11,579 --> 00:07:15,348
handset property txt

106
00:07:15,348 --> 00:07:18,408
start they property value

107
00:07:18,408 --> 00:07:22,050
equals temp boss

108
00:07:22,050 --> 00:07:25,060
to them be

109
00:07:25,060 --> 00:07:31,639
star state and design view

110
00:07:31,639 --> 00:07:36,509
and form woohoo get today's take re:

111
00:07:36,509 --> 00:07:39,968
and now need to correct a layup to you

112
00:07:39,968 --> 00:07:45,468
go to form go to unload again

113
00:07:45,468 --> 00:07:51,918
how much can a minimize tease grab group drug that one over

114
00:07:51,918 --> 00:07:55,228
nicollette a.m. set day

115
00:07:55,228 --> 00:07:58,829
text for

116
00:07:58,829 --> 00:08:02,959
stage change can be set property

117
00:08:02,959 --> 00:08:07,788
txt day 0 properties in the value

118
00:08:07,788 --> 00:08:11,060
is going to be equal to date had

119
00:08:11,060 --> 00:08:16,899
this is the day at function how many days so adding days

120
00:08:16,899 --> 00:08:20,508
and in this case indicting any days and

121
00:08:20,509 --> 00:08:26,560
day's going to be temp farce TMP

122
00:08:26,560 --> 00:08:32,168
start take

123
00:08:32,168 --> 00:08:36,698
so exact closer and to design view for me

124
00:08:36,698 --> 00:08:39,698
from to white

125
00:08:39,698 --> 00:08:42,968
hey

126
00:08:42,969 --> 00:08:46,600
ciskei font-size:

127
00:08:46,600 --> 00:08:49,659
acceptance cuz a perfect

128
00:08:49,659 --> 00:08:53,870
range electro fun saw a

129
00:08:53,870 --> 00:08:58,578
Z 8 slim okie dokie

130
00:08:58,578 --> 00:09:02,689
and back to then back to form

131
00:09:02,690 --> 00:09:08,009
act on the road take a concept property control C

132
00:09:08,009 --> 00:09:12,269
control v and we're going to use Romney's in Long

133
00:09:12,269 --> 00:09:17,370
change that to one change that 21 other couple United enough

134
00:09:17,370 --> 00:09:22,028
to tourists to self change it to that

135
00:09:22,028 --> 00:09:25,899
to still want more shit

136
00:09:25,899 --> 00:09:29,049
shari and tits sorry

137
00:09:29,049 --> 00:09:32,479
K so what we're doing is we're saying a temperature variable

138
00:09:32,480 --> 00:09:36,759
at today's day amor load in the form

139
00:09:36,759 --> 00:09:40,019
is putting today's date your temporary will hear

140
00:09:40,019 --> 00:09:43,250
and its two in temper variable so here is actually

141
00:09:43,250 --> 00:09:46,839
niece cells adding a.m.

142
00:09:46,839 --> 00:09:51,259
tallies the temporary rule meh he should be smaller in fact

143
00:09:51,259 --> 00:09:54,600
key okie dokie

144
00:09:54,600 --> 00:09:59,579
what do you think reaching producing I guess our

145
00:09:59,578 --> 00:10:02,750
okay again among the subjects you too the

146
00:10:02,750 --> 00:10:08,610
restive to I dinner Saturday something that myself you wanted a self carry on

147
00:10:08,610 --> 00:10:11,778
otherwise you can be the sneaky go to the next video and download

148
00:10:11,778 --> 00:10:15,078
to database an extra day ritual have

149
00:10:15,078 --> 00:10:19,750
all these added in okay so this is the general idea next video we can be so

150
00:10:19,750 --> 00:10:20,470
looking at

151
00:10:20,470 --> 00:10:25,189
one almost a day weekend was be looking to do something with the boxes here

152
00:10:25,188 --> 00:10:29,059
but when he texted get the information between these text books here from

153
00:10:29,059 --> 00:10:30,008
somewhere so

154
00:10:30,009 --> 00:10:33,610
of explaining that actually a to check your chin and see that