Search results for query: *

Found the solution! Need to perform this operation before attempting the workbook close: Application.CutCopyMode = False Hope this ends up being of help to someone else.

I am opening up a second workbook from the main one, pasting some data over from its sheets and then closing. For some reason, the close is suddenly taking a rather long time (2 or 3 seconds). If I don't copy/paste, then it shuts down immediately. BTW--it's not the copy/paste that is taking...

this is not looking good. perhaps you could help me make this query faster then (i tried some of the logical things, but it just got slower): SELECT sex, reason, city, Sum(wgt) FROM (SELECT punterID, reason, city, Count(stayRslt) AS tripRslt FROM (SELECT tripID, city, Count(city) AS stayRslt...

i am in urgent need of some help. consider the following table: col1, col2, col3 1, 1.25, 1 1, 1.25, 2 1, 1.25, 2 2, 0.75, 1 2, 0.75, 1 2, 0.75, 1 3, 1.25, 1 3, 1.25, 1 3, 1.25, 1 3, 1.25, 2 from this "theoretical" SQL statement SELECT col3, IF(DISTINCT(col1),SUM(col2),SUM(0)) As mySum FROM...

before y'all take away my star, let me correct a mistake in what i posted above. the insert statement for MySQL should contain single-quotes around values only if they are text/string types. hence, my example, which has no such fields, should look like... INSERT INTO mytable (referral, event...

but unfortunately I can't change the php.ini because the MySQL db is on a hosted site i really doubt that your hosting service would offer MySQL without having set this up properly already. it's like not having DAO or ADO with an access database. Now I would like to have a php script which I...

flyover789. the php script is merely a file that sits on the web server and executes/runs when you point to it in your browser. to integrate this with VBA and launch automatically (once you have uploaded the data file), you run something like this from your windows app...

pookie62. here is a VERY simplified description of the core steps: 1) use VBA and DAO/ADO to construct file containing executable SQL strings, for example (note--it's not this simple, because you must format date fields properly and look for apostrophes and other bad stuff in text fields)...

here's something simple: SELECT [Name] & ' ' & [Adress] & ' ' & [SS #] & ' ' & [Date] & ' ' & [Sales] & ' ' & [Code] As myString start a new "query", choose "SQL view" from the menu and paste that in (i assume those are your field names--if not, you must edit what i've typed out)

akaivleaf. the fundamental problem is the GROUP/ORDER functions of SQL do not allow nesting of the TOP function. i have tried dozens of things and there is really no solution apart from a VBA loop and a query call for each incident. if you can post your table/field names, i could possibly...

1DMF just wanted to thank you for posting your code. what a headache this was going to be for me without your help. i am going to be uploading ascii files generated from a series of locations/clients (who are using an access database/interface) and then stuffing the data into mySQL on the...