Search results

I was able to figure out how to inject a variable into the WHERE clause of this ODBC connection/query This seems to build the connection and query all into the same string, but I stepped through it and it does work. any ideas how to sort this mis-mash out into inteligable sections. It almost...

Well, I tried it and again, no joy. Same exact error. I'll find it hard to believe if this is not possible. Is anybody willing to try and create a pair of files and see if they can make it work? In the interest of full disclosure, I was able to record a macro in the XLSM that does seem to...

sigh... Yep, already tried that too. no joy. same error... (note: Microsoft ActiveX Data Objects 6.0 Library)

I have another thread here: http://www.access-programmers.co.uk/forums/showthread.php?t=254429 Please excuse me if this seems to be a duplicate thread, but I fear the other one may be taken too literally as being specific to the connection method there described by the existing VBA provided...

I have tried that connection string already as the ACE Extended properties are not hard to find on the internet. but I'm thinking it may not be the connection string (could be wrong though). Are you able to create a set of files through which you can successfully open a connection? I've found...

pr2-eugin, thanks, but no joy. Same exact error...

I am trying to get data from one XLSX to an XLSM file. Running Excel 2010 (x86) on Windows 7 (x64) I have this connection string:Public adoConnection As ADODB.Connection Sub GetAgentRS() Set adoConnection = New ADODB.Connection adoConnection.ConnectionString =...

We have an automated tool to programmatically convert older files to newer formats. Among other things, the tool reads the VBA for various potential errors and deprecated methods, constants, etc. Bear in mind, all of these files with code are, in theory, fully functional in the older...

hmmm, just some idle thoughts: 1. the "summation query" Assuming this is a fixed query, are you sure the field name is correct? I'd think it would fire an error if not, but unless you've specfically changed it, it could be "SumOf..." 2. I like the suggestion to add a msgbox break so you can...

Before attempting #2 above, have you tried to designate a different view first, then after you're completed, setting the view to acViewPreview?

If you're not handy with SQL, you can build the appropriate query in Access using "Design View" and then save it with a name. Then you can load that query as a recordset in the VBA and process each record individually. Or, you can select "SQL View" and it will should you the straight up SQL...

Run-Time Error - Method - TRANSFERSPREADSHEET is a hidden method (updated) Hi All, This will probably seem like an odd or dumb question, but here it goes. Our team provides a service to bulk convert older format Office files to the new formats. When a conversion is completed, the automated...

hmmm, "merge" per se, is normally intended to output specific fields from multiple records into a standard document 9same document for that specific merge result. I'm guessing you probably aldarey know or have surmized this, hence the challenge trying to specifiy different destinations for the...

Thanks for the suggestion and it worked great. Don’t know why that method didn’t occur to me, but thanks for being there!

As I understsand it, technically, the trusted locations, documents, are supposed to refer to other data sources. Conceivably, one might be able to edit the registry to potentially add extensions to that process, but I have zero idea what key(s)... Unless you get creative with WSH I don't think...

I have a Form in Excel with a ComboBox. I need to populate it with year values. for example: 2010 2011 2013 2014 2015 Except really there needs to be 100 years to either side of the current year. Or, it could be between a range of years, say 1800 to 2100. The point here is, it is a crap load...

sigh.... PLEASE, read my post. I do not need to fix the problems. Even if I did, I ALREADY KNOW HOW TO FIX THEM. I even mentioned: ”(and this is what may seem odd to some here)” Sigh, I really need to get help to MANAGE THE ERROR, NOT FIX THE CAUSE OF IT. Now this thread is way off base…

jdraw & solo712, i really appreciate your effort and I am sure you sincerely intend to help me. Please sir, read my original post I know all about the deprecated features and mscomct2.ocx, and I already stated i know about the module corruption. But, I'm pretty sure I already articulated the...

The code is running within Excel 2010 and when the Access Object is called, it opens with Access 2010. i have just a normal On Error goto... setup I then read the err.number and process accordingly with several If/Then statements. HOWEVER, the point here is, I never hit that with the first...

Please read my post carefully. I know the users below were genuinely trying to assist, but trust me, I ALREADY KNOW HOW TO FIX THE CAUSES OF THE ERROR. The purpose of this thread is NOT to fix the causes, but to manage the ORIGINAL ACCESS error. I have a database that is being opened...