Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. NewCoder2

    ADO & Query help

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

    choosing a specific printer for reports

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

    Numbering Rows in my result set

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

    Numbering Rows in my result set

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

    I'm Sure I just missed something??

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

    I'm Sure I just missed something??

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

    I'm Sure I just missed something??

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

    I'm Sure I just missed something??

    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!!
  9. NewCoder2

    I'm Sure I just missed something??

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

    I'm Sure I just missed something??

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

    I'm Sure I just missed something??

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

    Query Help

    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?
  13. NewCoder2

    Query Help

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

    Query Help

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

    Query Help

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

    How to add records to a temporary table object in memory...?

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

    How to add records to a temporary table object in memory...?

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

    How to add records to a temporary table object in memory...?

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

    Excel Data to record set

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

    Excel Data to record set

    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.

Part and Inventory Search

Back
Top