WMV to AVI Converter

Wednesday, August 10, 2016

Solution to Error: Bidirectional Bar Chart

Bidirectional Bar Chart

how to create a Bidirectional Bar Chart.

Keys to the Problem Bidirectional Bar Chart

Manually editing the Windows registry

Caution: Unless you an advanced PC user, please do not edit the Windows registry manually.

Because of this risk, we highly recommend using a trusted registry cleaner such as SmartPCFixer Using a registry cleaner automates the process of finding invalid registry entries, missing file references (like the one causing your MACHINE_CHECK_EXCEPTION error), and broken links within the registry. A backup is automatically created before each scan, with the ability to undo any changes in a single click, protecting you against the possibility of PC damage. The best part is that repairing registry errors can also dramatically improve system speed and performance.

Click the Start button.
Type "command" in the search box... DO NOT hit ENTER yet!
While holding CTRL-Shift on your keyboard, hit ENTER.
You will be prompted with a permission dialog box.
Click Yes.
A black box will open with a blinking cursor.
Type "regedit" and hit ENTER.
In the Registry Editor, select the Error 0x9C-related key (eg. Windows Operating System) you want to back up.
From the File menu, choose Export.
In the Save In list, select the folder where you want to save the Windows Operating System backup key.
In the File Name box, type a name for your backup file, such as "Windows Operating System Backup".
In the Export Range box, be sure that "Selected branch" is selected.
Click Save.
The file is then saved with a .reg file extension.
You now have a backup of your MACHINE_CHECK_EXCEPTION-related registry entry.

The next steps in manually editing your registry will not be discussed in this article due to the high risk of damaging your system. If you would like to learn more about manual registry editing, please see the links below.

Battery charging issue

I have a new HP laptop with Windows 7 on it.
When I plug in the AC adaptor it starts to charge then after a short period of time it stops.
It charges for abot 20 seconds then stops for 1 minute and starts to charge again.
I tried replacing the AC adaptor
but it still does the same thing.

Anwsers to the Problem Battery charging issue

Download SmartPCFixer to Fix It (Free)

Hi,

Check with the Seller and HP's Support for replacement or warranty repairs.
Check HP's Support, their on-line
documentation and drivers, and ask in their forums for known issues where there are others with the same

or similar model.

HP Support & Drivers
http://welcome.hp.com/country/us/en/support.html

Contact HP
http://welcome.hp.com/country/us/en/contact_us.html

HP Forums
http://h30434.www3.hp.com/psg/

========================

Other information that might help :
References to Vista also apply to Windows 7.
Check with System maker's Support, their on-line documentation and drivers, and their forums
(if any) for known issues.
Some maker's have issued BIOS and other updates to help with battery
problems.

Control Panel - Power Options - Power Plans - Change plan Settings - check the Advanced
Settings for drain and usage settings (this is how much to be used and not how much or how
long to charge).
Actually what causes a lot of wear on a battery is draining it too low repeatedly.
With today's
systems over-charging is not an issue.

Here are some tips to help and troubleshoot battery related issues.
Old battery? Unplug power to computer - remove battery and clean the contacts with a pencil
eraser (do not use this if your battery has thin slots - just clean the knife edges that fit into
them and be careful).
Batteries do wear out if old, or it could be a problem with the computer.
Check with the support of the system maker and many of them have on line forums.

Newer type Litium-Ion batteries usually last longer if you do not discharge them below 30%
however on a laptop that will not extend their life that much.
Best is to use A/C adapter
whenever possible.

I use the free version of BatteryBar to monitor my battery.
Click the Green button on the
Yellow box on right side of page to download latest stable version.

BatteryBar - Free version available
http://osirisdevelopment.com/BatteryBar/index.html

Another good program

Vista Battery Saver - Free
http://www.codeplex.com/vistabattery

Problems with power usage and battery life - Mr Fixit
http://support.microsoft.com/gp/windows_battery_power_settings

You might also want to check with the System Maker and any forums as many use their own
proprietary software to monitor the battery and their could be known issues with your battery.

============================================================

Battery meter: frequently asked questions
http://windows.microsoft.com/en-US/windows7/Battery-meter-frequently-asked-questions
Conserving battery power
http://windows.microsoft.com/en-us/windows7/Conserving-battery-power
Solutions to common battery problems
http://windows.microsoft.com/en-US/windows7/Solutions-to-common-battery-problems
How accurate is the battery meter?
http://windows.microsoft.com/en-US/windows7/How-accurate-is-the-battery-meter

