Computer Based Training: Office 97, Windows 95 & NT Basics

home *** CD-ROM | disk | FTP | other *** search

/ Computer Based Training: …, Windows 95 & NT Basics / a1454501.iso / mo97a03 / AA03.CTL < prev next >

Wrap

Text File | 1997-05-20 | 29.1 KB | 1,049 lines

* Screen 3 1 9 ********************************* * Course: Advanced Access 97 * Unit: Automating with macros Unit No.:03 * Topic: Creating macros Topic No.: 1 **** eff.exe a03_101.gif 86 443 0 1 0 15 15 15 * A macro is a set of one or mor isave 68 458 375 407 text1 textbox 68 458 375 407 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_102a.gif 210 312 0 1 0 15 15 15 * You can create Access 97 macro isave 68 412 375 339 text2 growbox 68 412 375 339 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_103a.gif 179 123 0 1 0 15 15 15 * You can also define condition isave 68 344 375 271 text3 growbox 68 344 375 271 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 68 344 image memory text2 0 68 412 image memory text1 0 68 458 * eff.exe a03_104a.gif 93 312 0 1 0 15 15 15 * Access 97 provides various typ isave 69 457 348 389 text1 textbox 69 457 348 389 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_105a.gif 191 221 0 1 0 15 15 15 eff.exe a03_105b.gif 377 390 0 1 0 15 15 15 * For example, you can use macro isave 69 394 348 304 text2 growbox 69 394 348 304 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_106a.gif 377 390 0 1 0 15 15 15 eff.exe a03_106b.gif 191 226 0 1 0 15 15 15 * ≥ execute a select or action q isave 69 309 348 270 text3 growbox 69 309 348 270 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_107a.gif 196 226 0 1 0 15 15 15 eff.exe a03_107b.gif 352 375 0 1 0 15 15 15 * ≥ move, size, minimize, maximi isave 69 275 348 202 text4 growbox 69 275 348 202 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text4 0 69 275 image memory text3 0 69 309 image memory text2 0 69 394 image memory text1 0 69 457 * eff.exe a03_108a.gif 196 207 0 1 0 15 15 15 eff.exe a03_108b.gif 354 284 0 1 0 15 15 15 * Other uses of macros includ isave 69 455 400 387 text1 textbox 69 455 400 387 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_109a.gif 355 282 0 1 0 15 15 15 * ≥ displaying warning or inform isave 69 392 400 353 text2 growbox 69 392 400 353 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** *qcall AA03q 030101 eff.exe a03_110a.gif 173 294 0 1 0 15 15 15 * ≥ sending data from a table, q isave 69 358 400 285 text3 growbox 69 358 400 285 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 69 358 image memory text2 0 69 392 image memory text1 0 69 455 ** qcall AA03q 030101 eff.exe a03_111a.gif 135 294 0 1 0 15 15 15 eff.exe a03_111b.gif 136 105 0 1 0 15 15 15 * With 49 macro actions to choos isave 241 430 492 362 text1 textbox 241 430 492 362 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text1 0 241 430 * eff.exe a03_112a.gif 135 300 0 1 0 15 15 15 * Suppose you have a database ca isave 100 426 406 358 text1 textbox 100 426 406 358 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text1 0 100 426 * eff.exe a03_113a.gif 403 362 0 1 0 15 15 15 eff.exe a03_113b.gif 147 241 0 1 0 15 15 15 * You could create a simple macr isave 71 452 292 384 text1 textbox 71 452 292 384 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_114a.gif 276 317 0 1 0 15 15 15 eff.exe a03_114b.gif 403 362 0 1 0 15 15 15 * Then, whenever you update the isave 71 389 292 282 text2 growbox 71 389 292 282 showtext 0 0 6 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 71 389 image memory text1 0 71 452 * SimScrn 3 2 9 ********************************* eff.exe a03_115.gif 0 459 0 1 0 15 15 15 * To create a macro in Access yo isave 21 378 290 310 text1 textbox 21 378 290 310 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** * Alternatively, you can select notebox 15 284 296 ** eff.exe a03_117a.gif 2 452 0 1 0 15 15 15 eff.exe a03_117b.gif 2 18 0 1 0 15 15 15 * The top pane of the Macro wind isave 21 315 290 259 text2 growbox 21 315 290 259 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 21 315 image memory text1 0 21 378 * eff.exe a03_118a.gif 3 430 0 1 0 15 15 15 * You start by selecting a macro isave 302 454 629 403 text1 textbox 302 454 629 403 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_119a.gif 3 430 0 1 0 15 15 15 * The bottom pane of the Macro w isave 302 408 629 335 text2 growbox 302 408 629 335 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_120a.gif 85 378 0 1 0 15 15 15 eff.exe a03_120b.gif 3 275 0 1 0 15 15 15 * The right-hand side of the Act isave 302 340 629 250 text3 growbox 302 340 629 250 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 302 340 image memory text2 0 302 408 image memory text1 0 302 454 * eff.exe a03_121a.gif 26 430 0 1 0 15 15 15 eff.exe a03_121b.gif 297 431 0 1 0 15 15 15 eff.exe a03_121c.gif 4 176 0 1 0 15 15 15 eff.exe a03_121d.gif 330 187 0 1 0 15 15 15 * You can press F6 to move from isave 375 453 606 402 text1 textbox 375 453 606 402 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_122.gif 0 459 0 1 0 15 15 15 *eff.exe a03_122a.gif 3 427 0 1 0 15 15 15 *eff.exe a03_122b.gif 3 189 0 1 0 15 15 15 *eff.exe a03_122c.gif 345 119 0 1 0 15 15 15 * At the Destination Database fi isave 375 407 606 317 text2 growbox 375 407 606 317 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_123a.gif 0 459 0 1 0 15 15 15 * When you use the Tab key to mo isave 375 322 606 198 text3 growbox 375 322 606 198 showtext 0 0 7 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 375 322 image memory text2 0 375 407 image memory text1 0 375 453 * eff.exe a03_124a.gif 0 459 0 1 0 15 15 15 * The drop-down list at the Sour isave 363 406 620 321 text1 textbox 363 406 620 321 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_125a.gif 3 247 0 1 0 15 15 15 eff.exe a03_125b.gif 3 158 0 1 0 15 15 15 eff.exe a03_125c.gif 350 125 0 1 0 15 15 15 * The list at the Source Object isave 363 326 620 236 text2 growbox 363 326 620 236 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_126a.gif 3 144 0 1 0 15 15 15 eff.exe a03_126b.gif 544 175 0 1 0 15 15 15 * Remember, you can press F1 at isave 363 241 620 185 text3 growbox 363 241 620 185 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 363 241 image memory text2 0 363 326 image memory text1 0 363 406 * eff.exe a03_127a.gif 125 431 0 1 0 15 15 15 eff.exe a03_127b.gif 96 28 0 1 0 15 15 15 * When you place the cursor in t isave 358 359 622 291 text1 textbox 358 359 622 291 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** qcall AA03q 030102 eff.exe a03_128a.gif 145 417 0 1 0 15 15 15 * This is optional but can prove isave 358 296 622 206 text2 growbox 358 296 622 206 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 358 296 image memory text1 0 358 359 * eff.exe a03_129a.gif 1 416 0 1 0 15 15 15 eff.exe a03_129b.gif 13 176 0 1 0 15 15 15 * Now you can select a second ma isave 359 363 614 295 text1 textbox 359 363 614 295 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_130a.gif 1 416 0 1 0 15 15 15 * You may want to choose MsgBox, isave 359 300 614 210 text2 growbox 359 300 614 210 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_131a.gif 25 378 0 1 0 15 15 15 eff.exe a03_131b.gif 13 176 0 1 0 15 15 15 eff.exe a03_131c.gif 406 176 0 1 0 15 15 15 * You can now Tab to the Comment isave 359 215 614 159 text3 growbox 359 215 614 159 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 359 215 image memory text2 0 359 300 image memory text1 0 359 363 * eff.exe a03_132a.gif 3 431 0 1 0 15 15 15 eff.exe a03_132b.gif 3 378 0 1 0 15 15 15 eff.exe a03_132c.gif 346 378 0 1 0 15 15 15 * Then you switch panes and type isave 367 362 621 294 text1 textbox 367 362 621 294 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_133a.gif 3 430 0 1 0 15 15 15 eff.exe a03_133b.gif 3 191 0 1 0 15 15 15 eff.exe a03_133c.gif 346 125 0 1 0 15 15 15 * If you want a beep to sound wh isave 367 299 621 209 text2 growbox 367 299 621 209 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_134a.gif 3 173 0 1 0 15 15 15 eff.exe a03_134b.gif 348 125 0 1 0 15 15 15 * At the Type field, you choose isave 367 214 621 141 text3 growbox 367 214 621 141 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 367 214 image memory text2 0 367 299 image memory text1 0 367 362 * eff.exe a03_135a.gif 3 430 0 1 0 15 15 15 eff.exe a03_135b.gif 3 154 0 1 0 15 15 15 eff.exe a03_135c.gif 346 125 0 1 0 15 15 15 * Next you type the title you wa isave 148 220 468 169 text1 textbox 148 220 468 169 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_136a.gif 3 457 0 1 0 15 15 15 * You must save a macro before y isave 148 174 468 101 text2 growbox 148 174 468 101 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** * You can save a macro in anothe notebox 148 314 463 ** eff.exe a03_138a.gif 20 457 0 1 0 15 15 15 * After entering a name for the isave 148 106 468 50 text3 growbox 148 106 468 50 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 148 106 image memory text2 0 148 174 image memory text1 0 148 220 * SimScrn 3 3 9 ********************************* eff.exe a03_139.gif 0 459 0 1 0 15 15 15 * Access 97 provides a good way isave 9 360 286 309 text1 textbox 9 360 286 309 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_140a.gif 164 434 0 1 0 15 15 15 eff.exe a03_140b.gif 369 434 0 1 0 15 15 15 eff.exe a03_140c.gif 164 275 0 1 0 15 15 15 eff.exe a03_140d.gif 297 275 0 1 0 15 15 15 * To activate single-stepping yo isave 9 314 286 241 text2 growbox 9 314 286 241 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_141a.gif 297 434 0 1 0 15 15 15 eff.exe a03_141b.gif 346 434 0 1 0 15 15 15 eff.exe a03_141c.gif 346 119 0 1 0 15 15 15 * Now you click the Run button ( isave 9 246 286 190 text3 growbox 9 246 286 190 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 9 246 image memory text2 0 9 314 image memory text1 0 9 360 * eff.exe a03_142a.gif 109 431 0 1 0 15 15 15 * Access 97 now opens the Macro isave 6 179 344 128 text1 textbox 6 179 344 128 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_143a.gif 108 406 0 1 0 15 15 15 * In this dialog box you will se isave 6 133 344 60 text2 growbox 6 133 344 60 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe a03a144a.gif 108 377 0 1 0 15 15 15 eff.exe a03a144b.gif 514 377 0 1 0 15 15 15 eff.exe a03a144c.gif 109 255 0 1 0 15 15 15 eff.exe a03a144d.gif 514 265 0 1 0 15 15 15 qcall AA03q 030103 eff.exe a03_144a.gif 446 367 0 1 0 15 15 15 * You click the Step button to c isave 6 65 344 9 text3 growbox 6 65 344 9 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 6 65 image memory text2 0 6 133 image memory text1 0 6 179 * qcall AA03q 030104 eff.exe a03_145a.gif 109 366 0 1 0 15 15 15 * If you click the Continue butt isave 352 151 621 66 text1 textbox 352 151 621 66 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text1 0 352 151 * eff.exe a03_146a.gif 77 430 0 1 0 15 15 15 eff.exe a03_146b.gif 77 290 0 1 0 15 15 15 eff.exe a03_146c.gif 510 290 0 1 0 15 15 15 * The next macro action is now s isave 245 219 479 151 text1 textbox 245 219 479 151 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_147a.gif 77 240 0 1 0 15 15 15 eff.exe a03_147b.gif 510 320 0 1 0 15 15 15 * You could use the Halt button isave 245 156 479 83 text2 growbox 245 156 479 83 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_148a.gif 164 430 0 1 0 15 15 15 eff.exe a03_148b.gif 164 366 0 1 0 15 15 15 eff.exe a03_148c.gif 447 366 0 1 0 15 15 15 * Here, let's run the next actio isave 245 88 479 32 text3 growbox 245 88 479 32 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 245 88 image memory text2 0 245 156 image memory text1 0 245 219 * eff.exe a03_149a.gif 3 399 0 1 0 15 15 15 * The message box you designed u isave 341 145 619 77 text1 textbox 341 145 619 77 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text1 0 341 145 * eff.exe a03_150a.gif 3 368 0 1 0 15 15 15 * You click OK to remove the mes isave 22 123 319 89 text1 textbox 22 123 319 89 showtext 0 0 1 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_151a.gif 190 434 0 1 0 15 15 15 eff.exe a03_151b.gif 521 455 0 1 0 15 15 15 * Finally you can click the Clos isave 22 94 319 38 text2 growbox 22 94 319 38 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 22 94 image memory text1 0 22 123 * Simscrn 3 4 9 eff.exe a03_152.gif 0 459 0 1 0 15 15 15 * Sometimes you may want to conv isave 179 213 480 145 text1 textbox 179 213 480 145 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_153a.gif 4 457 0 1 0 15 15 15 eff.exe a03_153b.gif 318 307 0 1 0 15 15 15 * To do this you choose Save As/ isave 179 150 480 94 text2 growbox 179 150 480 94 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_154a.gif 18 457 0 1 0 15 15 15 * The top radio button is select isave 179 99 480 43 text3 growbox 179 99 480 43 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 179 99 image memory text2 0 179 150 image memory text1 0 179 213 * eff.exe a03_155a.gif 118 330 0 1 0 15 15 15 eff.exe a03_155b.gif 406 349 0 1 0 15 15 15 * You select the Save As Visual isave 145 216 405 165 text1 textbox 145 216 405 165 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_156a.gif 118 383 0 1 0 15 15 15 eff.exe a03_156b.gif 12 18 0 1 0 15 15 15 * Then you click the Convert but isave 145 170 405 131 text2 growbox 145 170 405 131 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_157a.gif 65 431 0 1 0 15 15 15 eff.exe a03_157b.gif 22 403 0 1 0 15 15 15 eff.exe a03_157c.gif 65 403 0 1 0 15 15 15 * The Modules tab becomes the ac isave 145 136 405 12 text3 growbox 145 136 405 12 showtext 0 0 7 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 145 136 image memory text2 0 145 170 image memory text1 0 145 216 * eff.exe a03_158a.gif 5 383 0 1 0 15 15 15 eff.exe a03_158b.gif 5 18 0 1 0 15 15 15 * When you click OK the converte isave 61 267 376 216 text1 textbox 61 267 376 216 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_159a.gif 5 383 0 1 0 15 15 15 eff.exe a03_159b.gif 456 345 0 1 0 15 15 15 * You click Design to open the V isave 61 221 376 182 text2 growbox 61 221 376 182 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_160a.gif 2 452 0 1 0 15 15 15 * Now you can see the converted isave 61 187 376 131 text3 growbox 61 187 376 131 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_161a.gif 521 455 0 1 0 15 15 15 eff.exe a03_161b.gif 550 250 0 1 0 15 15 15 * You click the Close Window but isave 61 136 376 80 text4 growbox 61 136 376 80 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text4 0 61 136 image memory text3 0 61 187 image memory text2 0 61 221 image memory text1 0 61 267 * * Topic: Hands-on: Creating a macro Topic No.: 2 **** * Topic: Hands-on: Creating a macro Topic No.: 2 **** SimScrn 3 5 9 ********************************* MoveCtrl 1 0 410 0 * Usually, when you open a datab isave 42 350 367 282 text1 textbox 42 350 367 282 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** * You can create a simple macro isave 42 287 367 214 text2 growbox 42 287 367 214 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 *** * Access 97 runs a macro automat isave 42 219 367 146 text3 growbox 42 219 367 146 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 * * image memory text3 0 42 219 image memory text2 0 42 287 image memory text1 0 42 350 ** exercise 01 1 120 70 * task 01 0101 1 300 320 8 50 67 5 5 * pause 1 1 1 1 1 1 1 1 ** * Topic: Ways to run macros Topic No.: 3 **** SimScrn 3 6 9 ********************************* movectrl 1 493 426 0 0 eff.exe a03_301.gif 0 459 0 1 0 15 15 15 * Normally you would run a macro isave 51 315 290 230 text1 textbox 51 315 290 230 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** * You can run a macro from the D notebox 30 209 321 ** eff.exe a03_303a.gif 307 361 0 1 0 15 15 15 * After that, you could create a isave 51 235 290 162 text2 growbox 51 235 290 162 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_304a.gif 307 361 0 1 0 15 15 15 * You can also attach a macro to isave 51 167 290 94 text3 growbox 51 167 290 94 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** * An event is an action, such as notebox 59 427 280 ** image memory text3 0 51 167 image memory text2 0 51 235 image memory text1 0 51 315 * eff.exe a03_306a.gif 180 330 0 1 0 15 15 15 eff.exe a03_306b.gif 480 425 0 1 0 15 15 15 eff.exe a03_306c.gif 329 194 0 1 0 15 15 15 * Suppose you would like to add isave 43 151 463 100 text1 textbox 43 151 463 100 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_307a.gif 65 457 0 1 0 15 15 15 eff.exe a03_307b.gif 480 425 0 1 0 15 15 15 * First you choose View - Toolba isave 43 105 463 49 text2 growbox 43 105 463 49 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_308a.gif 50 457 0 1 0 15 15 15 eff.exe a03_308b.gif 550 457 0 1 0 15 15 15 * Now you click the Commands tab isave 43 54 463 15 text3 growbox 43 54 463 15 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 43 54 image memory text2 0 43 105 image memory text1 0 43 151 * eff.exe a03_309a.gif 143 386 0 1 0 15 15 15 * You use the scroll bar in the isave 18 204 322 136 text1 textbox 18 204 322 136 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_310a.gif 135 382 0 1 0 15 15 15 eff.exe a03_310b.gif 135 340 0 1 0 15 15 15 * When you select All Macros fro isave 18 141 322 68 text2 growbox 18 141 322 68 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_311a.gif 135 458 0 1 0 15 15 15 eff.exe a03_311b.gif 151 200 0 1 0 15 15 15 * You select the macro you requi isave 18 73 322 17 text3 growbox 18 73 322 17 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 18 73 image memory text2 0 18 141 image memory text1 0 18 204 * eff.exe a03_312a.gif 154 458 0 1 0 15 15 15 * When you drag the command over isave 3 456 460 388 text1 textbox 3 456 460 388 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_313a.gif 298 318 0 1 0 15 15 15 eff.exe a03_313b.gif 292 288 0 1 0 15 15 15 * When you release the mouse, th isave 3 393 460 354 text2 growbox 3 393 460 354 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_314a.gif 300 316 0 1 0 15 15 15 eff.exe a03_314b.gif 424 109 0 1 0 15 15 15 * MoveCtrl 1 0 410 0 0 isave 3 359 460 320 text3 growbox 3 359 460 320 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** MoveCtrl 1 493 410 0 0 image memory text3 0 3 359 image memory text2 0 3 393 image memory text1 0 3 456 * qcall AA03q 030301 eff.exe a03_315a.gif 7 457 0 1 0 15 15 15 * Now you can run the macro from isave 302 414 562 329 text1 textbox 302 414 562 329 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_316a.gif 102 457 0 1 0 15 15 15 * When you point to the Macro op isave 302 334 562 244 text2 growbox 302 334 562 244 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** * To remove the command from the notebox 304 213 567 ** image memory text2 0 302 334 image memory text1 0 302 414 * eff.exe a03_318a.gif 7 457 0 1 0 15 15 15 * MoveCtrl 1 0 410 0 0 isave 171 242 436 174 text1 textbox 171 242 436 174 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_319a.gif 170 325 0 1 0 15 15 15 eff.exe a03_319b.gif 562 415 0 1 0 15 15 15 * Suppose you would like to plac isave 171 179 436 89 text2 growbox 171 179 436 89 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_320a.gif 50 431 0 1 0 15 15 15 * With the toolbar you want to a isave 171 94 436 4 text3 growbox 171 94 436 4 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 171 94 image memory text2 0 171 179 image memory text1 0 171 242 * eff.exe a03_321a.gif 281 336 0 1 0 15 15 15 eff.exe a03_321b.gif 506 449 0 1 0 15 15 15 * You then drag the command to t isave 258 458 509 373 text1 textbox 258 458 509 373 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_322a.gif 298 318 0 1 0 15 15 15 eff.exe a03_322b.gif 506 449 0 1 0 15 15 15 eff.exe a03_322c.gif 298 186 0 1 0 15 15 15 eff.exe a03_322d.gif 506 186 0 1 0 15 15 15 * When you release the mouse, th isave 258 378 509 305 text2 growbox 258 378 509 305 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe a03a323a.gif 300 316 0 1 0 15 15 15 eff.exe a03a323b.gif 537 415 0 1 0 15 15 15 eff.exe a03a323c.gif 300 186 0 1 0 15 15 15 eff.exe a03a323d.gif 537 186 0 1 0 15 15 15 qcall AA03q 030302 eff.exe a03_323a.gif 194 310 0 1 0 15 15 15 * You can click the Modify Selec isave 258 310 509 254 text3 growbox 258 310 509 254 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 258 310 image memory text2 0 258 378 image memory text1 0 258 458 * eff.exe a03_324a.gif 194 176 0 1 0 15 15 15 * For example, you may want to c isave 302 293 572 242 text1 textbox 302 293 572 242 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_325a.gif 197 430 0 1 0 15 15 15 eff.exe a03_325b.gif 197 310 0 1 0 15 15 15 * Then you click Close to return isave 302 247 572 191 text2 growbox 302 247 572 191 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 302 247 image memory text1 0 302 293 * SimScrn 3 7 9 ********************************* eff.exe a03_326.gif 0 459 0 1 0 15 15 15 * Another way that you can run a isave 335 415 611 347 text1 textbox 335 415 611 347 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_327a.gif 440 148 0 1 0 15 15 15 * Then Access carries out the ac isave 335 352 611 296 text2 growbox 335 352 611 296 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_328a.gif 2 452 0 1 0 15 15 15 * Suppose you would like to use isave 335 301 611 228 text3 growbox 335 301 611 228 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 335 301 image memory text2 0 335 352 image memory text1 0 335 415 MoveCtrl 1 493 410 0 0 * eff.exe a03_329a.gif 472 434 0 1 0 15 15 15 eff.exe a03_329b.gif 82 103 0 1 0 15 15 15 * You begin by using the New Obj isave 220 240 517 189 text1 textbox 220 240 517 189 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_330a.gif 2 452 0 1 0 15 15 15 * Next you click the Macro Names isave 220 194 517 138 text2 growbox 220 194 517 138 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_331a.gif 42 406 0 1 0 15 15 15 eff.exe a03_331b.gif 243 433 0 1 0 15 15 15 eff.exe a03_331c.gif 243 114 0 1 0 15 15 15 * This inserts a Macro Name colu isave 220 143 517 70 text3 growbox 220 143 517 70 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** * A macro group can contain a si notebox 233 350 498 ** image memory text3 0 220 143 image memory text2 0 220 194 image memory text1 0 220 240 * eff.exe a03_333a.gif 0 459 0 1 0 15 15 15 * You type ^5 in the Macro Name isave 20 132 343 81 text1 textbox 20 132 343 81 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** * If you assign a set of (one or notebox 40 276 331 ** eff.exe a03_335a.gif 0 459 0 1 0 15 15 15 * Then you select the macro acti isave 20 86 343 30 text2 growbox 20 86 343 30 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 20 86 image memory text1 0 20 132 * eff.exe a03_336a.gif 11 434 0 1 0 15 15 15 eff.exe a03_336b.gif 13 176 0 1 0 15 15 15 * When you have chosen the actio isave 213 425 618 357 text1 textbox 213 425 618 357 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** * In this case the required argu notebox 278 335 561 ** eff.exe a03_338a.gif 31 415 0 1 0 15 15 15 * ≥ Object Name - Customer isave 213 362 618 306 text2 growbox 213 362 618 306 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 213 362 image memory text1 0 213 425 * eff.exe a03_339a.gif 50 385 0 1 0 15 15 15 eff.exe a03_339b.gif 152 431 0 1 0 15 15 15 eff.exe a03_339c.gif 132 178 0 1 0 15 15 15 * ≥ Record - Previou isave 19 144 367 76 text1 textbox 19 144 367 76 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_340a.gif 216 373 0 1 0 15 15 15 eff.exe a03_340b.gif 401 397 0 1 0 15 15 15 eff.exe a03_340c.gif 362 178 0 1 0 15 15 15 * ≥ Offset - isave 19 81 367 42 text2 growbox 19 81 367 42 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 19 81 image memory text1 0 19 144 * eff.exe a03_341a.gif 11 434 0 1 0 15 15 15 eff.exe a03_341b.gif 152 455 0 1 0 15 15 15 eff.exe a03_341c.gif 132 135 0 1 0 15 15 15 * The name you enter at the Macr isave 35 206 342 155 text1 textbox 35 206 342 155 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_342a.gif 2 455 0 1 0 15 15 15 * You must call the macro group isave 35 160 342 104 text2 growbox 35 160 342 104 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_343a.gif 134 398 0 1 0 15 15 15 eff.exe a03_343b.gif 292 334 0 1 0 15 15 15 eff.exe a03_343c.gif 134 178 0 1 0 15 15 15 eff.exe a03_343d.gif 362 178 0 1 0 15 15 15 * You click OK to save the macro isave 35 109 342 53 text3 growbox 35 109 342 53 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 35 109 image memory text2 0 35 160 image memory text1 0 35 206 * * Topic: Hands-on: Modifying a macro group Topic No.: 4 **** * * Topic: Hands-on: Modifying a macro group Topic No.: 4 **** SimScrn 3 8 9 ********************************* MoveCtrl 1 493 426 0 0 * Suppose you wish to use the ke isave 94 288 316 220 text1 textbox 94 288 316 220 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** * You can do this by adding a ma isave 94 225 316 152 text2 growbox 94 225 316 152 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 * image memory text2 0 94 225 image memory text1 0 94 288 * exercise 02 2 120 70 task 2 0102 317 300 320 7 50 67 5 5 * pause 1 1 1 1 1 1 1 1 * * * * Topic: Hands-on: Modifying a macro group Topic No.: 4 **** * SimScrn 3 9 9 ********************************* * MoveCtrl 1 493 426 0 0 * task 3 0103 317 300 320 7 50 67 5 5 * pause 1 1 1 1 1 1 1 1 *