Search results for query: *

Hi, I have an A2010 db front end, linked to a SQL Server 2005 back end. I'm seeing multiple crashes and can't see where the problem lies. Usual crash point is opening the database with the followign details: Problem Event Name: APPCRASH Application Name: MSACCESS.EXE Application Version...

Hi, I have a simple data copy operation (running via Access VBA): appXL.ActiveWorkbook.Sheets(strSourceTab).UsedRange.Select appXL.Selection.Copy appXL.Workbooks(strWorkingFileName).Activate appXL.Workbooks(strWorkingFileName).Worksheets(1).Activate...

Hi, I'm trying to process a csv export file but have a bit of a problem. It's been exported in Excel csv format. When I view the file in Excel, it splits into its constituent columns just fine. However, when I look at the file using notepad there dont appear to any row terminators at all...

Hi, Does anyone know how I can set a two colour gradient fill in E2007 VBA? I output a report that has 2 rectangles as the background. Left rectangle is gradient filled colour 1 to colour 2. Right rectangle is gradient filled colour 2 to colour 3. The shapes are place dnext to each other to...

Hi, I'm having an issue with the following procedure: Public Sub Exec_Asynch_ADO(strProcName As String, intScenarioId As Integer) Dim conn As ADODB.Connection Dim cmd As ADODB.Command Dim strConn As String ' revised connection string post deployment strConn = "Provider=sqloledb;" & _...

Hi, I'm having an issue with the following procedure: Public Sub Exec_Asynch_ADO(strProcName As String, intScenarioId As Integer) Dim conn As ADODB.Connection Dim cmd As ADODB.Command Dim strConn As String ' revised connection string post deployment strConn = "Provider=sqloledb;" & _...

Hi, Any ideas why this doesn't work? With cmd .Style = msoButtonIconAndCaption .Caption = "Collapse to Here" .FaceId = 188 .OnAction = "'Collapse_To_Node""" & CStr(nd.Key) & """'" End With The proc doesn't even fire on...

Hello, Does anyone know a way I can access voting responses to an Outlook message by looking at the sent item? By this I mean getting the data from the 'response' column on the 'tracking' tab of the original message sent. I can happily get the info by looping through all of the individual...

Hi, I'm running an archiving process from an Access database which uses a Shell object to compress files to a new location. I want to suppress the standard Windows "Compressing..." message so that the process just runs unobtrusively in the background. This article suggest that all I need to...

Hi, I'm being affected by a problem with setting a ComboBox ListFillRange to a named range on a different worksheet. When I set the zoom value to anything non-standard (i.e. does not appear in the drop down list from the toolbar) and select an item I get the dreaded "Not enough system...

Hi, I have a workbook I'm using to produce a set of reports. Each report has various sheets each with various charts. I have a combo box, which allows me to select criteria for the report. This applies filters to hidden sheets, which makes my 'new' report. The new report is then saved to a new...

Hi, Does anyone know why updating the page setup for Excel worksheets via VBA from an Access module is so slow? As an example, all I'm setting is: with appXL ... 'select the data range .Cells(1 + frm.txtAddRows.Value, 1 + frm.txtAddCols.Value).Select .Range(appXL.Selection...

Hi, Is there anyone out there with any experience of Audit Control Language, specifically of executing and controlling via API from VBA? Cheers, Iain

Hi, I'd like to be able to grab the contents of the currently active query window in an instance of SQL Server 2005 (Management Studio) from an Access VBA procedure. Can anyone help? I'd originally posted this on the vba forum btw, advised to post it here... Thanks, Iain

Hi, I'd like to be able to grab the contents of the currently active query window in an instance of SQL Server 2005 (Management Studio). Can anyone help? Thanks, Iain

Hi, I'd like to create a chart that has placeholders on the axis for zero value categories. Probably best if I give an example: Let's say I have this pivot table, based on a column with values in it that I'm counting: Count of X-Value X-Value Total 1 9 2 16 3 18 5 25 6 29 7 1 10 2 I want...

Hi, I'm trying to find out how to check if a cell is large enough to completely display its contents. If it's not I need to autofit the row, otherwise just set the row height to 18. Can anyone help? Thanks, Iain

Hi there, Does anyone have any suggested reading/websites/tutorials for an SQL Server newbie? Thanks, Iain

Hi, I have a calculated control sitting on a UI form that tells the user how many subform Contact (people) records exist for the current mainform Company record. The ControlSource is: ="Contact Information - " & [Forms]![frmMain]![subfrmContacts].Form.Recordset.RecordCount &...

Hi, I'm trying to reference a form and subform recordset in a query. The form recordset is changed dynamically to allow users to 'filter' for certain sets of records. I want to be able to output the results of the filter to Excel, using a query/subquery, e.g. (air code) SELECT tbl1.x, tbl2.y...