Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.03 seconds.

  1. ACCESS 2013: web db vs desktop db vs SharePoint Lists

    Dear Loungers,

    i have been debating the best way of using these tools. My questions are

    My understanding is that performance-wise Access web is better than a collection of Sharepoint lists, is...
  2. Replies
    1
    Views
    157

    ACCESS 2013 asp: comboboxes in datasheets

    Is is possble to have comboboxes in datasheets as one can in a desktop db? And is so how?

    Thank you.................. liz
  3. Access 2013: change font size for web datasheet

    Dear loungers,

    I am just starting to play with Access 2013 web db. I want the datasheet font to be smaller. I think it may be CSS but can't work it out.

    Can anyone advise me?

    Thank...
  4. Replies
    0
    Views
    153

    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...
  5. 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...
  6. 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...
  7. Replies
    2
    Views
    435

    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.????
  8. Thread: Word 2013; Lists

    by lizat
    Replies
    2
    Views
    428

    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...
  9. Replies
    2
    Views
    435

    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...
  10. Thread: Word 2013; Lists

    by lizat
    Replies
    2
    Views
    428

    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...
  11. 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...
  12. Replies
    6
    Views
    1,763

    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...
  13. 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...
  14. 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...
  15. 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...
  16. 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...
  17. Replies
    1
    Views
    348

    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...
  18. Replies
    2
    Views
    303

    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
  19. Replies
    2
    Views
    303

    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...
  20. 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...
  21. 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
  22. 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...
  23. 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...
  24. Replies
    15
    Views
    673

    fab!!!!

    fab!!!!
  25. Replies
    15
    Views
    673

    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
Results 1 to 25 of 492
Page 1 of 20 1 2 3 4