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

    Identifying lowercase characters in a field

    Instead of looping through character by character you could define a VBA function as follows: Public Function HasLowerCase(strTest As String) As String If (0 = InStr(1, strTest, UCase(strTest), vbBinaryCompare)) Then HasLowerCase = "Y" Else HasLowerCase = "N" End If...
  2. cheerio

    Help making SQL run more efficiently

    It might be worth looking at temporary work tables. I will use pseudocode rather than pure SQL to illustrate the idea. INSERT INTO TEMP1 (fields F1,F2) FROM TEST unique combinations where K is 1 or 2 INSERT INTO TEMP2 (fields F1, F2, F3) FROM TEST, TEMP1 unique combinations for F1, F2, and the...
  3. cheerio

    Where and statement

    why is the third field prefixed with tbl which is not a table name or alias?
  4. cheerio

    VBA code running on it's own

    is not true. The code can become corrupted - see http://www.appspro.com/Utilities/CodeCleaner.htm
  5. cheerio

    Use VBA to open word or excel, but disable their features

    Does the user actually need to see the file? Otherwise you can stop the user from doing things by making the application invisible.
  6. cheerio

    Excel 2007 issue with hidden objects

    does this help: http://blogs.msdn.com/excel/archive/2009/01/30/hidden-and-invisible-objects.aspx
  7. cheerio

    Slow running Excel 2003 VBA

    I have some VBA that reformats a workbook of data downloaded from another system. There is only formatted data - no formulae. For two of my users the code was running very slowly - typically the task was taking a minute per sheet where I expected under 5 seconds per sheet. All users have...
  8. cheerio

    Excel Q

    Consider storing the workbook as a template?
  9. cheerio

    Call/execute an Excel macro from Access retrieve result back to Access

    In Excel go to a code window (Alt F11) and select the Object browser. Change the library dropdown to Excel and in the lower window click on application. To the right you will see Run. Right click on Run and select Help.
  10. cheerio

    Programmatically Installing and Referencing Solver.xla

    What value does the machine have for application.LibraryPath This defines where Excel will look for addins.
  11. cheerio

    MSQuery only returning partial fields

    This is a long shot. If there were control characters (like line feeds) in the backend data then just possibly MSQuery and Excel might see them differently. Seems unlikely but in the absence of other ideas ...
  12. cheerio

    Displaying the Custom Tab in File Properties in Excel

    This can easily be achieved by writing a simple VBA user defined function. For example, thisworkbook.CustomDocumentProperties("owner") would return the owner custom property. If you need help on VBA repost in VBA Visual Basic for Applications (Microsoft).
  13. cheerio

    Conditional format based on Cell contents

    Why not use an Excel Style - say called InputData - that has protection turned off and has shading turned on. Just format the data entry cells with that style.
  14. cheerio

    Lookup or equivalent based on 2 criteria

    A good explanation of use of SUMPRODUCT in this way can be found at http://www.xldynamic.com/source/xld.SUMPRODUCT.html
  15. cheerio

    Excel 2003 A comment that's not really a comment

    Data Validation - first tab Allow Any value - Second tab is where you put your message
  16. cheerio

    Can't delete Word Anchor

    An anchor simply shows which Word paragraph an object such as a picture or textbox is attached to. The only way to get rid of the anchor is to get rid of the object or to stop the object from floating by making it in-line.
  17. cheerio

    MS Office 2003 - WORD

    Word HAS to use a printer driver to render a page - clearly the page layout must change according to the printer settings - for example the difference between UK A4 paper and US legal. Even with the same paper size the number of characters that fit on a particular line can change if printer...
  18. cheerio

    SELECT with complex WHERE bombs with error code 0xc0000005

    Thanks for the star. The Access database engine is limited in the complexity of the queries it can handle. Sometimes a little lateral thinking is required to work within its limits. Mark's suggestion is another example - although the IN and EXISTS are logically equivalent one may be more...
  19. cheerio

    SELECT with complex WHERE bombs with error code 0xc0000005

    Some ideas: Where is the data - dbo_ usually comes from SQL server which handles complex queries better. If it is on a SQL Server you could use a Pass through query to get the server to do the work. Otherwise Access has to pull all the data back from the server so that it can test your...
  20. cheerio

    Excel - adding up more than 300 cells - getting an error message

    Excel help defines the format of the SUM function as SUM(number1, number2, ...) where the numbers go from 1 to 30. That is probably why having 102 arguments fails. Normally we are not limited to 30 numbers simply because each argument can be a range. Perhaps we use SUM so often we take it for...

Part and Inventory Search

Back
Top