Search results for query: *

Thanks for your reply AceMan! Following is the basic query structure: SELECT Code, Year, Gender AS Group, Avg(Score) AS Mean FROM Table1 GROUP BY Code, Year, Gender UNION ALL SELECT Code, Year, Ethnicity, Avg(Score) FROM Table1 GROUP BY Code, Year, Ethnicity UNION ALL SELECT Code, Year...

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...

Yes... I made sure the account in question was unchecked. I ended up creating a new user profile in Outlook with exactly the same email accounts, and the problem didn't return, so I guess the cause will remain a mystery. Cheers

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...

If I need to browse to it, what file should I be looking for, and where would it be located? I browsed to the EXCEL.EXE file in the Office12 folder, and tried to add it as a reference but nothing happened - no error, and it wasn't added to the list of references.

Ok... I've been able to achieve part of what I want, but still have a problem. The following code runs Excel 2007 from within Excel 2003, opens a workbook, then uses GetObject to reference the Excel 2007 application: Dim x7 As Excel.Application, x x = Shell("C:\Program Files\Microsoft...

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 =...

Thanks Skip... however, it's the first element in that formula that doesn't seem to work rather than the second - that is, Field1="" returns False even when the Field1 value is null. When the Field1 value is null, the calculated field formula always seems to recognise it as zero rather than...

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...

Thanks for the tip... when I ran my first search I didn't include hidden files/folders which is why it didn't find the file. But when I included hidden and system files/folders, I found both the second XLSTART folder and the problem file - deleted it and Excel now opens without shutting down...

OK... well, it took me a long time, but I eventually found a way to use the SourceData property to change from one table to another. It wasn't just read-only like I initially thought. Combined all elements of the array into one temporary string, replaced all instances of the Table1 reference...

Sorry I didn't realise there were more than one XLSTART folder per version of Office. In any case, I thought that if the file existed in any XLSTART folder it would have been found when I searched the entire computer for the filename. When I get home from work I'll have a look for other...

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...

I'm not sure what you mean. There are only two XLSTART folders on my computer that I'm aware of (for two office versions) - the Shutdown.xls workbook was only in one of the folders and has been deleted. I also did a search on the whole computer for the Shutdown.xls file after deleting it, and...

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...

Problem solved. I remembered today that I had Sibelius Scorch installed on my computer when I printed to MDI, so I installed it again and instantly the MDI files appeared correctly when opened. I thought MDI files were image files, and that if I printed to MDI the resulting files wouldn't...

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 Skip, I've tried putting the DoEvents statement in every position I can think of, but the same problem persists - it looks successful as the first cache begins to refresh, but it never completes refreshing the first cache and doesn't move to the next unless I break the code.

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...