Archive for February, 2012

February 14th, 2012

MS Access – Button Picture – doesn’t support this format … or the file size is too big

I came across the following post and wanted to see what the issue was since I routinely use Irfanview myself (it is a great, free no strings attached piece of software).

So I contacted the creator of Irfanview directly regarding the error, and he was able to pinpoint the exact nature of the problem.  As it turns out, the ico files created by Irfanview are just fine.  The issue is that MS Access would seem to expect a specific type of ico file (and doesn’t tell anyone this).

Irfanview creates a 24BPP (with no alpha layer) ico file while MS Access seems (based on my testing and returned information from Irfan) to expect a 32BPP with an alpha layer ico file.

So for anyone else ever seeing this this of error.  An ico is not an ico in the world of MS Access.  It is picky and requires a specific type of ico file.  So just be sure of the type of file your are creating is a 32BPP with an alpha layer ico and you should have no problems using them as a picture for a button.  Alternately, instead of having such issues using a ico file, use BMPs instead.  I personally don’t like BMPs as they aren’t used in any other programming (always jpg, gif, png, ico) so I will stay with ico so I can reuse them easily where I please.  It would be nice if MS would integrate common image files into the application, but that is out of my hands (if it were up to me many issues like this would have been resolve a long time ago!).

Hopefully this will help someone out.

Share and Enjoy

  • Google Plus
  • Facebook
  • LinkedIn
  • Twitter
  • Email
  • Print
February 8th, 2012

2008 Nissan Altima 2.5S Review

Well, it was finally time to retire my 15 year old Dodge Breeze.  An exceptional car!

My wife and I after sitting in numerous cars and considering various factors, we choose to purchase a 2008 Nissan Altima 2.5S.  Don’t get me wrong, when I first set out looking, I wanted to purchase a North American vehicle.  We hit all the local dealers, and it was by fluke that my father found this vehicle in Hawkesbury.

Here are my thoughts on the car after a couple of months of driving.

Pros:

  • Comfortable
  • Nice, easy to read dashboard
  • Adjustable steering column
  • Huge amount of space; both in the car and in the trunk
  • Smooth and comfortable ride
  • Lots of power under the hood, if and when you need it

Cons:

  • Trunk hinges go into the trunk space, and crush anything in their path!  I am surprised that the design is so poor.  My 15 year old Breeze, didn’t even present this flaw.  You’d think in 15 years Nissan could have learnt a thing or two from their own design and their competitors design.
  • Gas consumption - I thought purchasing a much newer car, I would see some savings on gas.   I was wrong.  Very disappointing to see that automotive manufacturer have sat on their butts for the past decade, or two, instead of innovating their products.  Also, what they have done to give you the impression of good consumption is to give a very big gas tank, so the onboard computer tells you you have a big range, but wait until you have to fill it up.  My last fill-up cost me 103$!
  • Brake and Gas pedals are too close.  If you are like me, a decent size man, then you will have an issue in the winter wearing snow boots and using the pedals, as your boot will touch both pedals at the same time since there isn’t enough clearance between the two.
  • Heat – we find that, in the winter, the car doesn’t heat up very quickly.
  • Maintenance perspective – I was disappointed to discover that I cannot put this car up on my ramps to do my own oil changes, etc. because the nose is low and long.  So you are forced to deal with a mechanic for even the most basic oil change.
  • Remote control - battery life is very short (couple of months)
  • Remote control – because the buttons are not recessed, get triggered when in your pockets, just by sitting down.
  • Remote control – the setup baffles me.  For instance, if the car is running, but in park, you cannot use the remote to open the trunk!?
  • After being used to the Dodge radio, I do not like the one in the Altima as much.  The sound is fine, but I do not like having to cycle through preset A-B-C instead of being able to set multiple channels to the same button.  This is a very minor issue though and a personal one at that.  I should also mention the radio console is well positioned and very intuitive to use.
  • Dinky horn.  No truly I’d expect this on a small smart car or a clown car at the circus, but not on a nice, big car like a Nissan Altima.  One doesn’t use a horn often, but when you need it, you want it to get everyone’s attention.  I don’t think one does the job.

I know I have compiled quite a list of Cons, but don’t get me wrong, it is a nice car.  I’m just a little surprise that certain items were never addressed in car well developed car.  This is not a new model, the Altima has been around for quite some time.

One very nice thing, is the dealership!  I dealt with Rendez-Vous Nissan in Hawkesbury.  They where all so very nice!   And they provide you with a courtesy car, free of charge, and will even come and pickup your car and leave you with a courtesy car, free of charge, when you need maintenance done!  Let me tell you my experience with Chrysler was nowhere near anything like this!!!  Forget a free courtesy car, heck forget a courtesy car altogether.  If you wanted one, go across the street and rent one!

