Search results

'Dear' is a perfectly normal turn of phrase in English! Same as m'duck in Nottinghamshire, luv in various places and darling, mate etc. I also think that whole argument over the Canaries is fatuous .

Not only is data cleansing important but a data design is critical - understood that legacy data is a problem and a revised data design may not be possible, when a potentially complicated function may be the only remedy. Much, much to better to re-design the data if possible.

All in all I just wish Decimal was implemented as BCD as it was in PL/I. Each half bite was a number from 0 to 9.

Currency datatype which has certainly been in the JET/ACCESS DB Engine since to 90s and was defined as 8 bytes long in the oldest documentation I have (1998). The more controllable, but difficult to use JET/ACCESS DB Engine Decimal datatype has been around since at least Access 2010. The...

This is exactly why the Currency and Decimal Datatypes were invented. (Albeit using data stored as Decimal in a table takes a little manipulating in code to ensure the Variant datatype being used is formatted as decimal - eg, by using Cdec(...) etc.)

Follow on - just realised that ShellWait isn't a VBA function but one in the wsShell Object. Code that does the same in VBA attached.

The real question is how do you launch your Python program? If you launch it from Access then then you can refresh/requery your table as the Python program finishes. Just have to ensure that the program finishes before you update. (Use ShellWait rather than Shell to launch it.)

If you need anything more than Split() - perhaps multiple delimiters for instance - then use Regular expressions.

That was the empire, not UK. Why do you think we wanted an empire except to get warm!:cool:

Being a Brit can I ask one question? What's Sun?

If you read the documentation that used to come with Access, that was the design purpose of domain functions so Doc Man is absolutely correct. I don't think it ever occurred to me to use one in query!

Obviously I agree in general, but a single use to get a particular value is OK.

Yet again as with outher 'old' data sources., if you have access 2003 you can Import the data directly and then convert to format you can use in 64 bit (XMĹ).

When it comes down to it unless you've had the surgery it's actually all playing 'dress-up'! If you have had the surgery you're still chromosomally still what you ever were.

Trump is wrong on this - what he means is there are two sexes! There are, and always have been, 3 genders - masculine, feminine and neuter. The word gender refer s to a language construct which has been hijacked to give it a different meaning.

Years back when producing output for real, particular circumstances meant I needed Word documents for other usage and I got into the habit. If producing a huge output then reports ARE quicker, but that is seldom my requirement. I use automation which gives me a far finer control over output...

I don't, as these days the applications are all just for me and my wife to use so it's not a problem, as the interface opening is merely an inconvenience. And I seldom use reports: I send almost all my printing output to Word documents (personal preference). You don't need a print button on...

Exactly what I do plus the /runtime switch

Good thinking - I shall look on my Win 7/2003 PC to see if I can spot a likely DLL:

Glad you solved your problem - however, I'd put money on the fact that the facility hasn't been removed - just hidden because the developers think it's not needed, but it is harder work to take it out!