Search results for query: *

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

Thanks, will do.

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

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

;)

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

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

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

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

duh, helps if I'd stopped debugging.

My tools>reference is greyed out. :/

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.

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

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

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?

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

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

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

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.

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