Recent content by dvrobin

I have an application with a splash screen. My splash screen consists primarily of a background image. The form is sized correctly so that the image displays nicely. I have to keep the form at a certain size so the user won't see the image tiling on the background (there is no stretch...

TommieB, Thanks for coming back here with the answer. I was having the same problem, and couldn't find the solution anywhere. It's rare that I see someone come back and post the answer to their own question. You got a star from me! Dave Robinder, MCSD Consultant Booz Allen Hamilton...

Why not use a NZ (Null to Zero) function to wrap around your field value? Like this: Public Function NZ(SomeValue as Variant, Optional DefaultValue as Variant = "") as Variant If IsNull(SomeValue) Then NZ = DefaultValue Else NZ = SomeValue End If End Function This...

The FileScriptingObject has the method you need. I wrap it in a help function as follows: Public Function FileExists(strFileName As String) As Boolean Dim fs As New FileSystemObject FileExists = fs.FileExists(strFileName) Set fs = Nothing End Function Dave Robinder, MCSD...

I like to use an additional boolean variable in my method call. Either that or return a boolean from the function. In either case, the boolean indicates whether the array has data in it. Private Sub Test() dim ar() as variant dim booHasBounds as boolean booHasBounds = MyProc(ar) If...

It seems to me that ADO is not actually supporting XML, but rather a subset of XML that follows strict schema guidelines. Unfortunately, that's next to worthless for my purposes. Is there an easy way to programmatically transform the XML I receive (in the example above) and make it look like...

I can't believe that I can't find this information anywhere. Hopefully someone has run into this before. I have an xml string that I want to convert to an ADO recordset, so I can use a hierarchical flexgrid for display. The file is of the following format: <Top_Root> <Field1> value1...

Does anyone know where I might be able to get a compiled version of cURL for AIX? I have visited the cURL website at curl.haxx.se, but they only have source code for AIX available. I need to deploy cURL for a site I am building that will be on an AIX system. I don't, however, have access to...

Does anyone know if there is a way to better format the body of the NewMail object? I'm sending a generated email to customers to pick up a download at web address. The web address is rather lengthy (Better than 100 characters!). The problem is that the link gets chopped at around 75...

MTS is not used under Windows 2000. Try changing your references to utilize COM+. Dave Robinder, MCSD Programmer Colorado DataScapes Colorado Springs, CO (719) 328-1111

You had me stumped for a minute. When you get the error, it's highlighting the wrong item. The offending item is actually &quot;rstFields(&quot;street2&quot;) &quot;. Notice that you're missing a &quot;.&quot; between rst and Fields. Dave Robinder, MCSD Programmer Colorado DataScapes...

The best way I can think of is to delete the field and add it back. You will have to reestablish any relationships and sync up any related tables. Dave Robinder, MCSD Programmer Colorado DataScapes Colorado Springs, CO (719) 328-1111

That should cause a JavaScript error. The !Doctype tag is a meta tag that describes the document. It shouldn't be placed between script tags. Try removing the script tags and see if that helps your problem. I'd need to see more of the code to begin guessing at any other issues. Dave...

You could try &quot;Select count(*) from mytable&quot;. Alternatively, you can access the recordcount using the ADO Recordset object's recordcount property. You need to use a client-side cursor that is not forward-only in order to do this. In your report, you should also be able to add a...

Since CINT returns an integer value, it can only handle a number up to 32,767. If your value will be greater than that, then you will have an overflow problem. I'm not sure if CLNG works in SQL, but that would be the VB equivalent of what you probably need. CLNG will convert to long which can...