Recent content by CptnMike

Got it figured out... It's the language used in Access 2000 that's been the problem. Golom, you had it almost right. and Glasgow is close. Chiph, yours worked up until the parameters, then crapped on me. Anyway, the one that worked is: "SELECT Name, Address FROM Customers WHERE PhoneNum ='" +...

Ok, I tried it, and it didn't work...:( So I'm going to give you the whole thing the way I'm trying to get it to work, and you can tell me I'm nuts. Private Sub Command4_Click() Dim cn As ADODB.Connection Dim rs As ADODB.Recordset Set cn = New ADODB.Connection cn.Open "provider =...

I have looked and tried everything I could find in the books, but I can't find any way to pass a VB6 variable to a SQL statement. I'm getting a lot of syntax errors. Example: "SELECT Name, Address FROM Customers WHERE PhoneNum =" "'"Text1.Text"'"" I'm hoping to fill some other Textboxes on...

Hey Terry! Thanks! No, that won't work for what I am trying, but just glancing thru it, it will work perfectly for another project!! Copied it off and I'll go thru it tomorrow....... Thanks again!

Thanks again Zemp! That will give me some more reading besides the 9 books I already have on it! I've found that sometimes the tutorials on the web are better explained than in the tech books. That's a thought Patrick....I may try working something like that. When I use a simple bind on the...

Ok John, Thanks. I started with the listbox and thought there must be a better way. Guess not. I'm kinda new at this database thing so, back to the books!

Thanks for the reply Zemp, but the "list1.clear" does not work on a DBlist or a DBCombo box. They are just too easy to use, but almost worthless if you cant clear them out.

I can populate the DBList box, but how do you clear it for use with another list?

Finally got it to work by installing service pack 4 then installing service pack 5. Also, found another fix in MSDN Knowledge Base Article - 252438. That one did the job.

I have downloaded vs6sp5vb from microsoft presuming that its the service pack 5. Also have downloaded Jet40sp7_wme file and the Mdac 2.8 file. Everything has been installed except, the set-up for service pac 5 told me that it couldn't install the file MSINET.ocx because it was in use at the...

I have VB6, and am working on a business program where I need to use databases. I also have Access 2000 which I am trying to use. Why is it when I build a database in Access 2000, my VB6 refuses to open it? The Data Manager gives me an "Unrecognized Format" error.

Ken, Oh, that was just too simple. Thanks a lot! Worked like I wanted it to! Thanks again! Mike

Sorry to bother, but I'm a beginner in programming, and I can not find how to add all records of a single field to form a total, and display it in a text box. Example: record1.myfield + record2.myfield + record3.myfield etc. Thanks Mike