Search results for query: *

THE QUESTION: Given a 1-dimensional array like: RowIdentifiers(1 To 10) As String And multiple two-dimension arrays, each in the form: ArrayA(1 To 50000, 1 To 100) As String Is there a short (1-line?) way to copy the contents of RowIdentifiers into ArrayA(1, 1-10). Something like: ArrayA(1...

I built out an Access 2003 database with a variety of forms/subforms, and then today I turned on user-level security. Now one of the subforms is "frozen" - it won't let me add new records or edit existing ones. I CAN go into the underlying table and edit values there directly. As far as I...

I have three tables - I'll call them TableA, TableB, and Corrections (the actual names and data would take too long to explain). TableA contains handkeyed data, including a "TableBValue1" field which is a foreign key used to link to TableB. The problem is that the data entry folks consistently...

The "Where" segment of the following query is not working. Specifically, while it does return rows that match, the result set also includes rows with totally different values in them ("2005", "2007", etc): SELECT SFMSPUSR_INDEX_NO.APPN_YEAR, SFMSPUSR_INDEX_NO.INDEX_NO...

Hey all, I've written some VBA in Excel that will generate about 100,000 rows of data, and I need these to end up in a new table in an existing Access database. Performance/speed is obviously a concern here. Conceptually, would it be best to load the rows into an ADO recordset as I'm looping...

I've used "Sheets(Array(" in the past to manipulate multiple sheets at once. I.e.: Sheets(Array("Sheet1", "Sheet2").Select I'd like to be able to do something similar with worksheet variables: Dim Sh3110 As Worksheet Set Sh3110 = "Worksheet Name" ... Sheets(Array(Sh3110, Sh3160, Sh3180...

Ok, I'm building a tech support issue tracker in Access 2003. Each ticket can be assigned a variety of statuses like "In Queue", "In Process", "Waiting For Customer Response", and "Completed". A ticket may get assigned the same status more than once (it might, for instance, be bounced back and...

BACKGROUND: I'm trying to learn how to use aggregate functions like COUNT and SUM in subqueries, and still running into issues. My current challenge: SETUP: I have table "PositionPlacements" containing fields "ID" (an AutoIncrement index), "PositionNumber" (alphanumeric)...

In Excel 2003: I have a line chart that uses 12 cells containing formulas as its data source. Each formula checks to see if there's data in a given column, then returns a SUBTOTAL() if so and a string ("No data yet") if not. (The columns the formulas look at contain actual expenses for a given...

This should be stupidly easy, but it isn't working. I want to copy a form and a query from one Access 2003 database to another. Each database has User-level security applied, and they use separate .mdw workgroup files. With both databases open (logged in to each as an admin/full permissions...

I have a workbook where every sheet contains a bunch of formulas. For some reason, the "LinkCells" range object in the following code frag stays at nothing for SOME of the sheets and not for others (so it fails the "If Not LinkCells Is Nothing" test on those sheets when it shouldn't). It seems...

I'm writing a query to compare two copies of a table for changes (each copy contains about 10,000 records). The unique key that I'm matching on is a combination of two fields. So... I wrote a query for each table that simply selects all fields from the table and adds a concatenated field to...

I'm writing a query to compare two copies of a table for changes (each copy contains about 10,000 records). The unique key that I'm matching on is a combination of two fields. So... I wrote a query for each table that simply selects all fields from the table and adds a concatenated field to...

I have an "Employees" table with a "SeatingZone" field where we record which of thousands of cubicle zones they sit in. Regular "snapshot" copies of this table are made for backup and historical purposes. I need to write a query which will compare the "Employees" table to one of it's backup...

Is it possible to display a live/linked view of a range of cells with an image control on an Excel form? When you copy a range on a sheet, then use "Paste Picture Link" to create an image control where .Formula is set to that range, you end up with a live "window" into those cell's contents on...

I'm sketching out a cool generic tool (probably destined to be an Add-In) that will create a report using data from other sheets in the current workbook. More detail on that in a minute, but first right to my question: For a given worksheet, how can I reliably identify the block of cells...

Is there a double-click event for the PivotChart view of a form? I want to open a detail report when the user double-clicks anywhere on the PivotChart. I tried sticking DoCmd.OpenReport stDocName, acPreview into the double-click event for the form, but that doesn't appear to fire when it's in...

Hey everyone, Question: Am I correct in observing that datasheet columns that are hidden don't show up in that form's PivotChart Field list? If so, is there a workaround that will let me use a query field in a PivotChart but have that field hidden in the corresponding datasheet view...

Ok I'm in the classic position of being asked to provide some quick-fixes for an Excel Hell not of my making. :^) Here's the situation: VBA is being used to chop a dataset into several hundred pieces which are each inserted into a separate workbook (all with an identical layout, number of rows...

I'm writing a quick 'n dirty workbook analyzer that flags potential design weaknesses (beyond what the built-in Formula Auditing tools provide). One of the things I want to do is loop through the formulas on a worksheet (I'm just using .SpecialCells(xlCellTypeFormulas)) to look for formulas...