============================================================

Try this - make a Restore Point

How to Create a System Restore Point in Windows 7
http://www.sevenforums.com/tutorials/697-system-restore-point-create.html

How to Do a System Restore in Windows 7
http://www.sevenforums.com/tutorials/700-system-restore.html

Then Control Panel - Device Manager - Batteries - Double Click on each item - Drivers tab -
Update Drivers (which may not do anything) - then Right Click and UNINSTALL each - REBOOT
which will refresh the Driver stacks.

Problems with power usage and battery life - Mr Fixit
http://support.microsoft.com/gp/windows_battery_power_settings

Hope this helps.

Rob Brown -
Microsoft MVP <- profile - Windows Expert - Consumer : Bicycle - Mark Twain said it right.

System Update Readiness Command: To Fix Battery charging issue

On running the System Update readiness Command, it will Detect & Replace Incorrect Registry data with the Correct one. Which may ultimately Solve Battery charging issue in Windows.

Open CMD as Administrator by Simply Right Clicking on Start button > Command Prompt (Admin).
Now Type or Copy paste "DISM.exe /Online /Cleanup-image /Scanhealth" and hit Enter,
Now again Type or Copy paste this "DISM.exe /Online /Cleanup-image /Restorehealth" and hit Enter.
Close the Command Prompt Window because we are done.

Reboot your Windows & see if error Battery charging issue still comes up.

Note: Your administrator's password might be needed.

Wednesday, July 6, 2016

Attempting to get Windows XP run programs to run in Windows 7 [Solved]

Attempting to get Windows XP run programs to run in Windows 7

I had to recently get a new computer and was advised to get Windows 7 - that my older programs would run on it.
I am having trouble getting "Magix mp3 maker" and roxio "Easy Media Creator 9" to run. What do I need to do?

Keys to the Problem Attempting to get Windows XP run programs to run in Windows 7

Download SmartPCFixer for Free Now

Right click on program icon you wanna run Select "Properties" Select "Compatibility" Check "Run this program in compatibility mode for:" Select "Windows XP (Service Pack 3)"
You should also check if you have newest versions of programs you wanna run.
It might be that new versions of those programs are fully compatible with "Windows 7".

Microsoft Student Partner

To check for Windows updates. Open Windows Update by clicking the Start button , clicking All Programs, and then clicking Windows Update. In the left pane, click Check for updates, and then wait while Windows looks for the latest updates for your computer. If any updates are found, click Install updates.

Install the latest updates for Windows and for the program displaying the error. Note that the update for the program might be listed as an optional update on the Windows Update page.

Open Windows Update by clicking the Start button Picture of the Start button. In the search box, type Update, and then, in the list of results, click Windows Update.

Assistance with Data Entry UserForm Control Coding for Excel 2007 VBA

Hello,

Greetings and Salutations.

I have been making the rounds on the Excel Forums trying to get some help with the coding for a Data Entry User Form in 2007 Excel VBA which I have been designing.

Some back story first, then I'll post a link to a sample Workbook, and explain what I would like to have the Form do for it to be finished.

BACK STORY:
Currently I am working a Help Desk position for BoA from 1am - 9am, after which I go into a job at the local Community College to work as a Lab Tech until ~ 1:30pm-2pm, then I tutor Math, Physics, and Chemistry the rest of the afternoon.
I have been on this
daily cycle almost eight months.
About six months ago, I brought home about three boxes of Files and Records for the Oil & Gas Mineral Royalties that my Grandfather acquired over 40 years working as an Oil & Gas Attorney.
They were in complete disarray and
haven't been managed for almost a decade and a half now.

So I decided that it would be an opportunity to make enough money to pay off my debt, quit one (or two) of my jobs, and start living a normal life
.
To this end I have started the spreadsheet that you will be seeing a sample of below.
PLEASE bear this in mind while reading, as I have
Minimal experience with Excel and
None with VBA before I started to work on the User Form I have been building.
On top of that I get about 4-6 hours in on this stuff a week, and it comes out of my "Free Time"
.

Anyway.
My Spreadsheet consists of the following fields of information:
Original Owner
Heirs
County
Property Description
Assignment - Volume & Page
Affidavit of Heirship - Volume & Page
Probate - Volume & Page
Misc.
I'm creating a Data Entry User form so that I can sick my Momma and Bother on filling the spreadsheet out too.
This is really just a first step to the project, but a necessary one to be able to pull up information for specific
Owners, Heirs, or Counties and determine what is recorded where and what needs to be recorded where.

