Recent content by DickyP

  1. DickyP

    Auto Insurance

    Bit a reach even for you Doc man: Britain didn't exist for 740 years after England came into being where we spoke English. That's only 80 odd years older than USA. Now (American) English and British (English) I can go with. Mind you, there is so much cross fertilisation between the two these...
  2. DickyP

    Auto Insurance

    Surely you're referring to American, not English. :)
  3. DickyP

    Unaccounted change in new document

    You're right, of course - should be Selection.Copy :)
  4. DickyP

    Unaccounted change in new document

    It's actually Application.Selection and it saves the Table that been selected. Within VBA in Word it is by definition the Application object if used without without a qualifier (or was). Application.Selection is actually the cursor position. And the code (without Application) is what is...
  5. DickyP

    Unaccounted change in new document

    In case anyone is actually interested (possibly/probably unlikely), Word Cut & Paste has changed. You now have to be much more specific. What used work in my scenario; - Tables(1).Select - Selection.save and then later move to the end of the document and then paste - Selection.EndKey...
  6. DickyP

    Unaccounted change in new document

    After a lot more investigation I have confirmed that cut & paste in Word *has* changed. I have a number of Word routines in both Word itself or using the Word object model from Acceee, where the template has a table which I copy, then after filing it move to the end of the document to new page...
  7. DickyP

    Unaccounted change in new document

    Copy and paste are definitely working differently when I select and copy a table, which now copies no formatting. The template/ macros still work perfectly in Word 2003 on my laptop. I am actually redesigning the template to do things differently (and if truth were told better!)
  8. DickyP

    Unaccounted change in new document

    I have a Word template that creates and fills several weeks of food menus. It has been working without problem in the same manner unchanged since 2017, until this week when it has suddenly started to throw up an error - "Command not available" on the VBA line "Selection.paste". Does anyone...
  9. DickyP

    How to test whether a form is opened as hidden?

    This usage of the form as a settings source is probably not an ideal solution to your task as described. I would create a separate class which is instantantiated at start up and can be referenced as class.property. You can then have your form for making the changes 'on-the-fly'. In reality you...
  10. DickyP

    Technology a Two Edged Sword

    I agree with the graffito - " Murphy was an optimist".
  11. DickyP

    Having a brain cramp

    The REAL joy of programming.:)
  12. DickyP

    Having a brain cramp

    Admit it - you love these problems really!
  13. DickyP

    Solved Raised command buttons

    Thanks - I should have looked harder! but it doesn't actually help me as they are already 'off'.
  14. DickyP

    Solved Raised command buttons

    I too am on Office 21 but under File >> Options >> Current Database >> Ribbon & Toolbars I have no 'Use Windows Themed Controls' option. Any ideas?
  15. DickyP

    Auto Insurance

    I'm just amazed at how expensive car insurance seems to be in the USA, compared to the UK. I realize, of course, that what is posted here and my own experience are a mere microcosm of the whole picture.
Back
Top Bottom