Search results for query: *

I'm sure this is easy, I'm just not getting it though. All i want to do is use an ado connection in vba to create a record set based on my sql statement and then populate my variables with the data from the record set. But I don't know if this should be in a sub, or it's own function, and I...

How can I number rows/records in a record set? Meaning, I have : select id,name,address,phone# from blah,blah,blah where blah,blah,blah My results could look like this: ID Name Address Phone# 1 Ted 123anytown 1231231234 1 Ted 123anytown 1231231245 2 ED 789mystreet 5675675678...

Hey everyone, I know I should know this, but I'me either having a brain cramp or I've missed something. So..... I have a first function that calls a second function and in the second function I set a return value and send it back to the first function. <whew>.... So I know if the second function...

I'd like to know if it's possible to ave a query that looks for columns befor it actually selects? I might not be asking this correctly, so let me give an example. Select (fname or first_name) as FirstN Basically scan the dataset to see what the available columns are and then when I find a...

Is it possible to import excel data to a record set ? I saw this thread, http://www.tek-tips.com/viewthread.cfm?SQID=799692&SPID=705&newpid=705&page=1 Which is similar, but not quite the same. I'd like to be able to pull in my excel data in to a rs. Any Ideas would be greatly appreciated. Thanks.