Recent content by Chad123

Heya, I have a query that needs to be run several times – same query, variable data - on both an Access DB and SQL Server DB… This being said, would it be faster to run this query as a new recordset everytime, or to open the table in a recordset and rs.Filter everytime closing the recordset...

Hiya, I am using the Microsoft WebBrowser ActiveX control with the Adobe plugin (just need to install Adobe Acrobat) on my VB6 form. This works great, but when a user navigates to a PDF, the file is loaded with the Adobe toolbar within the WebBrowser control. Is there any way I can control...

Hiya, I am using the Microsoft WebBrowser ActiveX control with the Adobe plugin (just need to install Adobe Acrobat) on my VB6 form. This works great, but when a user navigates to a PDF, the file is loaded with the Adobe toolbar within the WebBrowser control. Is there any way I can control...

Hey, You may need to set your CommandTimeout to something like 150 or so. Your query/queries may be working hard and timing out. ex. cn.open <parameters> cn.CommandTimeout = 150 Chad

Hey, What you will need to do is requery your recordset. This will allow your recordset to grab the most recent data. I tend to do this at the beginning of each function when I have a global recordset open that is used in many places...It is easy, quick and adds database integrity to your...

If you have an array of command buttons, such as cmd(0), cmd(1) and cmd(2) then on the click event of the button you can grab the index and run your code for that button/index, like this: Private Sub cmb_Click(Index as Long) Select Case Index Case 0 'Insert cmd(0) code...

Hey, No problem Trudye. Glad to have aided in the functionality of your app... If you make it big, make sure to add me as a reference...lol Take care Chad

You are correct, except for one thing.... You do not place single quotes around values where the field has a numeric datatype... thusly, if sSID is 24365 then the query would look like such: sSQL = &quot;SELECT Fnamec, Lnamec, related, sex, dobc FROM HHold WHERE scccc_ID = 24365&quot; if the...

haha, you had some of it right.... You can only place values that match that fields datatype... if the field datatype is set to Number, then you can only place a numeric value in that field. In your query, you will never need single quotes aroung the field you are wanting, only the values you...

Ok, so the Value you wanna base your criteria on is a number, and the field datatype is a number? If so, then you do not need single quotes at all. However, if the value is a string, then you will need to encase the criteria like such: WHERE x = 'value' So yours (granted sSID is a string and...

no no, what I meant was this: If get1strec = &quot;False&quot; Then gaKey = cboHH.ItemData(cboHH.ListIndex) sSQL = &quot;SELECT Fnamec, Lnamec, related, sex, dobc&quot; sSQL = sSQL & &quot; FROM HHold&quot; sSQL = sSQL & &quot; WHERE scccc_ID = &quot; sSQL = sSQL &...

First of all, unless sSID is a number, then you will need to surround the value with single quotes(')... Also, the query that you have there WILL return all instances that meet those requirements. If you only want the One instance of it, then use DISTINCT... SELECT DISTINCT ....

I would use the UCase command. It can be used like such: Chr(KeyAscii)=UCase(Chr(KeyAscii))

Hey, I have always used VSFlexGrid 6, and have always used the 'Formatstring' command when creating column headers, but I have recently upgraded to VSFlexGrid 7. How can I create a column header with VSFlexGrid 7? Thanks, Chad

Do you get any other errors when this error occurs, or is there a sequence of errors? My issue ended up being something totally different from that of the original error.