Search results

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!

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.

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.

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

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...

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

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.

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.

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.

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.

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

Yes - b***y autocomplete!

If you use regular expressions you can easily cater for multilingual instances.

Whilst I sympathise the real question is are these files in a standard format? If so then manipulation in text is possibly long winded but only needs defining once. And it's the way it should be done! I agree with your final remark!! I personally would probably do it using regular...

Rule 1 - never process csv files in Excel. Rule 2 - repeat Rule 1. Always manipulate csv files as text!

Glad someone asked this before me. Discovered (eventually) that it is a hindi word, having found no trace of it in either theOED or Webster. I've learned something!:)

I only meant that the settings had been changed: not the other problems of my original query ( thank goodness). I was just expressing my annoyance.

Happened again yesterday - windows updated and the VPN settings put to on again!

I obviously didn't explain myself properly! The VBA IDE is common across all Office applications and it's the references dialog itself (which uses the underlying MSForms technology) that is causing the problem. The MSForms.dll is just the entry points for the technology and the dialog can't...

What I worked out years ago was although Access doesn't use MSForms directly there references to bits of it which it does use so as soon as you open any form those are in memory 'in use'.