Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. TomSnider

    Using Count(*) on an existing recordset in VB

    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
  2. TomSnider

    Using Count(*) on an existing recordset in VB

    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...
  3. TomSnider

    Using Count(*) on an existing recordset in VB

    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
  4. TomSnider

    record locking with ADO

    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...
  5. TomSnider

    record locking with ADO

    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...
  6. TomSnider

    linking to database images....

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

    linking to database images....

    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...
  8. TomSnider

    using LIKE in WHERE clause

    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
  9. TomSnider

    using LIKE in WHERE clause

    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...
  10. TomSnider

    Withevents question

    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.
  11. TomSnider

    using LIKE in WHERE clause

    ...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 "SM" in it. However, each time I use...
  12. TomSnider

    create database with ADO

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

    create database with ADO

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

    create database with ADO

    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...
  15. TomSnider

    How to print data to a check

    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...
  16. TomSnider

    What is an alternative to Access

    Michael, Thanks again for the info.
  17. TomSnider

    256 byte limit on SQL strings

    Thanks much for the help. I will go ahead and change this app to use ADO....it should not be a big deal....here goes
  18. TomSnider

    256 byte limit on SQL strings

    I've hesitated to make the jump to ADO, because I was worried about the app running on older WIN98 machines. I don't know if they all have to have updated MS software or not. Do I have any worries on that regard?
  19. TomSnider

    256 byte limit on SQL strings

    I am starting a new thread on the problem of a string being truncated to 256 chars when used in an 'opendataset' method. I really need to find out how to get a string longer than 256 to be processed. I have a database DB, a recordset RS and a string sSQL. sSQL is assigned from a multi-line text...
  20. TomSnider

    What is an alternative to Access

    Thanks Michael. You are correct...it is much easier to blame another person's code rather than check for bugaboos in your own code. I'm comforted to hear that Access is stronger than I've read on various forums. What kind of application was running on the 75 concurrent stations? Was is...

Part and Inventory Search

Back
Top