Dll Not Found/Missing Error------Repair You Dll Errors : July 2016

Wednesday, July 6, 2016

Audio playback on ITunes [Solved]

Audio playback on ITunes

When trying to listen to ITunes I have no sound and the progress bar does not move.
When starting ITunes it tells me to reconfigure audio, can anyone help?

Keys to the Problem Audio playback on ITunes

Download SmartPCFixer to Fix It (Free)

Hello,

1.
Which operating system is installed on the computer?
2.
Were there any changes (hardware or software) made to the computer prior to the issue?

Method 1: Perform steps from the article mentioned below and see if the issue persists.
http://support.apple.com/kb/TS1371?viewlocale=en_US

Method 2: If the issue still persists, you need to post the issue in Itunes support for better assistance.
https://discussions.apple.com/community/itunes/itunes_for_windows

Hope this information helps.

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 Audio playback on ITunes 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 Audio playback on ITunes is still there.

Note: Your administrator's password might be needed.

Automatic generate enrollment number in excel

Respected solver,
I have an excel sheet on which I have three column as follows:-
    a                                           b                                         c                                 d
name                           date of admission                      branch                       enroll.
no
deepak anand                01-Jan-2011                          Kalka ji                   01/01/Jan/2011  (should be generated automatically)
Swati                                 01-Jan-2011                         Kalkaji                     01/02/Jan/2011 (should be generated automatically)
Karan                               30-Jan-2011                          Kalkaji                    01/03/Jan/2011 (should be generated automatically)
Abhimanyu                       31-Jan-2011                         G.Puri                     02/01/Jan/2011 (should be generated automatically)
Manish                             01-Feb-2011                          Kalkaji                    01/01/Feb/2011 (should be generated automatically)
Shubham                         19-Feb-2011                         G.Puri                     02/01/Feb/2011 (should be generated automatically)
and so on.
Enroll code = branch code/number of student of particular month/Month of admission/year of admission
01 is branch code, i.e.
kalkaji is first branch, and G.puri is 02nd branch
Now, what i want that enrollment no should generate automatically, is there any VBA code , function or formula?
pls help
regards.
Ayushman

Solutions to the Problem Automatic generate enrollment number in excel

Download Error Fixer (Free)

Hi,
Your English is excellent, I can understand completely.
I produced this table

deepak anand
01-Jan-2011
Kalka
01/01/Jan2011

Swati
01-Jan-2011
Kalka
01/02/Jan2011

Karan
01-Jan-2011
Kalka
01/03/Jan2011

Abhimanyu
31-Jan-2011
G.Puri
02/01/Jan2011

Manish
01-Feb-2011
Kalka
01/01/Feb2011

Shubham
19-Feb-2011
G.Puri
02/01/Feb2011

The formula which goes in the bold cell (D1) is

=VLOOKUP(C1,$Q$1:$R$10,2,FALSE)&"/"&TEXT(SUMPRODUCT((--(TEXT($B$1:B1,"mmyyyy")=TEXT(B1,"mmyyyy"))*($C$1:C1=C1))),"00")&"/"&TEXT(B1,"mmmyyyy")

Note the leading zero comes from the table in columns Q & R where column R is formatted as TEXT and a leading zero added.

Kalka
01

G.Puri
02

me
03

You
04

Him
05

Her
06

Make Sure that your Computer Meets the System Requirements

Microsoft Windows Requirements :

1 gigahertz (GHz) or faster 32-bit (x86) or 64-bit (x64) processor
1 gigabyte (GB) RAM (32-bit) or 2 GB RAM (64-bit)
16 GB available hard disk space (32-bit) or 20 GB (64-bit)

This error can be due to some configuration requirements for you system. If your computer hardware is not up to par, then make sure you upgrade where necessary before continuing.

Another Safe way to Repair the Problem: Automatic generate enrollment number in excel:

How to Fix Automatic generate enrollment number in excel with SmartPCFixer?

1. Download Error Fixer . Install it on your system. Click Scan, and it will perform a scan for your computer. The junk files will be shown in the scan result.

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

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

How to Resolve - ASCv4ExtMenu_64.dll is on my desktop and I cannot delete it without permission?

ASCv4ExtMenu_64.dll is on my desktop and I cannot delete it without permission

The above dll file is on my desktop and I cannot delete it. The error message says I need permission to delete it. I am the computer administrator. How do I get permission to delete it?

