Tuesday, August 26, 2008

Access 2007 Developer Extensions Not Showing Up Anymore

I spent a couple hours uninstalling and reinstalling to try to fix this problem. Maybe repeating this section from (http://granite.ab.ca/access/developeredition2007faq.htm) will stop you from doing the same.

Q: I installed the developer extensions but can't find the Developer option in the Office button.

From a fellow Access MVP - The Add-in will disable itself if you switch between Access versions. So if he has more than the 2007 edition installed and he opened the earlier edition after the installation he will need to manually re-enable it through the Access Options dialog (Office Button--Access Options--Add-ins--Manage: COM Add-ins--Go...--Check Microsoft Office Access Developer Extensions COM Add-in--Ok--Close Access Options and look under the Office button again).

Friday, August 8, 2008

Access 2003 Combobox and Listbox Problems

If you are trying to track down why a value is not showing in a combobox or listbox after applying MS Access 2003 Service Pack 3 then you may want to read and apply the hotfix 945674.

http://support.microsoft.com/kb/945674/

945280 (http://support.microsoft.com/kb/945280/) Combo box controls and list box controls display no value or incorrect values in Access 2003 after you install Office 2003 Service Pack 3

943967 (http://support.microsoft.com/kb/943967/) After you install Office 2003 SP3, you encounter various problems in an Access project when you work with a Bit data type column in a linked SQL Server table

Thursday, May 22, 2008

Design Flaw Fix: Can't Scan Or Fax When Canon PIXMA MP530 InkJet Printer Is Out Of Ink

"I'm sorry I can't send a fax because I'm out of magenta.", I say sheepishly. There's no reply on the other end of the phone line. Just an eerie silence like the line had gone dead.
"Um, Ok. But the page I'm sending is in black and white." the other voice finally replies.
"Yes, but my fax or scanner doesn't work when I'm out of any color of ink."
"Wow, that must be an old machine what is it a dot matrix machine?", the other voice remarks sarcastically.
"Nope, its a Canon PIXMA MP530. In fact I just bought it last year!"

Well, this was how the conversation went and I was not to happy about it. Not very professional for a consulting company.

I knew it wasn't right and I had not yet read any reviews on the printer saying it was a design flaw so I figured I was doing something wrong. So after much careful thought and trial and error (read aggravated pounding) I found the solution!

The Canon PIXMA MP530 InkJet Printer Ink Out Fix:
Step 1) Turn the printer off.
Step 2) Turn the printer on.
Step 3) While the printer is turning on hit the "scan" button like you were playing an old Atari video game. Quickly and constantly until the printer stops "booting up" and the light is off of "Copy" and on the button you were hitting.

You should now be able to get into the menu and switch between all three of the buttons (Copy, Fax, Scan). I haven't test all the functions but I could now successfully scan a document into the computer and fax!

This is what cannon customer support has to say about this issue to use the above trick wisely and only when needed.

Thank you for writing to us. We value you as a Canon customer and appreciate the opportunity to assist you. I am sorry that the MP530 is not normally usable when out of one of the ink.

Of course you can turn the ink detection off, but then you must monitor the ink manually and there can be damage done to the print head because all of the cartridges do not have ink.

The printer performs cleaning cycles whenever the unit is on. The nozzles have heating elements which is part of the printing or cleaning.
This is why it will stop all functions if there is a cartridge error or out of ink to prevent damage to the print head.

Think of it like a car out of oil and the person saying, well I won't put it in gear I will just use the heater or air conditioner.

We hope this information is helpful to you. Please let us know if we can be of any further assistance with your Canon MP530.

Thank you for choosing Canon.

Thursday, February 21, 2008

Removing double spaces in dreamweaver

I've been having a problem with Macromedia Dreamweaver CS3 adding double spaces (an extra line) to files I download to edit. I made sure my FTP program (FireFTP) and Dreamweaver are sending the files binary instead of Ascii, but that didn't help. I could not use Commands>>Apply Source Formatting - because it is a php file.

As it turns out that end of the line characters can be formatted differently for different systems; i.e. Unix (Line Feed), Windows (Control Break & Line Feed), Mac (Control Break). My Dreamweaver setup was formatting the files with a Windows line end character while the files were from Unix thus adding the extra line.

So to remove the double spaces I set: Dreamweaver>>Edit>>Preferences>>Code Format>>Line Break Type to "LF (Unix)" ... problem solved!

P.S. I also learned during that in Dreamweaver you can use Shift>Enter to create a single line (
) instead of Enter which creates a double line (

).

Saturday, February 16, 2008

Vista: Access denied error while trying to delete files

Sometimes in Microsoft Vista, simple tasks such as deleting files is not an easy thing! After my gateway system crashed I created a backup and restored with the Gateway Recovery Center. It worked great. All the files of of system, including the Windows directory, were backed up under C:\Backup. After picking through my old user files and moving them to the new install I was then ready to delete all the useless C:\Backup files as they were taking up about 20gb of space! However, whenever I tried to delete the files I got a "Access Denied" error. After hours of trial and research here is what worked for me.

I took ownership of the files . Using the link is easiest and shows you how to create a registry key and take ownership of the files through a simple shift + right click menu. Deleting the files was possible after I ran this however I did have to run it twice on stubborn files that did not want to delete. Also, run the command on a single folder instead of multiple-selecting folders because you will have to click Vista's lovely "continue" prompts for each folder.

If you don't want to install something permanently in your registry you could also use the command like to do this. You have to use the takeown and icacls commands. Make sure you start the command window with "Run as Administrator" or you will run into problems.

Here are the commands to use:
  • takeown /f "C:\yourdirectory\" /r
  • icacls "C:\yourdirectory" /grant administrators:F
If you get error messages and need to chose Skip then retry the commands on the subfolders until all the files are deleted.

In certain cases on you may get a "Destination Folder Access Denied". You can get around this by holding Shift while you drag the folder to the Recycle Bin. This will delete the files directly without moving them to the Recycle Bin.

Tuesday, January 15, 2008

How to make money with your blog! The new PPP "Pay Per Play" way!

Have you been trying to make money with your blog or website? Well, now is your chance!

Making money with your blog couldn't be easier with a new Pay Per Play service offered by voice2page. Don't get left behind like when PPC "Pay Per Click" first came out. I've joined up and have added this new service my websites and blog. (I'll let you know how it goes!) Imagine, a user doesn't even need to click on a link for you to get paid! When a user visits your site a 3 second ad that pertains to your site automatically plays, and you get paid for it. That's PPP! Making money with your blog was never so easy! Sorry if I sound like an ad, but talk about a simple way to make money from every visitor without those annoying popups.

Here's an article from the Wall Street Journal about it.

I thought this was a great idea when I heard it. What an easy way to make money with your blog or website! Anyway, you can check it out and join up at Voice2Page.

Wednesday, January 9, 2008

Expired Domain Empire Software - Wordlist

I'm not sure anyone can make money out of domains nowadays. However, playing with new (to me) software is always fun so I took a look at the "Expired Domain Empire Software". Searching for nonregistered 2 and 3 letter domain names came up empty (surprise, surprise). So I created a list to look for words ending in "us" and using "E.D.E.S." I checked for any unregistered domains with the extension ".us" . To do this I had to not only come up with a list of words ending in "us" but I had to take off the ending "us" to come up with a del.icio.us type domain.

I had no luck in finding any domains with this but I have included a link to the file in case you would like to modify it and take some prefix letters off.

Words Ending In US Without US Suffix.txt