Recent content by DickyP

  1. DickyP

    What's your best/worst joke?

    Don't worry - in the UK a dog licence was for a long time more expensive than a wedding licence. I can't say if it still is as I haven't had a dog and the last time I got married we 'd only had decimal currency for 4 years!
  2. DickyP

    The Garbage collector in VBA

    My comments were not just nostalgia - as Doc Man says - "I remember the "good old days" but I remember how much better they got.", but also serious. I'm lucky in that I don't really think about coding but just do it and seldom wonder what to do but just how to do it in the circumstances. The...
  3. DickyP

    The Garbage collector in VBA

    A fascinating thread and I'm pleased to report that I understand it well. What it does show is just how much those of a certain 'vintage' take for granted about basic IT knowledge. It brought back memories of working with 256 kb memory when 64kb was the maximum addressable using paging blocks...
  4. DickyP

    Batch file for updating local frontend Access database copy

    Couldn't endorse this recommendation more! Basically it is still good for everything except additional data sizes added and system limits. Wouldn't be without mine, which is the second edition. Mine cost £46.99 , which was lot of money in 2001 when I bought it!!
  5. DickyP

    Batch file for updating local frontend Access database copy

    Not a new idea - it was our way of rolling out updates in Access 2 days in the early 1990s. We kept an .ini file on the server with the current version number and if your FE was not the latest version you got message telling you to run the batch file and closed your FE.
  6. DickyP

    scanning documents

    Can't agree more with this. I literally have thousands of scanned attachments associated with my databases. They are, however, all separate files with paths stored in the databases.
  7. DickyP

    What's your best/worst joke?

    I did promise to shut up, but this reinforces my original point about quantity versus quality: how else do you explain the success of Starbucks (ugh).
  8. DickyP

    What's your best/worst joke?

    Scotland is part of the UK! I would say, however, that my remarks about drinkable do NOT include UK - our coffee in cafes, restaurants etc is generally dreadful! Italian portions are small but generally excellent. American portions are so large that only the first 10% is ever hot. Anyway I...
  9. DickyP

    What's your best/worst joke?

    At least that tablespoon is drinkable! 😀 And please don't lump all Europeans together - Europe's a continent and not a country.
  10. DickyP

    Hidden & little known features in VBA and the VBE

    Can't tell if you are agreeing with me, disagreeing with me, or just commenting! The point I was making is that the VB engine is the same whatever the application, it's just the embedding that changes.
  11. DickyP

    Hidden & little known features in VBA and the VBE

    There is really no difference between VB (pre .NET) and VBA: just in the past the versions lagged behind VB 5 / 6 etc before they got into Word, Excel, Access, Visio etc. As an MS Engineer said to me at their offices in Slough years back - they are all VBA but the Application that VB is...
  12. DickyP

    Hidden & little known features in VBA and the VBE

    Disagree - the feature was very useful at times when using customised Word documents. Multiple tab instances according to need were a deliberate part of the design. Is probably true in Access, however, where as the site shows most (many of the) problems raised are down to poor initial design...
  13. DickyP

    Hidden & little known features in VBA and the VBE

    I'd just like to thank Isladogs for starting this thread. Has been extremely useful, especially where it is reminding me of things I know but had forgotten!
  14. DickyP

    Hidden & little known features in VBA and the VBE

    I did know a lot more in the past, when the controls were essential. I usually found the problems when I just couldn't to with the controls in Access, what I could do in Word. As you say time to move on - and thank you for the info about using UserForms directly in Access - wish I known that...
  15. DickyP

    Hidden & little known features in VBA and the VBE

    Ah but they don't work fully - I suggest you do some extensive usage - some properties of the controls just aren't exposed. And your right - MS Forms Date picker has now gone (using Access 2021). Most of my usage was with 2003 and earlier and to be honest I just don't have the inclination...
Back
Top Bottom