So, here is a picture of my VBA Data Entry Userform, and my Spreadsheet Fields (I have provided a Downloadable Sample Worksheet/Workbook at the end of the Post):

As you can see here, I have 3 Combo Boxes, which I have Cascade from Original Owner to
Heir to County.
Once the County has been chosen for a specific
Heir, we can fill in the Property Description, select whether or not the
Assignment, Affidavit, or Probate are Recorded or Not, and if so What
Volume and Page they are Recorded on.
Simple in essence, and this is going to be the foundation for the Spreadsheet I end up creating to organize Royalty Interests that are currently in Production, which I may end up creating an Access Database so that
I can create Relationships between what will end up being a total of Four Spreadsheets.
Question 1: It seems to me that using VBA with Excel and customizing my own User Forms, Report Forms, Reports, and Queries I shouldn't have to go to the trouble of trying to teach myself MS Access, since I can basically do everything I need
with Excel.
Given relatively small amount of information that I am recording, is this a fair assessment?

Back to the User Form, if you look at the little Sample Picture of my Spreadsheet you will see the Fields which Correlate to the fields of my User Form.
As of now, I have my Three Combo Boxes changing Heirs and County accordingly with the Original
Owner selected in the first Combo Box Drop Down.
I have also set the Cancel Button to Unload without updating changes when the Cancel Button is pressed.
That is All I have completed in the User Form.
I know it doesn't seem like much, but it took me almost
12 weeks to get this far.
Question 2: Once I have selected an Original Owner, an Heir, and a
County (for which there is only One Row that has the selected Original Owner & the selected
Heir in the selected County), how do I use this to Define the Row for which my
Property Description Text Box, and Assignment, Affidavit, and Probate Option Buttons and
Vol/Page Text Boxes will update?
Question 3: How do I set it so that when the Update Button is pressed, the changes made in the User Form update the Spreadsheet and the User Form stays, while when the Done Button is pressed the Spreadsheet is updated, and the User Form is
closed?
Question 4: Is there any specific code that needs to be used so that if I selected an Original Owner, Heir, and County where there is already a Property Description, Assignment Recorded and Vol/Page information, it automatically populated in
the correlating User Form fields?
Question 5: How do I set the Option Button to change the Assignment Cell for the Row that has the O.O-Heir-County selected in the three Combo Boxes? (For example, If I have Selected
Original Owner-Adams, Paul M.
Heir-Wilmington Trust Company...
and
County-Live Oak; This selection refers to
Row 5 and as such I only want changes to be made to Property Description, Assignment, Affidavit, and Probate Fields for
Row 5 when these three options are selected in the Combo Boxes)

I think this is really all the information I need to complete my User Form to the point where I will be able to use it to start filling out my spreadsheet, and have my Momma and Brother start doing so, with a minimum of Explanation.

Any Help that I get is greatly appreciated, as it seems that I have not bee getting any real consideration in any of the other Forums, YET
but I usually do get a few comments.
I'm really just trying to save myself spending the next 3-6 weeks continuing to work on this User Form instead of getting the Spreadsheet finished and ready
to be updated as needed, then moving on to the next stage of the project.

All the same though, here is a Sample of My Workbook with my UserForm as it currently exists:
EstateRoyaltyAssetsSample.xlsm

Solutions to the Problem Assistance with Data Entry UserForm Control Coding for Excel 2007 VBA

Download Error Fixer for Free Now

If you failed to fix it, another option is to call Microsoft and walk through the process with a technician. To do this, dial "1-800-936-5700". Explain the error that you received and the steps in the update process during which it was displayed. The technician will be able to walk through the steps from getting a new product key to finishing the installation.

Autoplay function stopped working

Original title: Plextor PX-870A DVD Burner
After I upgraded to W7 Home my autoplay function stopped working I have checked all the options and they are correct, any suggestions?

Solutions to the Problem Autoplay function stopped working

Download SmartPCFixer for Free Now

This particular error can easily be resolved with a few simple steps. However, if you are not confident in your ability to use the methods below or they do not fully remove the issue on your computer, you may want to seek the assistance of a qualified repair technician who is well versed in fixing Autoplay function stopped working.

