I have the following code which works great on all but 3 of our computers. On those computers it hangs indefinitely on the "set" command. It doesn't seem to matter what the default printer is that is selected or what user is logged into the PC.
Private Sub Form_Open(Cancel As Integer)
Dim...
Sweet - i have data in my table now! However instead of one row per block i'm getting one row per attribute (so I have 423 rows instead of 141). I had to change iCnt to integer to get it to run, but haven't changed anything else yet from what you suggested. I'll play around with it a bit...
YES! I had the table name right but decided to simplify it and get rid of the dash and it now works (at least back to how it worked before). So now I'm writing 141 blank rows to the table. Can I ask one last favor? This section needs to be modified to write out the first attribute in column...
Thanks Todd.
I just made those two changes in my code and when I run it, I think it gets farther because it seems to chew on things for a few seconds before I get the following message;
syntax error in FROM clause
When I hit debug it points me back to this line again
rstAttribs.Open , , , ...
I've absorbed the very helpful FAQ on here into a program I'm trying to write which would spit out the 3 attributes of a specific block (selected by the user) into a database table, one line per block. The code was to the point where I was getting one line per block, but the rows were blank...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.