So the Altima may have problems, the company makes up for them.  It is this attention to their clients that most distinguishes them and continues to put them ahead of the North American cars (dealerships), IMHO.  Until North American automotive manufacturer put customer service/customer satisfaction at the top of their list, they will continue to see foreign automotive manufacturer a part of the market from them.  My experience with Chrysler dealerships will forever make me avoid them altogether, even though the vehicle I had from them was excellent!  You have to feel like more than a cash cow, and Nissan make you feel wanted, liked, and not just a wallet.  The personnel were kind, offered coffee, newspaper,…  Just nice people.  Don’t get me wrong, they want business just like any other business, I just didn’t feel like it was being crammed down my throat as it felt like at numerous other deals we went to when searching for our car.

Share and Enjoy

  • Google Plus
  • Facebook
  • LinkedIn
  • Twitter
  • Email
  • Print
Tags:
February 7th, 2012

Mr Lube / Monsieur Lub Review

I recently was desperate for an oil change, didn't want to wait in the Canadian Tire waiting room for hours, and couldn't perform my own since my car cannot go on standard ramp?!  Anyways, I decided to try a local Mr. Lube.

  • I rolled in without an appointment and was taken right away.
  • The technicians were very curtious and seemed methodical.  They performed several operations that even my dealership does not normally (lubing the door for instance without even asking).
  • All was going exactly as advertized, until the technician checking my air filter, pulled out my air filter in a manner that it could not be reinserted (it was deformed and no way to put it back from where it came); I'm not saying that it was not due for a change.  The technician told me, not that I had any choice at that point, that had to be replaced.  Obviously!  So he went and pull one from inventory, installed it in literally 1 minute.
  • And I was done.

Then I got my bill.
$46.99 for the Oil change, checkup (fuilds, battery, …)
$89.99 for the air filter!

Not knowing any better, I paid.  I figured maybe it was a specialty item from the manufacturer.

As soon as I got home I decided to check up the part, here are a few links I pulled:

http://www.ebay.com/itm/LUBER-FINER-CAF1848P-Cabin-Air-Filter-/260858277533
http://gxezen.tricomsys.com/index.php?main_page=product_info&cPath=1_21&products_id=7091
http://airfilterscar.com/air-filter-luber.html
http://www.autopartlookup.com/partdescription.asp?m=LBF&p=CAF1848P
http://www.partsgeek.com/mmparts/cabin_filter/nissan/altima.html
http://www.amazon.com/TYC-800107P-Nissan-Altima-Replacement/dp/B002E5BW74/ref=pd_sxp_grid_i_0_0
http://www.autopartswarehouse.com/mmp/nissan~altima~acc_cabin_filter~parts.html
http://www.nextag.com/nissan-altima-cabin-air-filter/shop-html
http://www.buy.com/prod/2007-2008-nissan-altima-cabin-air-filter/217600565.html

As you can see, the air filter can be purchased for anywhere between $5 and $30 (on the very high end of things), with an average price of about $12-15.  A hell of a long way from the $90 charged by Mr. Lube.  That makes a markup of anywhere from 200% to 1700%, on the average it would be a markup of about 650%.

All of this to say, you can be sure that Mr. Lube lost a new customer today.

You make your own judgement call on whether or not you wish to do business with Mr. Lube.  For me the decision is clear!

 

Update 2012-Feb-29

Well, I was contacted by a representative from Mr Lubes head office in BC about my complaint.  Basically, I was informed that the price also included an installation fee!  Come on really!  So according to Mr Lube, a 7.95$ filter costs 82$ to install.  Now since the installation took no more than 5 minutes to install, that translates into a rate of 984 $/hr.  I'd also ask, why aren't parts and labour separate on the invoice, like any ordinary mechanic's shop?  With cheap explanations, should I say excuses, like that it quickly becomes evident the type of business Mr Lube truly is.  Hey, I have nothing against making a profit, but 82$ to install an air filter is simply ripping-off your client!  Nothing more, nothing less!  They appear, in my experience, to be more interested in excuses, than customer satisfaction.  Their intervention did nothing but to reinforce my initial impression of their business!

Update 2012-Mar-10

CBC's Marketplace had a segment on their April 6th, 2012 show regarding Mr. Lube which brought to light their dubious cabine air filter prices, etc…  See:

http://www.cbc.ca/marketplace/2012/busted/statements.html
http://www.cbc.ca/marketplace/includes/2012/episodes/busted/08_mrlube_statement.pdf

 

You may also want to check out my review when I decided to go back again to Mr Lube to see if my first experience was atypical or not.

Share and Enjoy

  • Google Plus
  • Facebook
  • LinkedIn
  • Twitter
  • Email
  • Print
