1
00:00:01,328 --> 00:00:03,668
hello i'm ok taxes 2013 she two rooms this

2
00:00:03,669 --> 00:00:07,490
is the force in a little managers videos online forms

3
00:00:07,490 --> 00:00:10,589
and we show you how to close are looking for an open up

4
00:00:10,589 --> 00:00:14,669
another form so I can apply long for link below video to the intersection a

5
00:00:14,669 --> 00:00:19,259
website and download access 2013 DB 32

6
00:00:19,260 --> 00:00:23,289
SP usual and to open a

7
00:00:23,289 --> 00:00:27,939
you know she wrecked

8
00:00:27,939 --> 00:00:32,710
through not phone log imagery

9
00:00:32,710 --> 00:00:36,480
wretched lost video was recruited

10
00:00:36,479 --> 00:00:43,479
the macro summit bomb I'm

11
00:00:44,670 --> 00:00:48,309
to evaluating River the password entered actually exists

12
00:00:48,308 --> 00:00:51,459
in the users table if it does a returning user ID is not

13
00:00:51,460 --> 00:00:56,329
-1 so soon it does what we want to do you want a closer look inform

14
00:00:56,329 --> 00:01:00,509
and open the four main so disney's rave tonight

15
00:01:00,509 --> 00:01:04,420
which is close window

16
00:01:04,420 --> 00:01:07,640
down here and

17
00:01:07,640 --> 00:01:14,640
open form for mine

18
00:01:16,670 --> 00:01:21,170
Saif to transform the thanks Conway

19
00:01:21,170 --> 00:01:24,700
password summit so

20
00:01:24,700 --> 00:01:27,719
us the 02 arena a

21
00:01:27,718 --> 00:01:32,419
upcoming however there's something else you can do reaches you can

22
00:01:32,420 --> 00:01:37,159
crate a macro a.m. that will dynamically close

23
00:01:37,159 --> 00:01:41,368
form an open another form which are the show you how to do anyway

24
00:01:41,368 --> 00:01:44,909
so the script macro that was

25
00:01:44,909 --> 00:01:49,399
by the world it that way to critics style again create she pick a macro

26
00:01:49,399 --> 00:01:53,859
and me to be saving macro program

27
00:01:53,859 --> 00:01:57,000
flow and

28
00:01:57,000 --> 00:02:01,459
got in a sub macro in a cooler close

29
00:02:01,459 --> 00:02:04,950
and who can form

30
00:02:04,950 --> 00:02:07,950
and it's gonna be

31
00:02:07,950 --> 00:02:12,650
I'm clues window

32
00:02:12,650 --> 00:02:15,760
talks for now we're gonna to

33
00:02:15,759 --> 00:02:22,759
feast for were gonna said if talk phone in Amy's temporary pools

34
00:02:23,209 --> 00:02:27,979
political dis

35
00:02:27,979 --> 00:02:31,048
form to

36
00:02:31,049 --> 00:02:36,989
close and

37
00:02:36,989 --> 00:02:42,250
them a good open form and yes I

38
00:02:42,250 --> 00:02:49,250
form name scan to be temporary as well

39
00:02:53,620 --> 00:02:57,740
unit term 10 form

40
00:02:57,740 --> 00:03:03,370
to from mega

41
00:03:03,370 --> 00:03:07,610
temp fold clothes to mp4 close

42
00:03:07,610 --> 00:03:10,810
so this macro is gonna close

43
00:03:10,810 --> 00:03:15,879
Windows cases form and it's an open offer form on the values to names

44
00:03:15,879 --> 00:03:20,799
we can actually use temporary partial so we can call this in multiple instances

45
00:03:20,800 --> 00:03:24,719
a.m. and dais to dynamic to do that so

46
00:03:24,719 --> 00:03:28,159
close-up then go back to form login

47
00:03:28,159 --> 00:03:32,659
submit so get rid of

48
00:03:32,659 --> 00:03:36,469
close window and

49
00:03:36,469 --> 00:03:39,849
form and star

50
00:03:39,849 --> 00:03:44,219
wrong nah she don't good set

51
00:03:44,219 --> 00:03:47,509
temporary room CNP form

52
00:03:47,509 --> 00:03:51,879
to close expression

53
00:03:51,879 --> 00:03:55,099
equals I am form no

54
00:03:55,099 --> 00:03:59,069
in next one is Sept variable

55
00:03:59,069 --> 00:04:02,840
TMP form

56
00:04:02,840 --> 00:04:06,080
each open

57
00:04:06,080 --> 00:04:09,380
and I was going to be form

58
00:04:09,379 --> 00:04:12,810
main an awesome when it is wrong that macro

59
00:04:12,810 --> 00:04:16,509
run macro my current flow

60
00:04:16,509 --> 00:04:20,259
door closer form and save that

61
00:04:20,259 --> 00:04:24,469
stance assist that works forms you

62
00:04:24,470 --> 00:04:27,900
james Conway password

63
00:04:27,899 --> 00:04:32,120
did okay just reiterate what we've done

64
00:04:32,120 --> 00:04:35,168
just in case it's a little confusing on its think it is %um

65
00:04:35,168 --> 00:04:38,199
look are simple reef set

66
00:04:38,199 --> 00:04:42,089
Tempe very vocal temp firms close we've given a value form login

67
00:04:42,089 --> 00:04:46,779
which September variable temp firm to open given value for mine and then we've

68
00:04:46,779 --> 00:04:47,559
run a macro

69
00:04:47,560 --> 00:04:50,728
to program flow top close and I perform

70
00:04:50,728 --> 00:04:55,110
and that macro

71
00:04:55,110 --> 00:04:59,580
closes forming opens another form

72
00:04:59,579 --> 00:05:02,609
and the names the former closes is

73
00:05:02,610 --> 00:05:06,288
10 vast him for closes form login and names from opens

74
00:05:06,288 --> 00:05:10,060
tembo stem from to open which is forming so

75
00:05:10,060 --> 00:05:12,750
they gather to how you can to dynamically although there's nothing

76
00:05:12,750 --> 00:05:15,149
wrong with the first where show you I just wanted to

77
00:05:15,149 --> 00:05:19,469
show you slightly different concepts for open and close informs

78
00:05:19,470 --> 00:05:22,300
okay thank you very much worse incident cash it in action