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!

  • Congratulations TouchToneTommy 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. devRyan

    Using In Statement in Where Clause Filtering

    I just wanted to report back that I found what I needed in faq183-5207, Option 4. Thanks for the guidance SQLSister, and excellent write-up ESqared. Ryan
  2. devRyan

    Using In Statement in Where Clause Filtering

    Hi All, I had a thread last year asking about how to do some more advanced filtering using the WHERE clause, as seen here: thread183-1366770. The result was the code here: Declare @Temp Table(UserName VarCHar(100), EyeColor VarChar(100), ShoeSize int) Insert Into @Temp Values('devRyan'...
  3. devRyan

    Parsing data rows to insert into a string

    Hi All, I was hoping you could help me with some questions I've got about SSIS/BID. I'm familiar with the workings of previous versions of DTS, but haven't yet dug into the newer implementation(SSIS/BID) in SS2005 so am having some difficulty determining how I need to go about getting done the...
  4. devRyan

    CreateTextFile with FSO

    I've used the FSO extensively with asp and vbs, but not with vba, so have never had to worry about the files type.
  5. devRyan

    CreateTextFile with FSO

    No, because I'm already pretty sure it's wrong. So what type should it be dimmed as?
  6. devRyan

    How do you export to Excel?

    Yeah, I tried that with no luck. Also, I read a few articles saying that it wasn't supported.
  7. devRyan

    CreateTextFile with FSO

    Hi All, Was hoping I could get some quick help. I'm trying to use the FSO to create a file, but can't seem to get it to work. Could someone please tell me what I'm doing wrong? I've got the Windows Scripting Library is referenced, so it recognizes my objects. Mainly though, I don't know what...
  8. devRyan

    error message - "user-defined type not defined"??

    duh, helps if I'd stopped debugging.
  9. devRyan

    error message - "user-defined type not defined"??

    My tools>reference is greyed out. :/
  10. devRyan

    error message - "user-defined type not defined"??

    I can see the FileDialog in my Object browser, but I can't seem to use it, and the reference option in tools is greyed out, so I can explore adding new references.
  11. devRyan

    error message - "user-defined type not defined"??

    How do you go about adding a library reference? I'm having this same problem with FileDialog.
  12. devRyan

    How do you export to Excel?

    Seems that DoCmd.TransferText won't accept a raw query string. Looks like I'll need to write to the file manually.
  13. devRyan

    How do you export to Excel?

    Is there anyway to do this with a query string and not an actual access stored query? Or anyway to dynamically update a stored query's contents?
  14. devRyan

    How do you export to Excel?

    lol, I just looked at that closer and realized is was the same thing. duh!
  15. devRyan

    How do you export to Excel?

    Nevermind, I found this, which does the job for me. Dim dlgSaveAs As FileDialog Set dlgSaveAs = Application.FileDialog(msoFileDialogSaveAs) dlgSaveAs.Show
  16. devRyan

    How do you export to Excel?

    Also, what version of Access are you using? My compiler is unaware of the Office object used to create the dialog.
  17. devRyan

    How do you export to Excel?

    Just curious. In looking at your usage of the CharCount function, why wouldn't you simply use inStr? Since you're not actually looking for a certain number of instances > 0.
  18. devRyan

    How do you export to Excel?

    Wonderful, Thanks. I'll let you know how it goes.

Part and Inventory Search

Back
Top