February 6th, 2012

VBScript – Rename the Extension of all the Files in the Current Directory

Here is another odd problem I had to tackle and which VBScripting was up to the task of easily handling.

I had the need of changing the extension of all the files in a folder from *.wdseml to *.eml. If you only have 1 or two files, a manual solution is feasible, but in this instance I needed to change the extension on thousands of files, so an automated solution was needed. Below is the script that I put together for the job. It could easily be modified to prompt the user to make it more versatile…

'*******************************************************************************
'Author:	Daniel Pineault / CARDA Consultants Inc.
'Purpose:	This script will, without any prompts to the end-user, rename
'		all file extension specified to whatever new file extension is 
'		specified of all the files meeting the criteria in the same
'		folder as the vbscript
'Revision:	2012-01-31   Initial Release
'*******************************************************************************

sVBSPath = Left(WScript.ScriptFullName,(Len(WScript.ScriptFullName) _
		     - (Len(WScript.ScriptName) + 1)))
with createobject("wscript.shell")
   .currentdirectory = sVBSPath
   .run "%comspec% /c ren *.wdseml *.eml", 0, true
end with

Share and Enjoy

  • Google Plus
  • Facebook
  • LinkedIn
  • Twitter
  • Email
  • Print
Tags:
February 3rd, 2012

VBScript – Determine Current Directory Path

Have you ever needed to merely determine the full path of the location where a vbscript is located?  I t really isn’t that hard, once you know how to do it!  Below is one method to determine directory path of the executing vbscript.

sVBSPath = Left(WScript.ScriptFullName,(Len(WScript.ScriptFullName) _
       - (Len(WScript.ScriptName) + 1)))
msgbox sVBSPath

Share and Enjoy

  • Google Plus
  • Facebook
  • LinkedIn
  • Twitter
  • Email
  • Print
Tags:
February 2nd, 2012

VBA – Directory/Folder Name Validation

I had a need to create folders from Access, but needed a means to first validate that the folders names were acceptable as Windows does not allow certain characters and has certain basic rules (refer to the 2 links commented out in the function below for all the details).  As such, I created the following simple function which I supply the folder name to and it returns True/False whether the string is acceptable or not.  It really wasn’t very difficult and this is the perfect situation in which to utilize the power of regular expression to validate the folder name with!

'---------------------------------------------------------------------------------------
' Procedure : IsInvalidFolderName
' Author    : Daniel Pineault, CARDA Consultants Inc.
' Website   : http://www.cardaconsultants.com
' Purpose   : Validates whether the string passed is an acceptable folder name
' Copyright : The following may be altered and reused as you wish so long as the
'             copyright notice is left unchanged (including Author, Website and
'             Copyright).  It may not be sold/resold or reposted on other sites (links
'             back to this site are allowed).
'
' Input Variables:
' ~~~~~~~~~~~~~~~~
' sFolderName name of the folder you're wanting to create
'
' Usage:
' ~~~~~~
' IsValidFolderName("MsAccess Databases") will return True
' IsValidFolderName("MsAccess :: Databases") will return False
'
' Revision History:
' Rev       Date(yyyy/mm/dd)        Description
' **************************************************************************************
' 1         2012-Feb-01                 Initial Release
'---------------------------------------------------------------------------------------
Function IsValidFolderName(ByVal sFolderName As String) As Boolean
'http://msdn.microsoft.com/en-us/library/windows/desktop/aa365247(v=vs.85).aspx#file_and_directory_names
'http://msdn.microsoft.com/en-us/library/ie/ms974570.aspx
    On Error GoTo Error_Handler
    Dim oRegEx          As Object
 
    'Check to see if any illegal characters have been used
    Set oRegEx = CreateObject("vbscript.regexp")
    oRegEx.Pattern = "[<>:""/\\\|\?\*]"
    IsValidFolderName = Not oRegEx.test(sFolderName)
    'Ensure the folder name does end with a . or a blank space
    If Right(sFolderName, 1) = "." Then IsValidFolderName = False
    If Right(sFolderName, 1) = " " Then IsValidFolderName = False
 
Error_Handler_Exit:
    On Error Resume Next
    Set oRegEx = Nothing
    Exit Function
 
Error_Handler:
    MsgBox "The following error has occurred" & vbCrLf & vbCrLf & _
           "Error Number: " & Err.Number & vbCrLf & vbCrLf & _
           "Error Source: IsInvalidFolderName" & vbCrLf & _
           "Error Description: " & Err.Description, _
           vbCritical, "An Error has Occurred!"
    Resume Error_Handler_Exit
End Function

Enjoy!

Share and Enjoy

  • Google Plus
  • Facebook
  • LinkedIn
  • Twitter
  • Email
  • Print