|
Posted by: Ben on 2010-06-04, 23:55:57
How find the errors in access database VAb programing, which was already done? Firstly, so the we are clear, VBA can not see any data in your database it is a procedural language for manipulating objects within Access (or any other application). If you are referring to new reports being added which have VBA code attached and your are getting errors when running a report then you will need to debug them and step through the code to see which line(s) of code are causing offence. Proviiding you have access to the code, load the VBE (editor) by first being in the design view for a report (or any object). Press SHIFT + F11 to load the VBE window. Locate the procedure like when the report is opened or loaded and add a breakpoint on the first or line of code you wish to pause the procedure when running it again. Press the F9 function key where the insertion point is placed on the line of code (turns this line purple). Now run the procedure (F5 function key) and then when the procedure is paused on the breakpoint use the F8 function key to step one line at a trime into your executed code line and see what and where the error is really happening. To help with the debugging process you may want to use the Watch View and an Immediate Window view (CTRL + G) and use the '?' followed by a space and then the command you wish to test to view current values as a temporary output. Take the time to look up help on the VBE debugging tools to understand my comments further but I can not help you analyse the code without have access to your code! Hope this helped Ben Beitler |
