Search results for query: *

I am trying to get the average of a field called 'score' which contains values to 1 decimal place (eg 421.2, 593.6, 648.5). When I do this with a single SELECT query, the resulting average score values are unrounded (up to as many as 26 decimal places). But when I do this in a union query...

Is there any way to stop Microsoft Access from auto-formatting the SQL text? Specifically, I like to arrange my SQL text with blank lines and spaces to make it easier to read, but after saving it and re-opening it, the extra lines and spaces have been removed. For example... the following SQL...

Hi, I have a POP3 email account (A) set up in Outlook and in the Send/Receive settings I have removed the tick from the box "Send mail items". I also have a Microsoft Exchange Server account (B) set up in Outlook with Send enabled. Whenever Outlook does an automatic (or manual) send/receive...

Is there any way to create an instance of the Excel 2007 application using VBA in Excel 2003? That is, if I have a workbook open in Excel 2003, can I use VBA in that workbook to run Excel 2007 and manipulate a worksheet? I tried using: Dim xl2007 As Excel.Application Set xl2007 =...

I have an Excel pivot table using an Access table as the external data source. In the Access table a particular numeric field (Field1) has many null values. In the pivot table, I have added a calculated field called "Upper" with the formula being Field1 + Field2. If the Field1 value is...

I have two tables in an Access database which are identical in structure (ie same fields, data types etc), but Table1 contains 'preliminary' data, and Table2 contains 'final' data. I have a number of Excel workbooks containing pivot tables that all use Table1 as their data source. Is there any...

A couple of days ago, I placed a workbook in the XLSTART folder so it would open as soon as Excel opens. The workbook's Open event had code which shuts the computer (windows) down. I did this because I wanted an automatic way to shut down the pc while I was sleeping - another application was...

Hi, I have a number of mdi files that were created when I had Microsoft Office 2003. I now have Office 2007 with Microsoft Office Document Imaging installed, but when I open the MDI files they are full of strange unrecognisable symbols. The files should display music symbols and notes, but...

Hi, I have a macro that tries to refresh pivot caches that have their BackgroundQuery property set to True. The reason for refreshing them in the background is because I want other code to run while the pivot caches are being refreshed (they take a long time). The first pivot cache begins to...

Hi, Every time I try to insert an ActiveX control (eg command button) from the control toolbox onto an Excel worksheet, I get the error "Cannot Insert Object". I've spent two hours searching the internet for a solution and nothing seems to help. I thought I may need to register an ocx file...

Hi, Every time I try to insert an ActiveX control (eg command button) from the control toolbox onto an Excel worksheet, I get the error "Cannot Insert Object". I've spent two hours searching the internet for a solution and nothing seems to help. I thought I may need to register an ocx file...

Ever since the company I work for upgraded it's computers to Windows XP, I occasionally get the following error when running a macro that involves Microsoft Excel and Extra Personal Client: 'The instruction at "0x61a95009" referenced memory at "0x6050d9a0". The memory could not be "read". Click...

I need to reference a workbook that is open on the desktop, but the path is unknown. Is there anyway to use the GetObject to reference a workbook based on it's name instead of the full path? The macro can't do this by looking through the Workbooks collection because the open workbook is...

I'm trying to find a way to convert columns of numbers in text format to numbers in number format in code. Manually this is quite easy - I just highlight the column/s, click the smart tag on the first one, and click "convert to number" which affects all cells in the selected range. I thought I...

Hi guys, This problem of mine is driving me nuts, and I'm hoping someone can help! I'm trying to display lists of information in a message box (to enable the user to visually check what is about to be entered), formatting the information so that the 'columns' line up with each other, but I...

Hi all... Can anyone tell me how to escape or break out of a running macro in Extra! Personal Client? A few times I've been caught out with running a macro that ended up being caught in a never-ending loop - I tried Ctrl-Break and Escape with no success, and I ended up having to use Task Manager...

Hello.... I'm not sure how to word this exactly, but I'm trying to find out how to call and run a sub procedure from within the main sub of the macro being run. Below is a very simplistic version of what I want to achieve, but the 'Call' line doesn't do anything, and I'm not sure what I need to...

Hi guys... this is my first post here, and just wondering if you can help me with a problem. I'm wanting to have a macro act as soon as a string (or character) on the screen changes. Similar to the WaitForString concept, but rather than waiting for a particular string, I want it to wait until...