Microsoft Access VBA Macro Programming

This page intentionally left blank ...

Chapter 40 Set Up Levels of User Security Chapter 40 Set Up Levels of User Security B ecause your application is likely to be mu ...

X = GetUserName(strUser, 256 ) strUser = RTrim(strUser) strUser = Left(strUser, Len(strUser) - 1 ) Set RecSet = CurrentDb.OpenRe ...

If you only want certain users to be able to see some of the controls, you can easily hide and unhide individual controls accord ...

This page intentionally left blank ...

Appendix ASCII Character Codes Appendix ASCII Character Codes T his appendix is a listing of the 255 ASCII (American Standard Co ...

360 Microsoft Access 2010 VBA Macro Programming ASCII Code Character 15 _ 16 _ 17 _ 18 _ 19 _ 20 _ 21 _ 22 _ 23 _ 24 _ 25 _ 26 _ ...

Appendix: ASCII Character Codes 361 ASCII Code Character 89 Y 90 Z 91 [ 92 \ 93 ] 94 ^ 95 _ 96 ` 97 a 98 b 99 c 100 d 101 e 102 ...

362 Microsoft Access 2010 VBA Macro Programming ASCII Code Character 163 £ 164 ¤ 165 ¥ 166 ¦ 167 § 168 ̈ 169 © 170 ª 171 << ...

Appendix: ASCII Character Codes 363 ASCII Code Character 237 Í 238 Î 239 Ï 240 Ð 241 Ñ 242 Ò 243 Ó 244 Ô 245 Õ 246 Ö ASCII Code ...

This page intentionally left blank ...

Index. Index operator, 73 operator, 72 ^ operator, 74 +operator, 72–73 \ operator, 73 / operator, 73 A Abs function, 49 ACCD ...

audit trails enhancing, 292 overview, 290 using events to create, 290–292 authorized users, 281–282 See alsologin IDs B Beep met ...

Null value, 19–20 numeric types, 20–21 overview, 18, 20 string types, 21–22 variants, 18–19 See alsouser-defined types databases ...

errors compile errors, 81–82 generating your own, 94–95 logic errors, 82 runtime errors, 82 Type Mismatch errors, 73 See alsodeb ...

GetScreentipMso method, 140 GetSupertipMso method, 140 GetUserName function, 290 GetVisibleMso method, 140 global variables, 15, ...

message boxes, 66–69 in debugging, 89–90 See alsoMsgBox statements methods, 176–178 calling, 180–184 Microsoft Graph 12.0 Object ...

Private keyword, 32 procedure stepping, 85 Project Explorer, 6–8 Project trees, 6 properties, 176–178 manipulating read/write pr ...

Select case statements, 39–40 See alsoconditional statements Select query, 154–156 See alsoSQL queries semaphore files, 340–341 ...

local variables, 15–16 module-level variables, 16 name conflicts, 17 overview, 13–14 scope and lifetime of, 15 shadowing, 17 str ...