watch code as it is accessing the record

  • Thread starter Thread starter Stephen sjw_ost
  • Start date Start date
S

Stephen sjw_ost

I am useing SHELL to access the cmd prompt to send pop-up messages in Net
Send to my phone agents with in my company. It loops thru the table where I
have there ID listed untill it finishes with all of the IDs.
Is there a way for me to step thru the loop and see what ID is being access
from the table as the code is being worked? Maybe in the immediate window?
 
Yes. You could place a STOP statement or set a breakpoint where you want
things to stop for you to snoop around and then use F8 to step through the
code.

Setting a breakpoint
http://www.techonthenet.com/access/tutorials/vbadebug/debug02.php

Setting a watch variable
http://bytes.com/topic/access/insights/738849-debugging-vba-2g-watch-pane

Also, once the code was STOPPED you should be able to snoop around the
variables using the debug window. For example if you set a variable to a
records primary key as in ID = rs("PrimaryKey"), you could type DEBUG.PRINT
ID in the debug window to see what the value is or DEBUG.PRINT
rs("PrimaryKey"). Setting a watch allows you to literally watch whatever
variable you've setup.
 
Back
Top