Search results for query: *

Hello, This seems so simple but I cant figure it out for the life of me, I have a dropdown option list with 1-50 in it and I would like to update a variable named zQty with which number in the dropdown was selected by the user so I can use it when I am ready. Thanks and sorry if this is a dumb...

I need to make a literal out of a string. Example: *'Textfile Data reads as follows rst1.fields("test1") rst1.fields("test2") dim ary(2) open "c:\mydir\testfile.txt" for input as #1 for x=1 to 2 line Input #1, ary(x) Next x close #1 'all my ado connection stuff...

Ok theres got to be away to do this, reading from a text File and the lines read rst1.fields("test") rst1.fields("test2") I read these into an array then I do my select statement and Open from my sql database no problem but then how can i assign from my recordset that is...

Is there a way in Excel VBA to add the references I need loaded on the fly. I have done a few excel macros that talk to my sql databases but everytime I give it to someone I have to go load all the references by hand that the macro needs before it will run for them.. Sorry may be a simple...