Search:

Type: Posts; User: lizat; Keyword(s):

Page 1 of 20 1 2 3 4

Search: Search took 0.03 seconds.

  1. Replies
    0
    Views
    31

    Access 2013: What is a Lookup based on

    Dear Loungers,

    If I am developing an asp db. I will use a Lookup based on a reference table, my question is how is this implemented? If I have a regular relational db then the lookup is based on...
  2. Access 2013: changing field names when there are data macros

    Dear Loungers,

    I have used Access for years but now have Access2013 and some things have changed. I have an asp db.

    I wanted to change the field names. there is a data macro which sets one of...
  3. hmmm... It is odd that the space before is OK...

    hmmm...
    It is odd that the space before is OK for teh first instance but then not honoured, I have no idea why this is a problem.

    As far as the shading goes my solution thus far matches what...
  4. Replies
    2
    Views
    347

    Yes exactly, each of my pages is in a section of...

    Yes exactly, each of my pages is in a section of it's own and the layut is defined as vertically centred. It always used to work.????
  5. Thread: Word 2013; Lists

    by lizat
    Replies
    2
    Views
    331

    Hi Charles, Thank you, I know this well and...

    Hi Charles,

    Thank you, I know this well and should have reread my own notes based on Shauna's excellent guide. I have been away from Word for a while and so got a bit rusty. I thought I was doing...
  6. Replies
    2
    Views
    347

    Word 2013: Vertical Centring

    Dear Loungers,

    I cannot always get a section to vertically centre. Does anyone have an idea what might prevent this?

    I have one document, the first page is vertically centred successfully. Most...
  7. Thread: Word 2013; Lists

    by lizat
    Replies
    2
    Views
    331

    Word 2013; Lists

    Dear Loungers,

    Every now and then i tidy my templates and try again to understand and make list templates work consistently. Possibly a lost cause, but I live in hope!

    What is annoying me at...
  8. Word 2013: Heading with large top margin not honoured after the first

    Dear Loungers,

    I have a Heading 1 style defined with a large space before it - about 6 cms. I have two problems:


    The first instance of the style the large top margin is Ok. All subsequent...
  9. Replies
    6
    Views
    1,162

    Can't get to Network Properties

    Hi Loungers,

    In the good old days (never thought I'd refer to W7 that way!) If you click the network icon in systray and right click one of the networks you can get to the Properties for the...
  10. Hi Steve, The formatting was originally set-up...

    Hi Steve,

    The formatting was originally set-up manually and worked, the macro was developed based on recording and some tweaks to optimise it a little. The rules look correct after the macro has...
  11. Hi Steve, Yes, I understand what it is doing....

    Hi Steve,

    Yes, I understand what it is doing. And although I know that is how it behaves it isn't the way most people (in mt experience) want Excel to behave. Hence the macro. The behaviour it...
  12. Hi Steve, The original problem is that,...

    Hi Steve,

    The original problem is that, depending how things are inserted or amended, you can end up with a huge number of conditional format rules that amount to the right thing - effected by a...
  13. VBA for conditional formatting, but not applied dynamically

    Dear loungers,

    Since Excel doesn't maintain conditional formatting as I would like - once new rows and columns are added it becomes unmanageable - I have got into the habit of having a bit of VBA...
  14. Replies
    1
    Views
    304

    display conditional formatting rules

    Hi Loungers,

    Does anyone know how to display the current set of conditional formatting? I don't want to go to the cells I want a listing of all the conditional formatting rules. I am sure I have...
  15. Replies
    2
    Views
    271

    OK found it, the format wasn't set to a number...

    OK found it, the format wasn't set to a number for the cell
  16. Replies
    2
    Views
    271

    Using NOW or TODAY with DATEDIF

    Dear loungers,

    If I use this formula:

    =-(DATEDIF(TODAY(), GoLiveStartDate,"D")+3)/7

    I get an endless row of hashes. The same with NOW() instead of TODAY().
    The formula works with a cell...
  17. Backup & Restore personal application settings

    Dear Loungers,

    At work they are planning to replace my PC. I am a little nervous of this since I seem to know more that the guys doing the upgrade - they are just running a build script. And...
  18. Excel 2010 here's the sheet, nothing...

    Excel 2010

    here's the sheet, nothing confidential in it the Summary tab is the problem and it's working off the Config progress tab

    Thank you...................... liz
  19. Thank you Rory. However, my sheet has two...

    Thank you Rory.

    However, my sheet has two pivot tables, they work from the same data just showing slightly different summaries. The Column heading will be identical.
    So, following your idea I had...
  20. Pivot table - getting all possible column headings

    Dear loungers,

    My pivot table uses a status column to create the column headings. This status column is driven by a drop-down based on a list. I want the pivot tabel to have all possible status...
  21. Replies
    15
    Views
    577

    fab!!!!

    fab!!!!
  22. Replies
    15
    Views
    577

    This seems to work: ...

    This seems to work:

    =INDEX(E4:E200,COUNTA(E4:E200),1)

    It doesn't cope if the sequence has cells with blank in them but is good enough
  23. Replies
    15
    Views
    577

    Hi Maud, Thank you. The reason i wanted a...

    Hi Maud,

    Thank you.

    The reason i wanted a formula is that i need to do it several times and display the result in a cell at the top of the column in question. I am trying it with index and...
  24. Replies
    15
    Views
    577

    Find last value in a column

    Dear Loungers,

    just can't get the formula right for this.

    I have a column with values in, they are numbers but in the form of text i.e. with a single quotation mark in front like this '0.01. I...
  25. Replies
    3
    Views
    375

    Hi Retired Geek, How annoying obvious! I was...

    Hi Retired Geek,

    How annoying obvious! I was going blind having stared at it for so long. Thank you

    My problem then was how to wrap INDIRECT around it, I had a problem with quotation marks....
Results 1 to 25 of 489
Page 1 of 20 1 2 3 4