Search results for query: *

Hi, Is it possible to transfer data directly from a 2 dimensional array into an Access table, and back again? I've been opening the table as a recordset and adding each row in the array individually, but this takes forever as I have to update the recordset after each record is added... Thanks...

Hi, I'm trying to find a function which will allow me to vary the operator which is used based on a string in another cell i.e. - formula would be along these lines =function(A2,B2,C2) where A2 and B2 are values to which some operator is to be applied and C2 is some string which defines the...

Hi, I'm trying to use the Linest function to perform linear regression on a set of data. My known ys are in one row, and there are 65 values. I'm trying to fit those values against 27 known xs (ie - an array with 27 rows and 65 columns) however, I'm getting a #ref error. The error seems to go...

Hi, I have a problem with one of my Excel workbooks. Basically, I'm trying to change the formatting on one of my charts. On one of the data series, I change the data labels so the font is bold and 8 points, the border has a shadow and they are aligned below the line. This works fine, but when I...

Hi, I'm trying to create a summary query based on another query, but when I run it I get an Overflow error. The query I am trying to summarise has five fields - Marcom_ID, Call_Date, Calls_1, Calls_2, Calls_3. This query runs fine and returns about 55,000 rows. For the summary query, I link...

Hi, I'm trying to add a SheetBeforeDoubleClick event procedure to the ThisWorkbook module programatically, but when I try to call the CreateEventProc method, Excel crashes immediately. I have no idea what is causing this! Here's my code: Set vbCodeMod =...

Hi Everyone, I'm writing a procedure to create a workbook on demand. My problem is when I try to name a dynamic range programatically. This is the code I'm using: ThisWorkbook.Names.Add Name:="ProdLines", _...

Hi All, I'm trying to find a particular replication ID in a field, but I get the error message Run time error 3251 Operation not supported for this type of object Here is the code: Function find_record() As Boolean Dim db As Database Dim rsMaster As Recordset Set db = CurrentDb...

Hi Everyone, I have a function which I have written which allows a user to direct an Access database to an Excel file using the Dialogs(xlDialogOpen).show method. It returns the path to the file. Originally when I wrote it I had the problem that although the instance of Excel would show the...

Hi Everyone, I have a slight problem with an Access function I've written. The intention is to use the Excel Dialogs(xlDialogOpen).show method to allow the user to select the excel file from which they want to import data. Here is the code: Function getExcel(strName As String) As Boolean...

I'm sure I'm doing something really stupid here. I've created a form with a "Filters" section at the top. Basically there are four combo boxes here which the user can use to filter the data in the main section of the form. There's some VB code to create a SQL string based on the values...

Hi Everyone, I'm trying to speed up the calculation on a huge workbook I've inherited by converting it to use Dynamic Named Ranges. My problem is that on one sheet the data has gaps in it. As I understand it, the standard way to create a dynamic named range is to use Counta() in an Offset()...

I am trying to automate a report so that a it is sent to a mail list automatically every morning. Here is the relevant section of code: Set OlkApp = CreateObject("Outlook.Application") Set NewMail = OlkApp.CreateItem(olMailItem) Set Attachments = NewMail.Attachments...

I have a report in Excel which takes the form of a pivot table. The data source for the table is a query in an Access database. This has worked fine for several months, but today when I tried to refresh the table it caused Excel to crash. I then tried to rebuild the report in a fresh file. Query...

Hi, I'm trying to get data from a variant array (7 x ~8000) into an excel range. When I try to use the following code: .Range("A2").Resize(UBound(arrSchedule, 2), 7).Value = _WorksheetFunction.Transpose(arrSchedule) I get the error message "Type Mismatch". It runs ok if I...

Hi, I'm trying to get data from a number of linked excel tables into one access table. The reason I can't just use an append query is that the number and names of the linked tables will change regularly, and I would like to be able to just have something like "Data" at the end of each...