Keys to the Problem ASCv4ExtMenu_64.dll is on my desktop and I cannot delete it without permission

Download SmartPCFixer to Fix It (Free)

Thank you for your reply. From another source I got information about changing "permissions" and the problem was solved. What I do not know is what changed the permissions from the default. My Norton is supposed to prevent spyware and/or viruses.

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.

Automatically sorting a range in ascending or descending order

Hi, How can get excel to automatically sort a range i.e A1 - A100 in ascending or descending order ?

Keys to the Problem Automatically sorting a range in ascending or descending order

Download SmartPCFixer for Free Now

Have you tried...
• Select the range of cells to be sorted...including any adjacent cells that you want to sort with the sort column.
• Home.Sort...Select the type of sorting you want to do.

Does that help?

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 Automatically sorting a range in ascending or descending order 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 Automatically sorting a range in ascending or descending order in your Windows.

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

Attempting repairs

I uninstalled a program but my internet then couldn't connect to any webpage through any browser.
I did a System Restore st this point and everything was fine afterwards.
Somehow, when i was not paying attention, my account logged itself off.
I tried to
log in, but it began to lag and I couldn't press anything on the screen, i.e.
everything froze.
I turned off the computer using the switch and turned it back on, resulting in it diagnosing my PC and now attempting repairs which i know are not needed as my
computer is only 3 days old.
What do?

Anwsers to the Problem Attempting repairs

Download Error Fixer (Free)

Manually editing the Windows registry to fix Error Attempting repairs

Caution: Unless you an advanced PC user, we DO NOT recommend editing the Windows registry manually. Using Registry Editor incorrectly can cause serious problems that may require you to reinstall Windows. We do not guarantee that problems resulting from the incorrect use of Registry Editor can be solved. Use Registry Editor at your own risk.

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.

Another Safe way to Fix the Problem: Attempting repairs:

How to Fix Attempting repairs with SmartPCFixer?

1. Download SmartPCFixer . Install it on your system. Click Scan, and it will perform a scan for your computer. The errors will be shown in the scan result.

2. After the scan is done, you can see the errors and problems need to be fixed. Click Fix All.

3. The Repair part is done, the speed of your computer will be much higher than before and the errors have been removed. You can also use other functions in this software. Like dll downloading, junk file cleaning and print spooler error repair.

How to Fix - average column with blanks and zeros base on two criteria in another single column?

average column with blanks and zeros base on two criteria in another single column

Hi,

I have the following situation:

Column X contains the number of process days and can be blank, zero or a number. Column A contains various transaction types. I need to Average Column X when Column A is New or Renew, but also discard blanks and zeros in column X to get an accurate average.

Col A            Col X
New             10
Renew           0
Canc              3
Renew           5
Reins                 (reins is blank)

I need my result to be 7.5 (10+5/2)

Also, if the calculation is 0/0 prevent the #DIV/0! by displaying 0 instead.

I tried this formula but it doesn't like the "'s around "<>"&0 and when I remove them, then it still doesn't work.

=IFERROR(SUM(SUMIF(X2:X10000,A2:A10000,"NEW","RENEW)))/SUM(COUNTIF(X2:X10000,"<>"&0),A2:A10000,"NEW","RENEW)),0)

Any help is greatly appreciated!!

Solutions to the Problem average column with blanks and zeros base on two criteria in another single column

Download Error Fixer for Free Now

(I did not include all the categories in my sample)

This is never a good idea and only serves to confuse the issue.
Abandon everything I've offered up to this point and start over.

The new, expanded requirements cannot be most efficiently fulfilled with a single style of formula and in any event, the originally supplied formula is not suited for multiple groups of lookup criteria.

If you want to find the average for a single match in column A but greater than zero in column X then an AVERAGEIFS() is your best recourse.
The formula in AB4 is,

=AVERAGEIFS(X2:X20,X2:X20,">"&0,A2:A20,AA4)

However, if you want to average the matching entries in column A to two (or more) possibilities, you should move to an
array formula.
The formula in AB2 is,

=AVERAGE(IF(X2:X20>0,IF(ISNUMBER(MATCH(A2:A20,"New","Renew",0)),X2:X20)))

...
which requires Ctrl+Shift+Enter rather than just Enter.
The formula in AB3 is,

=AVERAGE(IF(X2:X20>0,IF(ISNUMBER(MATCH(A2:A20,"Canc","Reins",0)),X2:X20)))

