Search:

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

Page 1 of 10 1 2 3 4

Search: Search took 0.03 seconds.

  1. Replies
    5
    Views
    3,525

    enable drawing canvas

    You should enable the option to automatically create a drawing canvas.

    Cheers
    Geof
  2. Replies
    5
    Views
    3,525

    Grouping Office 2010

    Hi
    I am using office 2010 ..

    I still select multiple objects with the shift +click as I did.
    Then a right click and select grouping from the pop out menu.

    I have noticed that I cannot select...
  3. Hi Is there a reason you stopping you using...

    Hi

    Is there a reason you stopping you using the built in command Data>.Advanced Filter>

    In this way you would not need any code at all.
    The Criteria Region would have separate rows for each...
  4. Replies
    1
    Views
    594

    Use inputbox

    Hi
    This might be a pointer

    Sub pauseForName()
    dim sNewName as string
    sNewName = InputBox("Type new name")
    MsgBox sNewName
    End Sub

    There is still a bit of work to do.
  5. Replies
    13
    Views
    31,427

    Word Numbering

    Welcome to the weird wacky world of word outline numbering.
    You need to forget about direct formatting via Bullets & numberin dialog.

    Best I can do is direct you to an article by one of the Word...
  6. Hi I have heard of something similare once...

    Hi
    I have heard of something similare once before ..

    the cause was due to exceeeding a max allowable number of cell formats.

    At that time the user was in the habit of formatting entire...
  7. Replies
    6
    Views
    10,312

    Mixed Margins etc

    Hi Chuck
    Try beginning the section with the narrow margins with a continuous sectnbreak that follows immediately after the next page section break.


    next page sectn brk
    continuous sectn break...
  8. Replies
    2
    Views
    2,693

    Dates in Excel

    Hi
    In the screen capture C2 contains the formula
    =DATE(YEAR(A2),MONTH(A2)+1,0)-(MAX(0,WEEKDAY(DATE(YEAR(A2),MONTH(A2)+1,0),2)-5))

    D2 contains the formula...
  9. Replies
    2
    Views
    12,119

    Editing normal.dotm or normal.dot

    Hi

    Word 2007/2010
    Locate and edit normal.dotm to remove the text.
    Save and close

    Word 2003 or earlier
    Locate and edit normal.dot to remove the text.
    Save and close
  10. Replies
    5
    Views
    971

    recalculate with vba

    Hi

    Investigate the use of range.calculate.

    example: selection.calculate

    Hope it helps

    Geof
  11. Celle addressing

    Hi there
    You are having an issue with Absolute vs Relative cell addressing.
    The format with $ symbol is known as Absolute.
    This is a critical concept to master.

    Edit a formula.
    Place cursor...
  12. Replies
    3
    Views
    1,494

    Nested docVariable fields

    Hi Ceceilia
    I created a form with a text box to store the path to the pic.
    Important that I included the double slash in pathname

    The OK click created the docVariable and populated it with...
  13. Utility acc codes

    Hi
    Adding hypens
    The addition of a hyphen creates a mix of alphabetic and numeric characters. ie. the entry is no longer a number so no arithmetic.

    This would be analogous to a phone number...
  14. Replies
    4
    Views
    775

    Did you solve your dilemma?

    Hi
    Did you manage to do this?
    Geof
  15. Replies
    1
    Views
    2,579

    Save File Options

    Hi

    To choose the default file format go to

    FILE>>Options>>Save


    Cheers
    Geof
  16. Replies
    6
    Views
    1,160

    Hi Thanks for the feedback. We have both...

    Hi
    Thanks for the feedback.
    We have both learned something. I enjoy reading the posts and had forgotten about the Autoformat.
    I love this lounge for that very reason.
    Lounge members have helped...
  17. Hi Sooze Shauna's site is an excellent...

    Hi Sooze

    Shauna's site is an excellent resource. Have a good look at her document on creating and linking levels to styles for numbered headings in 2010.

    I rarely base my documents on normal...
  18. Template Style 'No Spacing'

    Hi Sooze
    The sample text I used is based on a template which is not associated with my regular 'Normal.dotx' IT is a generic raw Word created template.

    The difference is in the line spacing
    ...
  19. Hi I achieved this somewhat differently. ...

    Hi

    I achieved this somewhat differently.

    A button click includes these lines of code

    sFile = get_docRepository & Forms!frmContactEdit!frmContactDocSub!DocFileName...
  20. Replies
    6
    Views
    1,753

    Hi I have just tried this on Access 2010 I...

    Hi
    I have just tried this on Access 2010
    I made a form containing 2 text fields
    I named one textDate and populated it with 2011
    Using the immediate window I typed
    ?...
  21. Replies
    4
    Views
    2,536

    Exporting Outlook to Access

    Hi Corden

    I assume that you have purposefully rejected option to export/archive using the inbuilt tools.

    Check this for some ideas http://support.microsoft.com/kb/290792

    Cheers
    Geof
  22. Replies
    2
    Views
    631

    Hi You might try and use the date function. ...

    Hi
    You might try and use the date function.

    In an adjacent col

    =date(cellRefContaining2005,1,1)

    Format the result as date.

    Cheers
  23. Thanks anyway. I guess I will do it the hard...

    Thanks anyway.
    I guess I will do it the hard way. Progressivley tighten security until common logons cant use it and then back off.

    G
  24. Replies
    5
    Views
    1,341

    Hi Dave Rado saved my hide years ago with his...

    Hi

    Dave Rado saved my hide years ago with his utility at his mvps site. This enabled backup and restore of autotext entries.

    http://word.mvps.org/faqs/customization/exportautocorrect.htm
    ...
  25. Replies
    5
    Views
    1,341

    Hi Chuck I remembered that autotext entries were...

    Hi Chuck
    I remembered that autotext entries were stored in .acl files as well as in normal. (Some bad experience losing some data when some staff migrated to office 2002 or 03 way back when ?)....
Results 1 to 25 of 241
Page 1 of 10 1 2 3 4