Thursday, December 05, 2013
Tuesday, November 26, 2013
Thursday, November 21, 2013
If you look at the second picture you will see the barcode font in action where the Barcode says Hello Readers.
There was an article on barcodes in Smart Access back in the 90s.
Wednesday, November 20, 2013
Tuesday, November 12, 2013
And here is the second article that I ever wrote on consolidation queries for a bit more background on group by queries. Garry Robinson
Tuesday, October 29, 2013
Monday, October 21, 2013
Saturday, October 19, 2013
Wednesday, October 09, 2013
Sunday, September 29, 2013
|Excel has a Color Filter|
Microsoft has an article on color filters here
Thursday, August 08, 2013
Tuesday, August 06, 2013
Techniques that people use are
- never file, just leave them in the inbox
- move emails to other email folders
- move emails to physical folders (this one happens at places where IT departments clean out old emails automatically)
- one person opens every new email and leaves it open, she doesn't leave until she has actioned every one (she gets a lot so its a lot of open windows) and closed them
Here are a list of techniques that are worth thinking about.
To add to that, I would suggest
- making some email rules to automatically move news emails into another folder so they don't clog up the inbox
- making sure that your mobile and tablet can be used to file your emails (move folder)
- turning emails into Tasks with dates and Calendar items so that you act on them at the correct time.
Thursday, July 25, 2013
In the first picture, I am running the Win8 version of IE and I pull down the list of open IE windows. This is nice. In the second screen the internet web address window is really handy with a list of recent sites that you have visited. In the third picture I am using the great Win 8 reader app. It shows news like a newspaper with narrow columns for easy reading.
So in a nutshell, next time you go looking for a computer or a browser device, give a touch screen Windows 8 pc a lot of thought. I did and I am happy I made a good choice even with a 2hr battery life and a fan whirring away in the background.
|Figure 1 - pull down to see open IE tabs|
|Figure 2 - Web Address bar is very useful|
|Figure 3 - Windows 8 Reader looks like a real newspaper|
Tuesday, July 02, 2013
Saturday, June 29, 2013
Tuesday, June 04, 2013
This video shows that 3D printers are going to be immensely valuable in space and probably everywhere else as well.
Monday, June 03, 2013
Thursday, May 23, 2013
Conclusion: Nothing actually changed in Access data storage in a decade through 4 versions.
Friday, May 10, 2013
If you press Control Break it stops the query running. This has two different behaviours
For big queries, this is a possible disaster because you really do not know the state of your data.
You Have A Big Query When
You Get this prompt
|There isn't Enough disk space or memory to undo the data changes this action query is about to make|
So Is This A Problem ?
If this only happened when you pressed Control Break, it wouldn't matter because it is unlikely your users are going to do this. What does matter is that your user turns off their computer (in frustration because the query is taking so long) or finds some other way to interrupt the process. We have even had instances where switching to Excel triggers the Control Break behaviour. Then you have to decide, does this make my database incorrect.
I don't have a great solution for you apart from breaking up the query into smaller updates so it only effects smaller number of records. That way if the process is stopped mid stream, you know that the data is in its original state.
Another clunky way to avoid the problem is to inform your users with a message box or popup form that this query takes a long time so that they don't become impatient.
The vb123 story on control-break keys is here
Microsoft Access MVP since 2006
Thursday, April 25, 2013
So when my mobile plan came up, I decided I had to stop being a Windows 8 doubter and hopefully get proper Outlook Exchange Synchronisation. I also didn't have pockets big enough for the new Samsung Android.4G phones (that is trouser pockets, not $$$ pockets). So I purchased a HTC 4G phone.
I totally love the very customisable main screen of the Windows 8 phone as shown in pictures 1 and 2. It makes the icons on Google and IOS look like a boring Desktop. In figure 1, I see all my emails, messages, and things I need to know at a glance. When I slide the screen up, I can see HTML pages and other apps.
My Outlook Exchange account now syncs beautifully. I now can sort out my email mess in a browser, in Outlook on a desktop and on my phone and it instantly changes in all the others. This is what a phone is meant to do.
What is missing is some apps and the totally slick Swype keyboard interface. Please Microsoft, pay Nuance to add it to Win 8 mobiles.
I now can see what Microsoft are trying to achieve with the UI of Windows 8, before I was only excited with the way it looks. And the phone fits very comfortably in my pocket. All in all, the upgrade has been a success and here are the screen dumps
Screen 1: What I see on the home screen. 5 in Messaging means I have 5 unread SMS messages. At the top of the Date tile is the next Calendars task. Screen 2 is still the main screen which you get to by sliding the screen up. The white tiles are links to HTML pages in IE.
Access MVP and a not so clever mobile ph user.
Wednesday, April 03, 2013
Saturday, February 16, 2013
My thoughts on this "Though I haven't read the fine print, this means that Microsoft need to keep including Access in the Premium line-up because the licence entitles users to free upgrades as long as they keep paying. So there you go dear readers, Microsoft have to keep Access going... As Excel and Word and Outlook work well in the cloud, its a good bet that Access will get the resources to fly to the cloud in the not to distant future.
Garry Robinson - Access MVP from 2007 till now.
Friday, February 15, 2013
Wednesday, February 13, 2013
Book Links: Access 2013 Inside and Out by Jeff Conrad (Andy is an editor)
Microsoft® Access® 2013 Plain & Simple by Andy Couch http://shop.oreilly.com/product/0790145365408.do
Microsoft® Office Professional 2013 Step by Step by a bunch of people http://shop.oreilly.com/product/0790145365163.do
Like most of you skilled Access users, what I really want to see in Office 2013 is a cracking offering from MS for Access. For too long we have been wandering in the wilderness. All of you have wanted a browser based experience, and it has not come to pass. Until now.
I have said this so many times is we needed a solid platform for the internet before we added the WOW factors. After working with the beta and now the live version of 2013, I think it is difficult to dispute that we now have the platform.
I have just spent all of today going though one of Jeff Conrads Chapters on constructing views (which is basically a form in the browser). What Jeff has show me is that these views go much further than you would imagine in an online programming world. This excitement is something that I haven't experienced for a 15 years. When I was a Paradox Developer and got my hands on Access 2.0, and I saw just how great that product was. Then with Access 97 when OLE Automation came of age, I thought wow. When the Ribbon came along I thought well it is nice, but not a revolution. Other than that, Access has just been good old Access.
Now I have pleasantly had my third Access Revelation. The work that has gone into the View Design Tool is just awesome. Not only have the Team managed to preserve so much of the standard productivity of good old Access, but they have added features that actually make the UI surpass Desktop Access!
For a simple example, when you drag and drop a field onto a form, the design surface moves all the other controls out of the way to make space for when you drop down or move an existing control. But that is just one of a number of very sexy new features. Now we wait while Microsoft posts some worthwhile examples, great help guides and videos and irons out the kinks in Office 365 to see if these revelations actually become a revolution. In the meantime, why not pre-order one of these books to whet your appetite"
Monday, February 11, 2013
For more pesky questions to the MS team about Surface pro, read this page or just read an early ZDnet review
FYI 2: People who use Macs, Ipads and Google devices don't seem to develop custom software and just like suffering with what they have been given. Good businesses should continually improve their business practises, standing still or downloading the odd app is unlikely to liberate the information that individuals collect.
Monday, February 04, 2013
So if you are looking for the upside, my guess is it may be an environment where Access programmers can generate solutions that run in more worldly places than our conventional files server solutions. I believe we had better hope that all those big companies with SharePoint find this is a great idea and then they start looking for people with Access skills to build these apps. Only grandfather time will reveal if this is going to come about.
Remember when installing a new version of MS Access to test, always install with the additional options and do not remove your old version of Office. Generally I like to only add Access and leave Excel and Word at the lower levels.
Note: Access was included in the Office 365 Home Premium pack, something people can rent for 15$ a month or thereabouts. That's a positive sign.
Tuesday, January 29, 2013
Friday, January 18, 2013
Tuesday, January 15, 2013
See all the steps to change indexes in Access here
Friday, January 04, 2013
Unfortunately there are problems with that solution (and if I am wrong about that sorry).
1) It doesn't work in Access 2010 but seems to work.
2) It fixes the random number seed but eventually the problem returns.
There is only one solution and its a manual fix.
Open the table in design view. Find the auto-number field. Make it the primary key. Look at the sort on the primary key. It must be Ascending.
Do not remove the Primary key from the autonumber key, no matter how you want that table to behave.
What I think is going on
At some stage, someone in Microsoft decided that when a database is compacted, they could look at the very last record in the table and then look at the autonumber field and save that number as the seed. Then when the next record is added, it looks at the seed, adds one and then updates the seed. All fine if the table is sorted correctly. I think the bug crept in because Microsoft templates all have autonumbers as the primary key in each table. Therefore they wouldn't have noticed the bug. For people who are getting an error like "Autonumber already exists", its because the seed is lower than the highest autonumber in the database and eventually it hits a record that already exists.
I hope I am wrong, this is totally unnecessary bug that should be fixed in the next service pack. It has caused problems in at least 3 of the databases we are maintaining.
We have this bug in Access 2000 databases but we are running them with Access 2010 now.
I do not want anyone to lecture me about primary key design or autonumbers but if you know anything about house paint colours and kitchen design, happy to chat.
Here is an article that shows you how to change (primary key) indexes
Access MVP 2006-2013