Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. hotbread

    Union query causes average field decimals to be truncated or rounded

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

    Union query causes average field decimals to be truncated or rounded

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

    Microsoft Access SQL View - removes spaces, line breaks etc

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

    Outlook - unticked "Send mail items" but still tries to send

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

    Outlook - unticked "Send mail items" but still tries to send

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

    VBA - Create & manipulate new instance of Excel 2007 from within 2003

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

    VBA - Create & manipulate new instance of Excel 2007 from within 2003

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

    VBA - Create & manipulate new instance of Excel 2007 from within 2003

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

    Pivot Table Calculated Field - Null Values Treated as Zero

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

    Pivot Table Calculated Field - Null Values Treated as Zero

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

    Mayday! Excel shuts my computer down every time I open Excel.

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

    Change pivot table source data - Access table

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

    Mayday! Excel shuts my computer down every time I open Excel.

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

    Change pivot table source data - Access table

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

    Mayday! Excel shuts my computer down every time I open Excel.

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

    Mayday! Excel shuts my computer down every time I open Excel.

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

    MDI files display incorrectly - strange symbols

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

    MDI files display incorrectly - strange symbols

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

    Refresh Excel Pivot Tables in Background

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

    Refresh Excel Pivot Tables in Background

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

Part and Inventory Search

Back
Top