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...

Elise, Does this then change the default printer for the pc? Thanks

Hummm.....I keep getting an automation error??

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...

Never Mind, I figured it out. Basically I'm not only new to coding, I'm new to typing as well. Plain & simple, typo on my part......Thanks for the help and putting up with my questions.

Based on what vbajock started this is what I have: Function1DB1() Dim ReturnValue As Boolean Set db2= New Access.Application db2.OpenCurrentDatabase (strDBName) on error goto err_h ReturnValue = db2.Run("function2DB2",parameters1&2) (I never get here) Just goes to the error If ReturnValue=...

Ok, I was incorrect in saying that. I'm not having errors, just not able to tell function 1 in db1 that function 2 in db2 has completed successfully or failed. How would I send some type of return result back to function1 in db1? Thanks

Ok, That's not how I was doing it, but that works just as nicely, however Now I'm back to the original issue of being able to produce a result back in function 1 of database 1? Thanks , this is getting pretty good!!

Hey Jamie, yes, I think I'm already doing that , this is my call: function2.Run("functionname", parameter, parameter). function2 <-->here represents my new access application with path. So is it correct to use the Run command, or should I be using something else? Thanks for all the comments.

Would it still work if I'm calling from one database to another? Also you don't think it has anything to do with the automation call? Thanks, this is very helpful.

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...

darn, my only choice is the external file. I can't put "fname, First_Name, FirstN" = strnames in to a variable? Const TheNames As String = strnames?

is there a way to have my case Case "fname", "First_Name", "FirstN" set up in an external file, and use a variable there? Case strWhatever then in an external file Firstname = "fname", "First_Name", "FirstN" in the assumption that there will need to be another version of first name added to...

darn, thought it was too easy to be true........ what about that vba idea you mentioned? how would I flip through that?

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...

Great, thanks, I ended figuring out the write to FSO late last night. But you have helped me a great deal. Thanks so much!!

first let me apologize for my lack of detail in my question. Next let me say that I appreciate any thought's you might have. What I meant by my question was that I noticed that your creating a FabricatedRS, I'm hoping I can do the same with data from excel. I need to be able to pull data from an...

How can I use this same code and populate the rs with excel data?

linking isn't an option as I need to create the rs on the fly because this is part of a larger solution. Just a small mod in a rather large app. thanks

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.