Search results

It is a common English reference to a wife. Most notably it was used by Horace Rumpole in the 'Rumpole of the Bailey' books by John Mortimer, and the TV programmes starring Leo McKern. Similar expressions to wives to be wary of are 'her indoors', 'the good lady' and 'better half'. And yes I...

I love this thread - bits I disagree with (I like ABBA, but don't like talk radio), bits that are irrelevant (we don't have satellite radio in UK), bits I find amusing eg unfortunate names (I worked with a colleague once whose name was Justin Casey) and things I find silly. I just wonder if...

Assuming the empty record you are seeing is in a list form all that's needed is a Form.requery.

If you read the gotchas documentation for FSO DriveType you'll find that Type = 2 is applied to portable drives that are only on the machine running the code, otherwise they are treated as Remote (Type=3). I don't know if this is having any effect in this case.

Almost as an aside if Kill doesn't work why not try Delete, or even better File System Object File.Delete? The ue of FSO especially gives full control of the process where you can check File exists to start with and then check that object has be released after delete.

This will be simple to resolve by using a RegEx if processing in VBA. For example: Public Function StripDSPT(pstrIn As String) As String Dim mtches As VBScript_RegExp_55.MatchCollection Static RE As New VBScript_RegExp_55.RegExp RE.Pattern = "DSPT\d{1,}" If...

As a follow up to my first reply I realised that you are missing something - a Variant array is not the same thing as an array of variants. I tried your code with a simple variant declaration and it works without problem. Assigning the result to a String array works because the returned array...

According to Microsoft you are. Which says explicitly that it returns a variant array. The substrings are of variant sub-type string. Where is your function throwing the error? I have literally hundreds of instances of assigning the results of Split (And Array) to variants, albeit NOT...

My normal response to these questions is to say use a RegEx, however in this example the suggestion to use Split is the perfect answer! To use a RegEx you'd need to know the complete range of values the 'skid' could be, or extract the second item from a set of matches which Split does far more...

To be pedantic strSplitArray should be dimmed as Variant as that's what Split returns, and good coding practice suggests the function should be returned explicitly as variant (which is what it returns by default). (But who cares if it works!) :)

.. and make sure you keep your coffee maker spotless.

I couldn't see why anyone would as their were little more than what a recordset does- you just had to do the navigation yourself. When I used them they were the only way to iterate the result of an SQL selection, hence my original query.

Thanks for this - by my estimation makes my fresh ground coffee at approx 5 cents a cup (4p) a steal compared to mokes123s choice. :D Mind you far better than instant at any price.

Just two questions - who or what is Bjs and how big and what is a K-Cup?

In my early days of using SQL on an IBM mainframe using PL/I in the 1980s an important element of its usage was SQL cursors. Recently looking at SQL Server whilst comparing different SQL flavours I noticed that SQL Server has cursor in its vocabulary. Does anyone actually use cursors in SQL...

Totally agree - and it's normally inferior quality - as Jerry Baldwin (one of the founders of Starbucks) said back in the 70s their target market wasn't serious coffee drinkers but instant coffee drinkers. As to price, one bag of top of the range coffee beans lasts me a week for less than the...

This thread has made me glad for the first time ever to have our dreafuĺy bloated and inefficient NHS!

Snap!

Before I start let me say I'm not trying to be clever or get at FuzMic, but just commenting on the the vicissitudes of IT security. I know the received knowledge advice is to never write down passwords, but you have to admit that it is virtually a necessity in this day and age (I counted mine...

To repeat - RegEx is much simpler than unnecessary VBA code. Examples below are the chars allowed in initial post but the Pattern is easily enhanced to add more characters. To just check and return true if has unwanted chars. Public Function HasNonChar(pstrIn As String) As Boolean...