Recent content by deej

  1. D

    Solved: Excel: Advanced Conditional Formatting

    PS: example attached (I hope) D
  2. D

    Solved: Excel: Advanced Conditional Formatting

    Hello again Yes - this is just what I thought you were asking. Try: copy my formula. Highlight the cells formatting is to be applied to. Go to the Conditional Formatting window. For Condition 1 select 'Formula Is' from the drop-down. Paste my formula into the formula box. Click the...
  3. D

    Solved: Excel: Advanced Conditional Formatting

    Not sure why that strange grinning face icon has appeared in my post! Formula should read =AND(COUNTA(C$3:C$400)>0,ISBLANK(D$3$400)) of course. D
  4. D

    Solved: Excel: Advanced Conditional Formatting

    Hi Try this formula: =AND(COUNTA(C$3:C$400)>0,ISBLANK(D$3:D$400)) You need to use the $ in front of the row numbers, otherwise the row numbers in the range will be incremented as the formula is copied down and the range will change at each row. It worked for me anyway! I did...
  5. D

    Solved: Random Numbers - Excel ??

    Simple is often best! Hopefully that fits the bill for you. As a side issue: are you aware that random numbers are regenerated every time the worksheet is recalculated? That means every time you change the contents of any cell, unless you have the calculation option set to manual (in which...
  6. D

    Solved: Random Numbers - Excel ??

    Well that should generate a new random number whenever the worksheet is recalculated. Press key F9 to recalculate. If you really want to generate a new random number when you (quote) "press the 'enter' or any other key" you will probably have to add a little bit of VBA to the worksheet...
  7. D

    Duplication in report result

    PS: this is equivalent to setting 'Unique Values' to yes - as OBP suggests. Deej
  8. D

    Duplication in report result

    Hi Try using SELECT DISTINCT - should get rid of duplicate lines of output.
  9. D

    Access database lock files - can they be switched off????

    You can't do away with the lock file - it's an essential part of using Access in multi user mode. OBP is correct - you can set the default opening mode to 'Shared' or 'Exclusive' in Tools>Options>Advanced Tab. If it's set to Exclusive then the database is locked against other users opening...
  10. D

    Solved: Access SQL Statement puzzler

    That's me to a 'T'!
  11. D

    Solved: auto numbering in Access reports

    Hi Lyas Not sure if this is what you're looking for: the following is taken from Access help (amazingly): Number each detail record in a report: Open the report in Design view. Add a text box to the detail section. To display the property sheet, make sure the text box is...
  12. D

    Solved: Access SQL Statement puzzler

    Happens to me all the time - can't see the wood for the trees! Deej
  13. D

    Solved: Access SQL Statement puzzler

    Hi Chris Try substituting <> 'Error' for <>"Error". The double quotes are terminating your SQL string prematurely. Deej
  14. D

    How to un-hide hidden folders

    >> I think after a virus problem, the folders option has been deleted from the Tools Menu & also frpom the Control Panel. >> probably for good reason, but may have been an oversight when setting some other options to improve security after the virus attack. Suggest you consult your system...
  15. D

    Access 2000 Error msg making db navigation difficult.

    Hello Sophia Are you able to provide a print of the table definition? It might show something that will help identify why it's behaving this way. In the database window: use menu option 'Tools ... Analyze ... Documenter' to print the table definition. Select the table name and use the...
Top