...
which requires Ctrl+Shift+Enter rather than just Enter.

In this method we will try to Boot in Safe mode with Networking and see if the error still persists.

Search "MSCONFIG" and Open.
Click on Boot Tab
Tick Safe Boot in Boot Option
Select Network.
Click Apply and OK.
Reboot your System.

Backup issues with a new Netbook and Windows 7 Starter

I bought a Toshiba Netbook with Win 7 starter and an external CD/DVD reader/writer
I was able t6o make the recovery discs and a repair disc without issuse
I cannout make a system image or a backup from the Restore control panel.
Prior to attempting to make the discs I ran Protective software scan: (microsoft security Esentials, Spybot S&D and Avira Antivirus) Only Spybot found something. I cleaned the computer and rechecked to make sure it was clean.
Error messages: System Image: The progress bar says "verifying disc 1" then I get a pop up, "Windows has found an error.
The disc cannot be used" I have tried three different discs and get the same message each time.
The backup appears to be frozen at 51%.
Please help
Wheels8

Keys to the Problem Backup issues with a new Netbook and Windows 7 Starter

Download Error Fixer (Free)

Hi Wheels,
Put your computer in clean boot to check if the issue is caused by third party software.
How to troubleshoot a problem by performing a clean boot in Windows Vista
http://support.microsoft.com/kb/929135
After checking the issue, put the computer back to theNormal mode.
Uninstall or update the program which is causing the issue.
Bindu R-Microsoft Support

Use the System File Checker tool to repair corrupted or missing system files:

Click Start.
Type cmd, and then press CTRL+SHIFT+ENTER to open the elevated command prompt (I.e. Command prompt with administrative rights).
The User Account Control window should appear, be sure that the action it exhibits is correct, and then press the Continue button.
Type or copy paste the below command line into it without quotes:
"Sfc /scannow"

Another Safe way to Fix the Problem: Backup issues with a new Netbook and Windows 7 Starter:

How to Fix Backup issues with a new Netbook and Windows 7 Starter with SmartPCFixer?

1. Click the button to download SmartPCFixer . Install it on your computer. Open it, and it will perform a scan for your system. The junk files will be shown in the scan result.

2. After the scan is finished, you can see the errors and problems need to be repaired. Click Fix All.

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

Troubleshooting:Autofit the row height when there are merged cells Error

Autofit the row height when there are merged cells

Hi, I understand that you can't autofit the row height when there are merged cells, but I found the code below that allows you to set up a worksheet change event for the cells in question, which are named "OrderNote".
This is great, but there's 1 tweak that I need and am hoping somebody can help me by inserting. Due to the font/pitch I'm using, Excel figures each row's height should be 17 pixels, but I want it to be 20 pixels to match the rest of the tab.
Thank you in advance - I really appreciate it.

Private Sub Worksheet_Change(ByVal Target As Range)
Dim MergeWidth As Single
Dim cM As Range
Dim AutoFitRng As Range
Dim CWidth As Double
Dim NewRowHt As Double
Dim str01 As String
str01 = "OrderNote"

If Not Intersect(Target, Range(str01)) Is Nothing Then
    Application.ScreenUpdating = False
    On Error Resume Next
    Set AutoFitRng = Range(Range(str01).MergeArea.Address)

    With AutoFitRng
      .MergeCells = False
      CWidth = .Cells(1).ColumnWidth
      MergeWidth = 0
      For Each cM In AutoFitRng
          cM.WrapText = True
          MergeWidth = cM.ColumnWidth + MergeWidth
      Next
      'small adjustment to temporary width
      MergeWidth = MergeWidth + AutoFitRng.Cells.Count * 0.66
      .Cells(1).ColumnWidth = MergeWidth
      .EntireRow.AutoFit
      NewRowHt = .RowHeight
      .Cells(1).ColumnWidth = CWidth
      .MergeCells = True
      .RowHeight = NewRowHt
    End With
    Application.ScreenUpdating = True
End If

End Sub

Anwsers to the Problem Autofit the row height when there are merged cells

Download Error Fixer (Free)

Access the files on your computer via MY COMPUTER
Under the C: drive, access the WINDOWS folder
Select the SOFTWARE DISTRIBUTION folder, followed by the DOWNLOAD folder.
Delete any files within this download folder.
If you are unable to delete these files, open the command prompt (CMD) as the administrator, and type "net stop wuauserv" into the CMD prompt window. Press ENTER. This should allow you to delete the files from step 4.
Once the files are deleted, open and run the CMD as the administrator and type "wuauclt.exe /updatenow". Press ENTER.

