Recent content by TomSnider

I don't know if store procedures are allowed in MySQL, but that is a great idea to check out. Much thanks again. Tom Snider

Thanks for the response. I did not think it was possible, but I was just hoping for some magic..... I am connected to a MySQL database and using a static cursor, but the .recordcount property gives me a -1 always....I have just started using MySQL, so it very well could be some foul up on my...

I have created a recordset, rsItems, from an SQL statement in ADO. Is there a way to use that recordset as the table in another SQL statement....? Like "Select Count(*) from rsItems;".....? Any direction will be appreciated. Tom Snider

Thanks Chip and Ruairi. The .requery did the trick regarding refreshing the recordset. And the problem about continuing to get an error after the first 'lock' error...was due to my not doing a .cancelupdate before any other operation on the recordset. Anyway, thanks for the responses, I really...

Has this topic, "Record locking in ADO", been discussed recently? I tried to search for it, but.....well you know. Anyway, I have a multiuser application using optimistic locking. I have placed error trapping code in the 'save' process to check for locking errors, and it correctly...

Thanks Herman. I'll search for it. Tom Snider

Can I tack a graphics question on this thread, please? I have written a project where people are tracked by lots of different attributes....including a picture or two. I am using ADO, but my controls are unbound. I figure I will use an Image control to store the picture on the form. And I know...

Ok, I totally lied. I checked my code and I was still using the '*' instead of the '%' in my sql string. I feel bad for crying like a baby.....but, like I said, I am not proud....my bad.....onward and upward...until the next hurdle.... Tom Snider San Antonio, Texas

I think I am using the correct ANSI syntax. I have tried the '*' as well as the '%' and I get no records selected in either case. I have read through 3 books on JET SQL and have looked for hours on the web....and every thing I see is exactly what I am doing. The sql statement I referenced...

you just will not have access to any of the events of the object you are creating.....there are some handy events for recordsets and such.

I am using Access 2000 with VB6 and I am trying to use the LIKE operator....and it is not working for me. The sql statement is: "SELECT lastname, firstname from PERSONS WHERE lastname like '*SM*'" I was expecting the results to include any record with 'lastname' having the string...

Thank Herman, I'll try it out. Tom Snider

I really meant to type 'CreateDataBase' instead of 'OpenDataBase'. Sorry for the confusion.

I want to use code to create a new Access Database. I know how to do this using DAO object, but I am now using ADO and cannot see how to accomplish this task. In DAO I would just use a 'set myDB = OpenDatabase(DBName, true)' and then I could create the tables using SQL statements. How do I do...

Use the VB help index to lookup Printer Object. When you choose that category, you will see an item that talks about how to use the Printer Object. It is actually very simple. The Printer object has a bunch of properties like pagewidth, pageheight, currentY, currentX, and many others that allow...