Auto-increment using VBScript

CraigKornacki · March 31st, 2004, 05:41 PM

I use a product called OCR for Anydoc that uses VBScript to perform non-out-of-the-box database instructions.

What script could I write to make a number appear in a text input field from an Access database? This number would auto-increment each time the form was opened from a browser (tricky.)

One example script from the text is

If Text1.Value = False Then
    ConnectionObject.BeginInsertTransaction
    ConnectionObject.FieldValue (Text1) = Text1.Value
    ConnectionObject.ExecuteTransaction
End If

I don't understand the ConnectionObject portion and the software company won't describe it for me. I tried {odbc conn name}.{table name}.{fieldname}, but I get an error message.

Any suggestions or help would be great.

Ben Horne · April 6th, 2004, 02:17 PM

You may want to ask this in the appropriate forum

http://p2p.wrox.com/forum.asp?FORUM_ID=70

Quote:

quote:Originally posted by CraigKornacki
I use a product called OCR for Anydoc that uses VBScript to perform non-out-of-the-box database instructions.

What script could I write to make a number appear in a text input field from an Access database? This number would auto-increment each time the form was opened from a browser (tricky.)

One example script from the text is

If Text1.Value = False Then
    ConnectionObject.BeginInsertTransaction
    ConnectionObject.FieldValue (Text1) = Text1.Value
    ConnectionObject.ExecuteTransaction
End If

I don't understand the ConnectionObject portion and the software company won't describe it for me. I tried {odbc conn name}.{table name}.{fieldname}, but I get an error message.

Any suggestions or help would be great.

Ben Horne
Madison Area Technical College student
-------------------------
http://community.webshots.com/user/valerian114

Go there. I have a lot of awesome photos that I rendered myself

"A Person Who Claims To Be A Flash Junkie Isn't Really A Flash Junkie Unless He Can Prove It"