Recent content by Twincam

This is why I like the Citizens' income. The cost of that falls on the taxpayer, not on individual businesses. If everyone gets enough to survive already, then being paid a small salary (less than the current minimum wage) by a start-up becomes attractive instead of being a potential threat to...

Interesting thread, so I'd like to add the idea of a Citizens' income. http://www.citizensincome.org/ http://www.telegraph.co.uk/finance/economics/12037623/Paying-all-UK-citizens-155-a-week-may-be-an-idea-whose-time-has-come.html My kneejerk reaction when I first came across it was... OMG...

Fair point, but you can comment without being deliberately abrasive. That's what trolls do, they abide with any clear rules to avoid being deleted, but within that scope they are as divisive and offensive as they can be. Their other main tactic is to be prolific, chipping away at people on as...

It was a great post, slightly out of context, slightly puzzling. A pity about the trolling though.

This is mine, 5+ years into it and the wheels will be going on soon! two ways of looking at the same blog. www.facebook.com/1926Sunbeam www.vintagesunbeams.blogspot.com

There are so many techniques to use in Excel - the trick is using the right ones in the right order! There may well be better solutions than this one. To add more parameters to the table, just copy/paste the columns in pairs.

Have a look at this. A pivot table to summarise the sites and a joined field as the source for a vlookup. Note that the flag vlookup is slightly different to the value vlookup.

Do you mean (a picture speaks a thousand words) Site1 Site2 ParameterName1 ParameterName2 value1 value2 flag1 flag2 ParameterName2 parametername3 Value2 value3 FLag2 flag3 ParameterName3 parametername4 Value3 value4 FLag3...

Have a look at this thread... http://www.access-programmers.co.uk/forums/showthread.php?t=251416&highlight=create+workbook It shows how to create and populate an excel spreadsheet from access.

I think I get where you're coming from as I wrote something similar in a previous life. I separated attributes and variants to make it simpler, so you could not have a default value for a variant. Stock StockID, Description 37, Trousers Attribute StockID, Description, Value 37, Material...

Use "for each": The first time you run it, run it with a msgbox or a print just to check it doesn't contain anything you don't expect! for each tdf in dbs.TableDefs tdf.Connect... Next tdf

I've never heard that before. Powerful stuff. You've got me questioning myself now. The medical stuff is horrific. UK, by the way, where we're fighting to keep the National Health Service from being gradually privatised out of existence.

It works, if your expectations are realistic. It's insanely complicated and people have deeply held fundamental beliefs that are poles apart. The middle ground isn't a calm place. The problem is the people who want to impose their fundamental belief on others. They're always bad news. If...

I didn't take offence at all, none at all. :) I've bever been good at handling compliments. I can cope with insults, but I always trip over compliments.

Ouch! Tough question! If all those freedoms were willingly given up by everybody on the planet... theoretically... it would work...???? Not going to happen any day soon though is it. We have to look for the middle ground. I don't believe in a god but a sod of a lot of people do, so that...