misunderstandings.wordpress.com
February | 2007 | Latest Misunderstandings
https://misunderstandings.wordpress.com/2007/02
124; Comments RSS. Bits of Useful Code. Hardware and Future Tech. Decent Access mdb deployment method. Take an Access database you’ve developed to make your life easier doing some business task that you don’t have $200k for your IT department to make a less usable version of and ah, yes, the point. Now your team of 5 need to use this application. Which knowing a little about Access you’ve at least split into a front and back ends). Here’s a solution. Put the back-end on a network share somewhere. 124; Le...
misunderstandings.wordpress.com
November | 2007 | Latest Misunderstandings
https://misunderstandings.wordpress.com/2007/11
124; Comments RSS. Bits of Useful Code. Hardware and Future Tech. Avoid 1 year laptop warranties. Switched on my laptop the other morning, before preparing a habitual bowl of cereal, and returned to find a blank screen despite a happily glowing power LED. Hmmm, I flipped the switch to restart. Hitting F8 after the bios posts. Shivering at the sight streaked white through the options text). I start up in safe mode. Success, hmmm, no streaking at all, perhaps the graphics card is ok after all. Access usefu...
misunderstandings.wordpress.com
October | 2006 | Latest Misunderstandings
https://misunderstandings.wordpress.com/2006/10
124; Comments RSS. Bits of Useful Code. Hardware and Future Tech. The view to use for column and table metadata. If you ever need to run a query to get a specific list of table or column names in MS SQL Server across an entire database, then try information schema. Specifically information schema.tables. And information schema.columns. There are a bunch of different views. To the information schema. Oh and apparently SQL Server 2005 breaks a few things. But it still exists). 124; Tagged: column.
misunderstandings.wordpress.com
September | 2006 | Latest Misunderstandings
https://misunderstandings.wordpress.com/2006/09
124; Comments RSS. Bits of Useful Code. Hardware and Future Tech. Aggregate function to do concatenation create a delimited list. A simplistic concatenation aggregate function for Access. Which maintains one advantage(? Over this mvp solution. That is we can define our queries outside of the code). A sample query, saved here as ‘QuerySelectionForConcatenation’:. SELECT DISTINCT valid value.value txt FROM valid value WHERE valid value.value set cde = [InputId]. How to call it. See the function code….
misunderstandings.wordpress.com
June | 2008 | Latest Misunderstandings
https://misunderstandings.wordpress.com/2008/06
124; Comments RSS. Bits of Useful Code. Hardware and Future Tech. Q Why build a desktop application as a prototype if ultimately you’re aiming for a web service? A If you need to get a couple of people in a corporate environment using your prototype ASAP. Thus you’ve got no time to play corporate politics, get a server from somewhere, get software licences, further budget to get IT support for the application…. all this just to try out a concept? Searching for solutions (continued)…. 124; 12 Comments.
misunderstandings.wordpress.com
August | 2008 | Latest Misunderstandings
https://misunderstandings.wordpress.com/2008/08
124; Comments RSS. Bits of Useful Code. Hardware and Future Tech. My wife won a silver iPod shuffle. Last week and since I’d recently washed my old-school shuffle, she kindly donated it to my personal charity. So what’s good about the 2G shuffle. Can’t really call it new when it’s over two years old). Well, to me the clip looked a little crap. Over compensating macho side – thinking men don’t wear brooches). And it seems to make it about twice as thick… Where were we, ah yes, what’s good?
misunderstandings.wordpress.com
January | 2008 | Latest Misunderstandings
https://misunderstandings.wordpress.com/2008/01
124; Comments RSS. Bits of Useful Code. Hardware and Future Tech. Fun of the build part one. As mentioned previously I was planning to put together a powerful new PC. Here’s the review of the process and the components used. Part two for bizarre customer service and product reviews. Since my decision to use Overclockers UK. Was based almost solely on the wide range they provide with regard to high performance. There were some dramas with this supplier but I’ll get to that next time. The basic function of).
misunderstandings.wordpress.com
July | 2006 | Latest Misunderstandings
https://misunderstandings.wordpress.com/2006/07
124; Comments RSS. Bits of Useful Code. Hardware and Future Tech. Method and User Stories. The idea is to take the steps presented in atomic object. 8216;s PresenterFirstAgile2006 paper. And customise them into a tight dev loop, and a large project. Including client interaction loop). Around my own work style. So initially I start with:. Create a stub presenter class that takes a model interface and a view interface via its constructor. Create mock test objects that satisfy the model and view interfaces.
misunderstandings.wordpress.com
iPod Shuffle | Latest Misunderstandings
https://misunderstandings.wordpress.com/2008/08/20/ipod-shuffle
124; Comments RSS. Bits of Useful Code. Hardware and Future Tech. My wife won a silver iPod shuffle. Last week and since I’d recently washed my old-school shuffle, she kindly donated it to my personal charity. So what’s good about the 2G shuffle. Can’t really call it new when it’s over two years old). Well, to me the clip looked a little crap. Over compensating macho side – thinking men don’t wear brooches). And it seems to make it about twice as thick… Where were we, ah yes, what’s good? You are comment...
misunderstandings.wordpress.com
August | 2006 | Latest Misunderstandings
https://misunderstandings.wordpress.com/2006/08
124; Comments RSS. Bits of Useful Code. Hardware and Future Tech. Converting a grid or cross (intersection) view. Converting a grid or cross (intersection) view and converting it back to a useful form, single column. What I’m vaguely trying to describe is the situation where you have a list of things across the spreadsheet. And a list of things down the sheet. With some data stored in the intersection of the two. That is we have an item called ‘Item Cat’ as the heading in column C. Modulo, or remainder).