Search results for query: *

Hi, I need to Glueto a shape object based on criteria, i.e., shpobj.data1 = "Cleary OW". Is this possible? If so, what is the correct syntax? Thanks very much!

Hi, I'm retrieving data from a recordset in VB6 and writing it to an Excel spreadsheet. It is quite a long process and a simple hourglass might not be enough to make impatient user's wait until it's finished. Is there a way to lock the spreadsheet while the data is loading so the user's won't...

Thank you! That works perfectly... and thanks for the explanation, too. PT

Hi, I have a very complicated query (to me anyway!) that includes an aggregate function. It works fine when I Select only the authorpub.medlineauthorname, but when I include authorpub.rank I get the following error: runtime error 2147217887 "You tried to execute a query that does not...

I have vba code in my Access project that works fine until I import a new table or rename a table,then one procedure doesn't respond at all and the other produces very weird results. Both procedures utilize recordsets based on the tables and involve updates. The forms are not open when I import...

Oh, that's beautiful! It works great. Thanks! :-D

Hi, your reply was a great help. I don't get an error message anymore; however, fields like this (Acrylic Resins/adverse effects/*therapeutic use) still remain in the table?! I am having a hard time wrapping my brain around this. How can I get it to change the field to simply Acrylic Resins?

Hi, I'm trying to change fields in my table that have back slashes so that the backslash and everything after it are deleted. Ex. Coronary Artery Disease/Hypertension/Treatment would be changed to simply Coronary Artery Disease. I have used the following code successfully in a little SQL Tester...