Search results for query: *

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.

Is it with ChckMate as well or a different control?

Ha, nevermind, I figured out what the source of my grief was... It seemed that me calling a control resize upon form load was causing a HUGE load on the machine at once...and with Win9x the memory resource managemnet SUX... anywho, I changed the form to call the resize only when needed, and...

Hey, Jeez, I have been having some MAD issues lately. Damned Win9x...haha Anywho, here is my issue: OS: Win9x Ram/Processor: Doesn't seem to make a difference All the errors I get happen on the same line of code, and that is when I try and SHOW a particular form. Error: Error 372 Failed...

Nevermind, I have fixed the issue. It appered to be caused by a file that was shared by many apps. I revised the file and all is well now! Thanks for the help

I tried all of the above and I kept seeing the same symptoms. Thusly, I removed all versions of MDAC and Jet, rebooted (Being a Win9x environment), then reinstalled MDAC 2.5 sp3, which contails Jet, and JRO... This seemed to help as everything is working now... However, Any other...