Wednesday, January 28, 2009

Lost XP Built in Driver List

I set up a new computer for our AJ Manufacturing DC where they ship our Postframe Doors and Windows as well as our Access Doors for the HVAC industry. I ran into a problem when I tried to install an impact printer. The driver file is provided with XP and I was unable to download it from Okidata. I needed to install the built in driver, but it seemed that I was unable to view XP's built in driver list when installing or adding a new printer.

Here's the solution. Proceed with the install as normal and when the dialog box asks for printer model and it does not show any printer models, then press "have disk" and navigate or browse to C:\I386
In there is the Built in print driver list. When you hit OK, the XP built in list of printer drivers will show again for you.

Wednesday, January 21, 2009

AJ Manufacturing AHR Expo 2009 Promo Access Video

Here's a video I created with the help of Bob Kortbein our Access Door Sales Manager. It was created for the AHR Expo 2009 show. Not too exciting, but every once in a while I get to work on some fun stuff like this. I filmed some footage of our Robotic Welding Cell and our Turret press station. ajdoor.com

UPS Worldship ODBC error

UPS Worldship integrations can be quite easy, but I have found that when integrating it with MS Access, the date format that is exported does not play well with an Access date field. The error I received is the following...
ODBC Error: State= 22005 Error. Invalid character specification (null).

The trick to making this work is to change your field type in the Access table from a date formated field to a text field. Then you will need to change the text date into something that resembles a date format and then move it to a table that uses a date field.

Now I am able to append my Access table with each shipment processed to provide our AJ Manufacturing sales staff with tracking numbers.