Search results for query: *

I have a problem that I've been wrestling with... I get a number of large text files (variable number of files ranging in size from 30-50MB) from clients that I need to concatenate together. They're all in the same format, but they all have column headers in them, so I can't simply copy the...

I have some code that opens an Excel file, and among other things removes quotation marks from the file. I set display alerts to false, but when it doesn't find a quote, I still get a message box letting me know. Anyone have any ideas on how to suppress this? Here is a snippet of the code...

Can someone tell me why this line of code comes back with a Run-time error 1004 when I run it? It doesn't error out when I run it in the immediate window Sheets("Sales Index").Range(Cells(3, 56), Cells(Sheets("SalesIndex").Range("A2").SpecialCells(xlLastCell).Row, 107)).Select

I know how to assign a whole array to a range in Excel. Is there a way to assign a contiguos range of values within an array into a range of cells? I know that I can do it with a loop, but I'm wondering if I can do it in one line. Thanks, Chris P.S. I accidentally listed this in the MS...

I know how to assign a whole array to a range in Excel. Is there a way to assign a contiguos range of values within an array into a range of cells? I know that I can do it with a loop, but I'm wondering if I can do it in one line. Thanks, Chris

I keep getting a runtime error: The SELECT statement includes a reserved word or an argument name that is misspelled or missing, or the punctuation is incorrect. The query works fine if I paste it in Access, but won't work through ADO. I can't, for the life of me, figure out what the problem...

Can someone tell me why I get run-time error 3027: "Cannot update. Databae or object is read-only." when I run this code: DoCmd.TransferText acExportDelim, "Transaction Data Export Specification", _ "qry_TransactionTransformation", strPath & "TransactionTransformation", True but this works...

Anyone know if if there is an ADO equivalent to the Nz() funtion in Access. I have queries that work in Access that I reference through ADO, and they're not working. Anyone have any advice? I know I can use an IIF(IsNull([VALUE]),0,[VALUE]), but I'm hoping there is an easier way. Thanks, Chris

Anyone know how to easily check to see if the .execute method was successful after a user selects a file in a file dialog? If the user selects a file already opened, they can opt out of opening it, so the .show = false won't work (because the selected a file, but the failure comes on the open)...

I've been trying to use this, but I get no results in the concatenation. Here is my query syntax: SELECT Query4.Child, Concatenate("SELECT Family FROM Query3 WHERE Child =" & [Child]) AS WhereUsed FROM Query4 GROUP BY Query4.Child HAVING (((Query4.Child) Like "010*")); Here are some records...

I can't figure out how to handle pictures in Excel. I've inserted two bitmaps into a worksheet, and I'd like to for one to be visible when a certain cell is >=x and make the other visible when that cell is <x. I know how to test the cells and all, and I figured that I'd use the activate event...

I have a textbox that I'm using for the user to filter records in a form. As they type, I want to filter the recordset, so I use the onchange event to refresh the data. But, when I do form comes back with all of the text in the textbox highlited. Any way to prevent this or to get the cursor...

I've specified data from a record selected in a subform as a parameter in one of my queries. When I launch the form from my switchboard, the query can't find the data item, but when I launch the form from the database window, the query works fine. Any one have any idea what is going on here...

I found this article on another site: http://www.access-programmers.co.uk/forums/archive/index.php/t-68645.html We're using SQL Server 2002 and Access 2000. Does anyone know if there are updated ODBC drivers that support BigInt and other field types? Thanks, Chris

I've been charged with PMing a small SQL Db project, but I don't have any experience with Db development on anyting but Dbs for myself. Do any of you folks have something (even just an old project plan) that will cover most of the items in a Db project? Please feel free to email me: phaedrus...

OK... I can't figure this out! I get very different results when I run this vs. when I step through this. When I run it, all the array formulas are written-over, but when I step through, the If/Then in the middle of this loop works appropriately. Can anyone see how this could be? Chris...

I'm trying to write formulas to the same cell of multiple worksheets, but having troubles. I do this: SheetsArray "GIRLS", "MENS", "MATERNITY", "WOMENS", "BOYS", "ACCESS", "BABY", "LARGE", "MISC")).Select And then this: Selection.Range(formulaAddress).FormulaArray =...

Is there something I don't know about successive select methods? The following code yields an unexpected (at least I don't expect it) result: Sheet.Activate Columns("A:X").Select Selection.EntireColumn.Hidden = False Do While ColumnsToHide(arraycount)...

Please help! I can't figure out why this isn't working for me. Everytime I run this line, I get a "Run-time error '1004': Unable to set the FormulaArray property of the Range class". The formula works when I enter it by hand. What's up? Thanks, Chris Here is the line of code...

Does anyone know how to do a count unique on a field? For instance, if I had the following records: John, blue, rectangle, square, long John, blue, rectangle, square, short John, blue, triangle, equilateral, n/a John, blue, triangle, non-equi, tall I'd like a query that results in John...