home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Programming Tool Box
/
SIMS_2.iso
/
access
/
diverses
/
acc_ep
/
acc_epb2.txt
< prev
Wrap
Text File
|
1995-02-27
|
2KB
|
33 lines
--------------------------------------------------------
Error Procedure Builder 2 - By Brian A. Manlove 70543,1420
--------------------------------------------------------
EPB2 is the new brother of EPB, a previous version which did not
insert an error MsgBox. EPB2 will give you a generic Error MsgBox.
Like EPB, EPB2 is a standard Windows Recorder macro. It quickly inserts generic
error trapping with a generic Error MsgBox into any Access sub procedure. I have
tried some of the "wizards" that are out there, and I think this macro works
better, faster, and best of all, it won't add another megabyte or two of
"maybe-it-might-work" crap on your HD.
------------------
Instructions:
------------------
Unzip EPB2 to the directory of your choice (mine is in my ACCESS directory).
Launch the Windows Recorder application and open the ACC_EPB2.REC file. Get
back into your Access program. Select the property you want to add code for,
select the Code Builder, and after the sub procedure heading is displayed,
press the "hot key(s)" to run the macro. If you do run EPB2 with some code
you have already entered, you might have to cut and paste your code
back into the proper position, which is usually before the "Exit_Blah_De_Dah:"
line.
The EPB2 macro has been pre-set to playback ONLY to MS Access. I used the
CTRL/ALT/HOME "hot key" as the trigger to run EPB2 - you may want to change
this to your own preferred keystroke sequence.
Happy Procedure Error Trapping!!