Search results

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

I think I had this problem and solved it by removing the reference in code. I may even have done it by linking to the offending database from another. This is, however, dredging back in memory so I may be wrong.

One aside for this - I too use the MS Forms object - but , however, it does not work if the conrol you are copying from has data that has ever been encrypted. And no I don't know why!

Always used it, but spelled a one word -mollycoddled.

I have been following this thread with great interest as it seems to give a glance of where we may be going. However, I have three minor comments: 1. In the project life cycle coding is the simplest and most trivial of all the activates involved, so the saving may not be very much. We now...

Actually the character names is a myth. I got this, I might add, directly from John Ryan himself when he was signing my daughter's copy of 'Pugwash and the Buried Treasure'. He agreed that Master bates sounded bad the way Pugwash pronounced it but the Cabin boy was always Tom and there never...