Recent content by mpdillon

tsuji, That was exactly what I needed. I didn't know about ChrW. I am on my way to work for another client now but will investigate more this evening. Where did you find the code &H2264 for the LE sign? Was it a web page? I ask because I would like to be able to look up other symbols. Does that...

tsuji, In HTML they are: LE Less Than or Equal To ≤ GT Greater Than or Equal To > chr is a Visaul basic function that returns the ASCII character of the number. The opposite function that gives the number of a character is Asc("="). That Asc function returns 61. The ASCII code for the...

I am using VB.net to read an XML file in to SQL server. I am using VBs XML parser to read nodes, elements, etc. When an element's value contains a LE symbol and I insert the string in SQL, the resultant SQL record contains an Equal sign and not an LE. I cannot examine the string for this...

I am working on a VB 6 app that will communicate with a third party server control. The server control wants inforamtion posted to it in the following format. http://SQL200:1000/cgi-bin/auth.cgi?ya_da_ya_da_ya sql2000 = local server's name "ya_da_ya_da_ya" = information to be posted. I have...

Stella704pl, You diagnosed it. Not shown in my code above was the phrase "Primary Key"(I created this post from memory the day after I had the problem.). When I remove the "Primary Key" phrase, everything works fine. Thank you for your effort. How did you get the detail for that message? PS...

Hi, I am having difuculty creating a new table in VB6. I am trying to create a Free table, with the following code. Create Table Combo (JobNo char(10), Phase char(10), CostCd Char(10)) When this is executed an error is returned. "Function not supported for non-.DBC..." (Not the exact verbage)...

Hi, Is there a simple way to sort the following User Defined Type on OrdNo? Public Type Orders OrdNo as String InvNo as string End Type Sub Main dim Order() as Orders ReDim Order(3) Order(0).OrdNo = "3" Order(0).InvNo = "556" Order(1).OrdNo = "1" Order(1).InvNo = "333" Order(2).OrdNo =...

First,First, I want to thank everyone for the clarity of their explanations. And as I expected you all knew what my problem was before I did. I will list what I found so others can use it for reference. The Class module in the ActiveX exe is call by the client program. In turn the Class module...

I may not understand your question. I close all connections and recordsets. I set them all to nothing. I hide all forms and set the forms equal to nothing. Is this what you mean by releasing objects? thanks, pat

Hi, I have written an ActiveX exe. It is used by another Standard exe and several other VBA applications. When the standard exe uses the AxtiveX exe over and over again, a "Run-time error '7';Out of memory" error occurs. Stepping through the program and watching the windows process monitor I...

Thanks for creating this post. I am having same difficulty. I created two pages, no frames. The first with a Next button and the second with a back button. When I try to navigate back to the first page from the second page, the Java script works great. The first page is displayed with all of...

I am trying to make the transition from VB6 to VB.Net and Windows forms to Web Forms. Could someone please show me how to change to a new web page when a button is pressed. After adding a button to a form, button1. I would like the button1_Click to advance to the next page, SecondPage.aspx. I...

Thanks, vb5prgrmr. I had been playing around with that before but could not get it to work. It is good to know that I was on the right track. However, I am still having dificulty. I get a error 430; Class does not support Automation or does not support expected interface. I searched on line for...

Hi, I am creating an ActiveX exe. Currently, I can only debug it by adding msgboxes, recompiling and running the calling application. Is there a better way? I would like to be able to step through the code of the ActiveX exe to see what is going on. thanks, pat

I always learn something when I post a question. Thanks John for your reply. Your reply almost does what I need. I have never seen the union command used so thanks much for the example. The 4__ would return anything with a 4 in the first space. What I need is it to return any string that has a 4...