Search results

  1. DickyP

    Access vs Comercially available databases

    Security is all relative. Access is weak but probably good enough in most situations, whereas keeping all your financial details on your mobile phone is never safe. As we were told at GCHQ - security doesn't need to be good - it needs to be good enough. At its simplest if your threat horizon...
  2. DickyP

    Access vs Comercially available databases

    Much of the discussion on this thread has been, quite sensibly, about security issues; however, the initial question was far more fundamental - can the commercial available offering do the job that the current system does? The simplest answere I'd give is to ask the people who use the current...
  3. DickyP

    Solved Getting old :-(

    I'm not doubting the technology- it's the people involved and their management of the systems to ensure the collection and retention.
  4. DickyP

    Solved Getting old :-(

    I wouldn't be so sure about that! I wrote an archive database for my wife's school as few years back. I could tell tell you the results for the public exams in 1910 and the records of school governors meeting for the first 70 years of the 20th century which were stored on paper,, but not...
  5. DickyP

    Solved Getting old :-(

    Don't give anyone advice, especially yourself! There is only one sensible bit of advice ever - "You are never too old for a teddybear"
  6. DickyP

    Solved Getting old :-(

    No - you're a youngster! All depends on your point of view.
  7. DickyP

    MVF Technical Discussion and Uses (If you plan to Use Them)

    A fascinating thread but nowhere have I seen anything that would ever encourage me to use a MVF instead of a properly normalised database. Obviously just my opinion. 🙂
  8. DickyP

    Another Loss of Some Note (or Notes)

    My favourite 'Lehrerism' remains: "Life is like a sewer - what you get out of it depends on what you put into it"
  9. DickyP

    Field to enter ONLY time.

    The point being covered here by some and ignored by some is that the date/time data type is exactly that and the time element is a date fraction. If all you are interested in is time values then it is the wrong data type!
  10. DickyP

    Is there a way of deleting all code lines beginning with debug.print across all modules using VBA?

    I agree good, clear tutorials - whereas the RegEx library often has examples of exactly what you are looking for. They are very different sorts of resource, which both have their place.
  11. DickyP

    Is there a way of deleting all code lines beginning with debug.print across all modules using VBA?

    This thread has gone long past where any contribution from me on RegEx makes any sense but for those who are scared of using Regular Expressions I recommend Reg Ex Library this is my go to when flumoxed.
  12. DickyP

    Import Text Files without .txt extension, Update Access Text Registry

    If you do your import in code it doesn't care about the extension.
  13. DickyP

    CoPilot removed by recent Windows update

    Everything about Copilot where it has intruded on me has been an absolute nuisance: it certainly doesn't write good English and tries to improve what has already been written (and altering it's meaning in the process). Doc-man's toolbox analogy works but my real tool box is organised by having...
  14. DickyP

    If ANY libraries are missing from the references, the date() function won't work.

    I reiterate my post above - this is a long-term, well known problem solved by resetting your references.
  15. DickyP

    If ANY libraries are missing from the references, the date() function won't work.

    This smacks of the problem that has been in Access since 97. It is the references getting out of kilter and neither recompiling nor compacting has any effect. Open your references dialog, add any reference. Compile then remove the new ref and compile again.
  16. DickyP

    Solved Tab in RTF control

    I seldom, if ever use the latest variant of the RTF format as I don't find it useful. Hence I cannot be certain what HTML tags work in it. If it's the full set you can use &enspc; (gives approx 2 spaces) or &emspc; (approx 4 spaces), or use the <pre> tag for pre-formatted text.
  17. DickyP

    Solved Tab in RTF control

    When I get home from holiday if nobody has mentioned how to do it by then I'll post how to disable mousescroll. In passing this is yet another example of MS removing functionality - the old RTF add-in actually used RTF and not HTML.
  18. DickyP

    Is there a way of deleting all code lines beginning with debug.print across all modules using VBA?

    Sorry about being facetious - I actually will help when I can get to my PC so I can test any code I suggest. Currently existing on my Andoid tablet whilst on holiday. Another week or so before we head for home.
  19. DickyP

    Is there a way of deleting all code lines beginning with debug.print across all modules using VBA?

    Thank you for the kind offer but I have for more important things to do like sweeping my belly button.
Back
Top Bottom