AL: Access Tab Control, Unicode, Format (Excel too), by crystal
758 بار بازدید -
4 ماه پیش
-
Visualize your data better by
Visualize your data better by crystal. Three topics: (1) Tab Control (2) Unicode, and (3) Format
The Tab Control is great at organizing controls and subforms. Change styles, or don’t show tabs at all and use buttons that can have COLOR to switch pages. How to add space around captions.
Use Unicode characters for checkboxes and other places to display characters that look like images except you can change size and color! Get handy tool to lookup characters you might want to use.
Change the Format to show cool text without any code -- works in Excel too!
0:00 Access Tab Control, Unicode, Format (in Excel too)
00:47 introduction by Maria Barnes
02:06 Hello from crystal
02:46 Tab Control
03:34 Pages - Caption, PageIndex
04:44 Command buttons that look like tabs
05:16 demo Tab Control examples
06:10 PressedColor
06:47 VBA runs when tab changes
07:37 Properties for Tab Control, Page, Command Button
09:21 Tab Control Font Size
09:34 Captions - space before and after
10:08 Alt+0160 (numeric keypad) for required space
10:40 Subdatasheets take connections
11:30 load page contents when you click on a tab
11:54 Peter - referencing subform complicated with Navigation Control
12:38 Adrian - Word Nonbreaking space
13:23 Colin - tab width
13:56 Ben - putting in your own margin
14:06 Pat - on referencing subforms, tab control is irrelevent
14:52 Neil - Parent property of subform on tab control is Page then Tab Control then Form
17:24 load subforms when tab page pressed and unload when form closes
18:09 insert textbox on page -- Page is selected
drag from mainform doesn't work because control isn't ON page
19:22 Adrian - to move something from off tab control to on tab control, cut, and then paste to page
20:27 what you paste goes at the bottom of a tab page
23:07 used ability to show same control on each tab for Calendar
24:18 Peter - Theme add-in, ran out of numbers of controls
25:16 Colin - control count over lifetime of form
29:49 Unicode in the Format Property
29:56 ASCII - American Standard Code for Information Interchange
30:46 use Format tips in Excel too!
31:00 examples to show checkboxes using Unicode in textbox Format
31:30 4 parts for a numeric Format code
31:51 In SQL Server, 1 is True. In Access, -1 is True. 0 is False for both.
32:12 numeric Format code: positive; negative; 0; Null
32:22 text Format code: 2 parts
32:36 Color names for format codes
32:41 also use in Excel cell Format
32:57 form to show Unicode "checkboxes"
33:57 copy Format codes that you like
34:17 look up Unicode characters
34:39 Unicode Character Map tool
copy Unicode characters, decimal and hex codes, lookup
36:39 Unicode Blocks
37:25 Up/Down changes command button captions to Chrw(#) where # is decimal Unicode value
39:19 Format can show message in control if Value is Null
@ is placeholder for any text
second part is message if Null
40:03 avoid unnessary Union queries for comboboxes by setting Format
40:20 Ben - what font?
41:42 nextQ: how different than Windows Character Map?
42:46 Maria - code numbers mostly across any font?
43:20 Windows Character Map
44:11 decimal code for ChrW function from Unicode CharMap
44:28 Maria - in Windows map, go to starting point and see same thing?
47:54 next Lunchtime meeting
48:09 Steve Schapel: Unravelling Constraints, A Case Study
50:01 Richard - Unicode tip for sort direction
Links
Presentation
https://msaccessgurus.com/presentatio...
Tab Control examples
https://msaccessgurus.com/tool/TabCon...
Checkbox Format examples + Unicode Character Map:
https://msaccessgurus.com/tool/Unicod...
Unicode Character Map tool
http://msaccessgurus.com/tool/Unicode...
Colin Riddington: My article on specifications & limits:
https://www.isladogs.co.uk/access-spe...
Jim Dettman: 754 is still the published limit:
https://support.microsoft.com/en-us/o...
Phil Foulis: ASCII Code 160
https://www.ascii-code.com/CP1252/160
How to make an Access add-in
https://msaccessgurus.com/tool/Addin_...
Next
Unravelling Constraints: A Case Study with Steve Schapel
Tuesday 26 March 2024
12 noon Central US
https://accessusergroups.org/lunch/ev...
join us!
AccessUserGroups.org host Maria Barnes
Last Tuesday @ noon Central
https://accessusergroups.org/lunch/
The Tab Control is great at organizing controls and subforms. Change styles, or don’t show tabs at all and use buttons that can have COLOR to switch pages. How to add space around captions.
Use Unicode characters for checkboxes and other places to display characters that look like images except you can change size and color! Get handy tool to lookup characters you might want to use.
Change the Format to show cool text without any code -- works in Excel too!
0:00 Access Tab Control, Unicode, Format (in Excel too)
00:47 introduction by Maria Barnes
02:06 Hello from crystal
02:46 Tab Control
03:34 Pages - Caption, PageIndex
04:44 Command buttons that look like tabs
05:16 demo Tab Control examples
06:10 PressedColor
06:47 VBA runs when tab changes
07:37 Properties for Tab Control, Page, Command Button
09:21 Tab Control Font Size
09:34 Captions - space before and after
10:08 Alt+0160 (numeric keypad) for required space
10:40 Subdatasheets take connections
11:30 load page contents when you click on a tab
11:54 Peter - referencing subform complicated with Navigation Control
12:38 Adrian - Word Nonbreaking space
13:23 Colin - tab width
13:56 Ben - putting in your own margin
14:06 Pat - on referencing subforms, tab control is irrelevent
14:52 Neil - Parent property of subform on tab control is Page then Tab Control then Form
17:24 load subforms when tab page pressed and unload when form closes
18:09 insert textbox on page -- Page is selected
drag from mainform doesn't work because control isn't ON page
19:22 Adrian - to move something from off tab control to on tab control, cut, and then paste to page
20:27 what you paste goes at the bottom of a tab page
23:07 used ability to show same control on each tab for Calendar
24:18 Peter - Theme add-in, ran out of numbers of controls
25:16 Colin - control count over lifetime of form
29:49 Unicode in the Format Property
29:56 ASCII - American Standard Code for Information Interchange
30:46 use Format tips in Excel too!
31:00 examples to show checkboxes using Unicode in textbox Format
31:30 4 parts for a numeric Format code
31:51 In SQL Server, 1 is True. In Access, -1 is True. 0 is False for both.
32:12 numeric Format code: positive; negative; 0; Null
32:22 text Format code: 2 parts
32:36 Color names for format codes
32:41 also use in Excel cell Format
32:57 form to show Unicode "checkboxes"
33:57 copy Format codes that you like
34:17 look up Unicode characters
34:39 Unicode Character Map tool
copy Unicode characters, decimal and hex codes, lookup
36:39 Unicode Blocks
37:25 Up/Down changes command button captions to Chrw(#) where # is decimal Unicode value
39:19 Format can show message in control if Value is Null
@ is placeholder for any text
second part is message if Null
40:03 avoid unnessary Union queries for comboboxes by setting Format
40:20 Ben - what font?
41:42 nextQ: how different than Windows Character Map?
42:46 Maria - code numbers mostly across any font?
43:20 Windows Character Map
44:11 decimal code for ChrW function from Unicode CharMap
44:28 Maria - in Windows map, go to starting point and see same thing?
47:54 next Lunchtime meeting
48:09 Steve Schapel: Unravelling Constraints, A Case Study
50:01 Richard - Unicode tip for sort direction
Links
Presentation
https://msaccessgurus.com/presentatio...
Tab Control examples
https://msaccessgurus.com/tool/TabCon...
Checkbox Format examples + Unicode Character Map:
https://msaccessgurus.com/tool/Unicod...
Unicode Character Map tool
http://msaccessgurus.com/tool/Unicode...
Colin Riddington: My article on specifications & limits:
https://www.isladogs.co.uk/access-spe...
Jim Dettman: 754 is still the published limit:
https://support.microsoft.com/en-us/o...
Phil Foulis: ASCII Code 160
https://www.ascii-code.com/CP1252/160
How to make an Access add-in
https://msaccessgurus.com/tool/Addin_...
Next
Unravelling Constraints: A Case Study with Steve Schapel
Tuesday 26 March 2024
12 noon Central US
https://accessusergroups.org/lunch/ev...
join us!
AccessUserGroups.org host Maria Barnes
Last Tuesday @ noon Central
https://accessusergroups.org/lunch/
4 ماه پیش
در تاریخ 1402/12/25 منتشر شده
است.
758
بـار بازدید شده