Using vb to read from the database table in turn all of the 121 X, Y, direction of connection, and then to the conditions in table 1 "direction of connection" for ID for this connection in the direction of the row data of X, Y coordinates, and then to the CAD drawing, code I can't figure out where there is a problem, please correct,

CodePudding user response:

Given you set up the wonderful work of the table name and field name, I'll give you a SQL pseudo code

Select table 121 X, table 121 Y where table 121=link direction table 1. ID

CodePudding user response:

Because this is used to test the database, really want to use the amount of data is a bit big, code has a problem, I don't convenient reference

CodePudding user response:

All commented On the Error Resume Next statement, running in the VBA IDE,
The error and then click the debugging, the cursor will stop error in the statement,
Or
In doubt may have a logical error statements in advance to set breakpoints, run through the breakpoint interrupt,

At this point can be used in the immediate window
? The variable name
Or
? The function name () function parameter
Or
Process (parameters)
Auxiliary debugging,