Another Safe way to Fix the Problem: Autofit the row height when there are merged cells:

How to Fix Autofit the row height when there are merged cells with SmartPCFixer?

1. You can Download Error Fixer here. Install it on your computer. When you open it, it will perform a scan.

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

3. The Fixing part is done, the speed of your computer will be much higher than before and the errors have been removed.

Fast Solution to Error: auto sort after adding entry

auto sort after adding entry

I created excel file (columns A:O) with my annual expenses. I would like to sort this file by column B, then column A in descending order every time I make entry to existing worksheet.
I don’t like to use/create macro, I would prefer that every time I make entry column B (total amount) will be sorted automatically.

Thanks

Solutions to the Problem auto sort after adding entry

Download Error Fixer (Free)

Manually editing the Windows registry

Manually editing the Windows registry to remove invalid MACHINE_CHECK_EXCEPTION keys is not recommended unless you are PC service professional. Incorrectly editing your registry can stop your PC from functioning and create irreversible damage to your operating system. In fact, one misplaced comma can prevent your PC from booting entirely!

Caution: Unless you an advanced PC user, we DO NOT recommend editing the Windows registry manually. Using Registry Editor incorrectly can cause serious problems that may require you to reinstall Windows. We do not guarantee that problems resulting from the incorrect use of Registry Editor can be solved. Use Registry Editor at your own risk.

To manually repair your Windows registry, first you need to create a backup by exporting a portion of the registry related to MACHINE_CHECK_EXCEPTION (eg. Windows Operating System):

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.

Wednesday, July 6, 2016

Audio playback on ITunes

Keys to the Problem Audio playback on ITunes

Running System Update Readiness Command

Recommended Method to Fix the Problem: Audio playback on ITunes:

How to Fix Audio playback on ITunes with SmartPCFixer?

Automatic generate enrollment number in excel

Solutions to the Problem Automatic generate enrollment number in excel

Make Sure that your Computer Meets the System Requirements

Another Safe way to Repair the Problem: Automatic generate enrollment number in excel:

How to Fix Automatic generate enrollment number in excel with SmartPCFixer?

ASCv4ExtMenu_64.dll is on my desktop and I cannot delete it without permission

Keys to the Problem ASCv4ExtMenu_64.dll is on my desktop and I cannot delete it without permission

Recommended Method to Repair the Problem: ASCv4ExtMenu_64.dll is on my desktop and I cannot delete it without permission:

How to Fix ASCv4ExtMenu_64.dll is on my desktop and I cannot delete it without permission with SmartPCFixer?

Automatically sorting a range in ascending or descending order

Keys to the Problem Automatically sorting a range in ascending or descending order

Running System Update Readiness Command

Recommended Method to Repair the Problem: Automatically sorting a range in ascending or descending order:

How to Fix Automatically sorting a range in ascending or descending order with SmartPCFixer?

Attempting repairs

Anwsers to the Problem Attempting repairs

Another Safe way to Fix the Problem: Attempting repairs:

How to Fix Attempting repairs with SmartPCFixer?

average column with blanks and zeros base on two criteria in another single column

Solutions to the Problem average column with blanks and zeros base on two criteria in another single column

In this method we will try to Boot in Safe mode with Networking and see if the error still persists.

Recommended Method to Fix the Problem: average column with blanks and zeros base on two criteria in another single column:

How to Fix average column with blanks and zeros base on two criteria in another single column with SmartPCFixer?

Backup issues with a new Netbook and Windows 7 Starter

Keys to the Problem Backup issues with a new Netbook and Windows 7 Starter

Use the System File Checker tool to repair corrupted or missing system files:

Another Safe way to Fix the Problem: Backup issues with a new Netbook and Windows 7 Starter:

How to Fix Backup issues with a new Netbook and Windows 7 Starter with SmartPCFixer?

Autofit the row height when there are merged cells

Anwsers to the Problem Autofit the row height when there are merged cells

Another Safe way to Fix the Problem: Autofit the row height when there are merged cells:

How to Fix Autofit the row height when there are merged cells with SmartPCFixer?

auto sort after adding entry

Solutions to the Problem auto sort after adding entry

Recommended Method to Fix the Problem: auto sort after adding entry:

How to Fix auto sort after adding entry with SmartPCFixer?