Search results

  1. DickyP

    What's your best/worst joke?

    I don't know if the following (true) story counts as a joke but you either laugh or you cry! I'm in the poo. The wife started to re-arrange the shoe shelves in the hall and with much frustration told me my shoes we a nuisance as because they were so big they took up a lot of room. Being...
  2. DickyP

    Access Europe User Group - Wed 7 Jan: Spot the Difference – A new style MsgBox for Access (Neil Sargent)

    Thanks for trying to produce a variant that might suit me. It is, however, just that; a variant of the same thing. Obviously, things aren't going to change and I will have to live withe new version(which I still don 't like. ) I does, however, remain change for change's sake and is totally...
  3. DickyP

    Access Europe User Group - Wed 7 Jan: Spot the Difference – A new style MsgBox for Access (Neil Sargent)

    I will look at it when I get a decent internet connection back: ours has been dodgy in the extreme for the last few days with storms, gales, snow etc. Hopefully, I'll be able to do my my luddite thing. :) Mind you this change is a perfect example to MS doing the other thing Murphy warned...
  4. DickyP

    Access Europe User Group - Wed 7 Jan: Spot the Difference – A new style MsgBox for Access (Neil Sargent)

    I personally hate the new style message box! It provides nothing new and is much harder to read for people like me with weak, close-to eyesight
  5. 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...
  6. DickyP

    Auto Insurance

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

    Unaccounted change in new document

    You're right, of course - should be Selection.Copy :)
  8. 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...
  9. 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...
  10. 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...
  11. 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!)
  12. 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...
  13. 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...
  14. DickyP

    Technology a Two Edged Sword

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

    Having a brain cramp

    The REAL joy of programming.:)
  16. DickyP

    Having a brain cramp

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

    Solved Raised command buttons

    Thanks - I should have looked harder! but it doesn't actually help me as they are already 'off'.
  18. 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?
  19. 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