Back-up the Registry of your operating system.
Find the Registry Key: [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\WindowsUpdate\OSUpgrade]
Note: this Registry Key should already exist, if it does not exist, create it.
Create a brand new DWORD Value that is named AllowOsUpdate
Set the Value to 0x00000001.
Close and reopen your Control Panel.
Restart the Microsoft Windows.

Another Safe way to Fix the Problem: Autoplay function stopped working:

How to Fix Autoplay function stopped working with SmartPCFixer?

1. Download Error Fixer. Install it on your system.

2. After the scan is done, you can see the errors and problems which need to be repaired.

3. When the Fixing part is done, your computer has been speeded up and the errors have been fixed

Troubleshoot:Background c colour in Excel spreadsheet Error

Background c colour in Excel spreadsheet

Using an Excel spreadsheet (MS Office 2008 edition) when I add background colour to a row of cells, the vertical divisions disappear.
How can I add background colour and keep the verticals?

Thanks,

Chris.
(Sydney Australia)

Keys to the Problem Background c colour in Excel spreadsheet

Download Error Fixer (Free)

Filling cells will always cover the grid lines.
The best you can do to simulate them is to put thin borders around the cells.

Check if there are memory problems

Memory management issues can also cause a BSOD in Windows 7. Thankfully, Windows 7 has a Memory Management Diagnostic tool that detects and solves problems related to system memory.

Click on the Start button on the Taskbar.
Type "Windows Memory Diagnostic Tool" or "Memory" (without quotes) in the Search box or,
Click on Windows Memory Diagnostic Tool (in the search results).
Click on "Restart now and check for problems (Recommended)".
The system will restart, and you need to follow the instructions given on the screen.

Backup and Restore does not find any files to restore.

After receiving my Lenovo G570 (Win7 Home Premium 64-bit) back from some serious repairs, I attempted to restore my backups from before the hardware failure.
I had misremembered the computer name that I used before, and entered a slightly different one.
Now B & R does not find any B/U's except one I did when I first got the laptop back, even if I move the older B/U to the new folder.
How do I restore these folders? (There are more than 50, many with subfolders, so manually unzipping them is likely to miss
some) The backups are on a USB portable HD, if that matters. None of the posts have a answer that works for me.
Thanks
Brent

Keys to the Problem Backup and Restore does not find any files to restore.

Download Error Fixer (Free)

Running System Update Readiness Command

On running the System Update readiness Command, it will Detect & Replace Incorrect Registry data with the Correct one. Which may ultimately Solve Backup and Restore does not find any files to restore. in Windows.

Open CMD as Administrator by Simply Right Clicking on Start button > Command Prompt (Admin).
Now Type or Copy paste "DISM.exe /Online /Cleanup-image /Scanhealth" and hit Enter,
Now again Type or Copy paste this "DISM.exe /Online /Cleanup-image /Restorehealth" and hit Enter.
Close the Command Prompt Window because we are done.

Try and see if you still get the same error Backup and Restore does not find any files to restore. in your Windows.

Note: You may be prompted to enter your administrator's password when you try to execute certain system tasks!

Wednesday, August 10, 2016

Bidirectional Bar Chart

Keys to the Problem Bidirectional Bar Chart

Recommended Method to Fix the Problem: Bidirectional Bar Chart:

How to Fix Bidirectional Bar Chart with SmartPCFixer?

Battery charging issue

Anwsers to the Problem Battery charging issue

System Update Readiness Command: To Fix Battery charging issue

Recommended Method to Repair the Problem: Battery charging issue:

How to Fix Battery charging issue with SmartPCFixer?

Wednesday, July 6, 2016

Attempting to get Windows XP run programs to run in Windows 7

Keys to the Problem Attempting to get Windows XP run programs to run in Windows 7

Recommended Method to Fix the Problem: Attempting to get Windows XP run programs to run in Windows 7:

How to Fix Attempting to get Windows XP run programs to run in Windows 7 with SmartPCFixer?

Assistance with Data Entry UserForm Control Coding for Excel 2007 VBA

Solutions to the Problem Assistance with Data Entry UserForm Control Coding for Excel 2007 VBA

Recommended Method to Repair the Problem: Assistance with Data Entry UserForm Control Coding for Excel 2007 VBA:

How to Fix Assistance with Data Entry UserForm Control Coding for Excel 2007 VBA with SmartPCFixer?

Autoplay function stopped working​

Solutions to the Problem Autoplay function stopped working​

Another Safe way to Fix the Problem: Autoplay function stopped working​:

How to Fix Autoplay function stopped working​ with SmartPCFixer?