How Can You Recover Samsung Tablet?: March 2016

Thursday, March 31, 2016

How to Fix - Adding a date in two calculations, firstly 28 days, second calculation for 6 months?

Adding a date in two calculations, firstly 28 days, second calculation for 6 months

I have a specific date which alters dependent upon the person for a renewal scheme, i need to add 6 months to this renewal date and i also need to run a secon calculation for 28 days for the renewal process.
I am running 2007, the formulas online dont
seem to work.
Stumped.

Solutions to the Problem Adding a date in two calculations, firstly 28 days, second calculation for 6 months

Download SmartPCFixer for Free Now

Hi, not sure what you need, let' say you have a date in cell A2 and want to add 28 days, just do
=A2+28
or
=A2+180 to add 6 month

Run CHKDSK

Go to the Start button.
In the Search box, type "cmd" (without quotes) and press Enter.
At the command prompt, type "chkdsk /r /f" (without quotes) and press Enter.
Reboot your computer.

Another Safe way to Repair the Problem: Adding a date in two calculations, firstly 28 days, second calculation for 6 months:

How to Fix Adding a date in two calculations, firstly 28 days, second calculation for 6 months with SmartPCFixer?

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

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

3. The Repair part is finished, the speed of your computer will be much higher than before and the errors have been removed. You can also use other functions in SmartPCFixer. Like dll downloading, windows updating and print spooler error repair.

How to Fix Error - Adding Check boxes to MS Word 2007?

Adding Check boxes to MS Word 2007

Hi there-

I have been given a project at work that I truly have no idea where to start.
I am trying to add check boxes to a document in MS Word 2007.
I understand how to insert them, however I am hoping to add a little more to it.
I would like some kind of functionality
where when someone checks a box, additional text comes up that will allow the user to answer more questions, and will disappear if they uncheck the box.
Is this even something that can be done in MS Word? I am feeling entirely overwhelmed and my searches have
been fruitless so far.
Any help will be greatly appreciated.

Keys to the Problem Adding Check boxes to MS Word 2007

Download Error Fixer (Free)

What you ask is certainly possible, but how you approach it would rather depend on what the end result is intended to be and how the end result will be used.

If the aim is to produce a document that is to be printed with values in the document dependent on selections made, then I would be inclined not to use check boxes in the document, but to create a userform in which the user makes the selections and from there
the document is created according to the selections made.

See http://www.gmayor.com/Userform.htm and then when you have the idea of the concept in mind, you can move on to

http://gregmaxey.mvps.org/word_tip_pages/populate_userform_listbox_or_combobox.html

Open Action Center by clicking the Start button Picture of the Start button, clicking Control Panel, and then, under System and Security, clicking Review your computer's status.

Update and run your antivirus software. Windows doesn't come with antivirus software, but Action Center can often monitor the antivirus software that you or your computer manufacturer have installed.

Adjusting volume causes Windows Explorer to freeze

Hello all,

An issue that I continue to encounter is one that involves the volume controls on my laptop.
Every now and then, when I attempt to adjust the volume of my computer, Windows Explorer will freeze.
When I attempt to click on the explorer bar, I am informed
that "Windows has stopped working", and I am given the option of restarting it, closing it, or waiting for it to respond.
I can close or restart it and the bar will unfreeze, but any time I attempt to adjust the volume after this first occurrence will result
in another freeze.
Adjusting the volume by the physical volume knob on my laptop or the virtual volume mixer will produce the same result.

Here are some specs...

Software: Windows 7 home premium (32-bit)
Hardware: Toshiba Satellite A205-S4577

This is an issue that occurs erratically, but tends to happen more frequently when the laptop is unplugged.

Can anyone provide any advice?

Solutions to the Problem Adjusting volume causes Windows Explorer to freeze

Download SmartPCFixer for Free Now

Thank you, Pranav-

I actually received a response from Windows Technical Support earlier and it solved the issue!

In this case, they advised that I:

First, back up all files.

Next, do a quick virus scan to search for threats.
A few should be ok, but 10 or more is an issue.

Then, do a system file scan to search for any system files that may be corrupted.
The scan will detect and repair them.
To do so:
Open an elevated command prompt.
To do this, click Start, click All Programs, click Accessories, right-click Command Prompt, and then click Run as administrator.
If you
are prompted for an administrator password or for a confirmation, type the password, or click Allow.At the command prompt, type the following command, and then press ENTER: sfc /scannow

And that solved it for me!

Open Action Center by clicking the Start button Picture of the Start button, clicking Control Panel, and then, under System and Security, clicking Review your computer's status.

Update and run your antivirus software. Windows doesn't come with antivirus software, but Action Center can often monitor the antivirus software that you or your computer manufacturer have installed.

ADODB.Connection for Access 2007 database

Can you help me please.
I am tring to make a connection to a 2007 format access database.
The code I picked up from a previous answer works fine with an .mdb database but not with a .accdb.
How should I amend the code please

Dim cn As ADODB.Connection, rs As ADODB.Recordset, r As Long
    ' move to data return sheet

    ' connect to the Access database
    Set cn = New ADODB.Connection
    cn.Open "Provider=Microsoft.Jet.OLEDB.4.0; " & _
        "Data Source=D:\documents\Jam\CTS\Community Vision\August 11\temp.mdb;"
    ' open a recordset
    Set rs = New ADODB.Recordset
    rs.Open "sheet1", cn, adOpenKeyset, adLockOptimistic, adCmdTable

Thanks

Judith

Keys to the Problem ADODB.Connection for Access 2007 database

Download SmartPCFixer for Free Now

cn.Open "Provider=Microsoft.ACE.OLEDB.12.0; " & _
"Data Source=D:\documents\Jam\CTS\Community Vision\August 11\temp.accdb;"

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.

Another Safe way to Repair the Problem: ADODB.Connection for Access 2007 database:

How to Fix ADODB.Connection for Access 2007 database 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. The Fixing part is finished, the speed of your computer will be much higher than before and the errors have been removed.

How to Resolve - Adding a Data Table that is showing one specific information?

Adding a Data Table that is showing one specific information

I have the sales figures of my top product portfolio for years 2009- 2010.
In the chart I would like to show just the volume increase-decrease on the chart without ´percentages in a secondary axis.
But I would like to add a Data Table below that the chart
that is showing deviation between these 2 years as a percentage.

2009
2010
Dev.
2010-2009

k
100
130
30%

m
50
60
20%

n
75
80
7%

the number are comparised on the chart whereas percentage is wriite below the chart.
Thanks

Keys to the Problem Adding a Data Table that is showing one specific information

Download SmartPCFixer to Fix It (Free)

You will not be able to add specific data tables, the data tables will be corresponding to the chart information
You may refer the link mentioned below, might be helpful
http://office.microsoft.com/en-us/excel-help/show-or-hide-a-chart-legend-or-data-table-HP010007432.aspx

Run CHKDSK

Go to the Start button.
In the Search box, type "cmd" (without quotes) and press Enter.
At the command prompt, type "chkdsk /r /f" (without quotes) and press Enter.
Reboot your computer.

An error might pop up:

"Access denied as you do not have significant privileges. You have to invoke this utility in elevated mode."

If you receive the above error message, it means you are not logged into you computer as an Administrator. If that's the case, follow these steps to run the command prompt in elevated mode:

Go to theStart button.
Go to "All Programs > Accessories" and right click on "Command Prompt".
Select "Run as Administrator".
In the Search box, type "cmd" (without quotes) and press Enter.
At the command prompt, type "chkdsk /r /f" (without quotes) and press Enter.
Reboot your computer.

Adding the "move window" function in the the Task Bar

In Windows XP, there was a previous option of moving the window when right clicking on an application in the taskbar. This was especially helpful when using dual monitors, one as a primary and ocassionally using the secondary. When the second monitor
is off, applications still load in that space, so the move function in the taskbar, was a quick way to get the application back into the primary monitor. For the most part, I enjoy the new task bar (except for the removal of quick launch, which fortuantely
has a workaround).

Is there a way to get the move function back when right clicking on an application? The workaround I use now is using keyboard shortcuts, but takes more time and requires memorizing the shortcut (alt-space, down arrow, hold direction arrow wanted).

Keys to the Problem Adding the "move window" function in the the Task Bar

Download SmartPCFixer to Fix It (Free)

Isn't still available?

Hover your mouse over the tasbar icon of the application (the thumbnail preview appears) > right click on the thumbnail preview > select Move > hold the button and move the window.

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"

Adding a choice to a drop-down list within a template-style workbook

I have created an Excel Workbook that is a template for another user. Within the workbook, I have various drop-down lists. I created these using another worksheet in the same workbook (by defining the list and then using the data validation tool).
I want to allow users of this workbook to be able to add additional items to the drop-down lists without needing to first add to the list on the other worksheet. Is it possible to add to these drop-down lists by typing directly into the drop-down cell (have
the information automatically populate into the list)?
Thanks!

Solutions to the Problem Adding a choice to a drop-down list within a template-style workbook

Download Error Fixer (Free)

With the built in feature, we can only limit the user entering the data in excel using the data validation.
However, this may be possible using VBA code.

Sachin Shetty

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.

After I did a system restore the compatablity changed. What happened?

I got a virus so I restored my computer to a previous date of the day before.
When it finished I had noticed desktop icons are gone and almost everything I download cant run and says "The version of this file is not compatible with the version of windows
you are running.
Check your computer's system information to see weather you need x86 (32-Bit) or x86 (64-bit) versions of the program and contact the software publisher."

This is happening to a lot of programs that worked fine before.
I just bought this computer and use it mainly for gaming.
I paid a lot of money for it so I would assume it comes with a 64 bit operating system, but when I go to the setting my only options
are 16 and 32 bit.

Anwsers to the Problem After I did a system restore the compatablity changed. What happened?

Download Error Fixer for Free Now

Windows Error Reporting - To Fix After I did a system restore the compatablity changed. What happened?

Go to Start button.
Open Control Panel.
Go to Windows Error Reporting.
Click on System and Maintenance, then click Problem Reports and Solutions.
Next, click Change Settings located on the left side panel of the Problem Reports and Solutions window.
Select an option to configure how you want Windows to look for a solution to your problems. You may allow Windows to do it automatically or ask you every time to check if problem occurs.
Next, click the Advanced settings link.
Select Off to turn off Error Reporting.

Another Safe way to Repair the Problem: After I did a system restore the compatablity changed. What happened?:

How to Fix After I did a system restore the compatablity changed. What happened? with SmartPCFixer?

1. Click the button to download SmartPCFixer . Install it on your computer. Open it, 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 need to be fixed. Click Fix All.

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

Troubleshoot:Address Change in Excel Database to Word Label Doc Merge

Address Change in Excel Database to Word Label Doc Merge

My question has to do with changes/updates to data fields in a labels Mail Merge between Excel and Word. I have an Excel address database that I use each year for my holiday cards. I have merged it to a Word labels document. I thought that if I made changes
to the Excel database (i.e., someone has moved and has a new address), that those changes would automatically show up in the Word Labels doc that is associated with that Excel database. I made a change to the Excel database to test this theory and it did
not work.

Does anyone know why this did not work -- or how I make it work?

Thanks very much!

Solutions to the Problem Address Change in Excel Database to Word Label Doc Merge

Download SmartPCFixer for Free Now

If you mean the document that results from finishing the mail merge, that is static - it won't reflect changes in the source data.
If you still have the merge document that contains the merge fields, you can run the mail merge again, and the document generated by this will be up-to-date for this year.

Tweak IE Options

Open Internet Explorer.
Go to "Tools > Internet Options > Advanced Tab".
Uncheck "Enable third-party browser extensions".
Click "Apply".
Reboot your computer.

Thursday, March 31, 2016

Adding a date in two calculations, firstly 28 days, second calculation for 6 months

Solutions to the Problem Adding a date in two calculations, firstly 28 days, second calculation for 6 months

Another Safe way to Repair the Problem: Adding a date in two calculations, firstly 28 days, second calculation for 6 months:

How to Fix Adding a date in two calculations, firstly 28 days, second calculation for 6 months with SmartPCFixer?

Adding Check boxes to MS Word 2007

Keys to the Problem Adding Check boxes to MS Word 2007

Recommended Method to Repair the Problem: Adding Check boxes to MS Word 2007:

How to Fix Adding Check boxes to MS Word 2007 with SmartPCFixer?

Adjusting volume causes Windows Explorer to freeze

Solutions to the Problem Adjusting volume causes Windows Explorer to freeze

Recommended Method to Fix the Problem: Adjusting volume causes Windows Explorer to freeze:

How to Fix Adjusting volume causes Windows Explorer to freeze with SmartPCFixer?

ADODB.Connection for Access 2007 database

Keys to the Problem ADODB.Connection for Access 2007 database

Another Safe way to Repair the Problem: ADODB.Connection for Access 2007 database:

How to Fix ADODB.Connection for Access 2007 database with SmartPCFixer?

Adding a Data Table that is showing one specific information

Keys to the Problem Adding a Data Table that is showing one specific information

Run CHKDSK

Recommended Method to Repair the Problem: Adding a Data Table that is showing one specific information:

How to Fix Adding a Data Table that is showing one specific information with SmartPCFixer?

Adding the "move window" function in the the Task Bar

Keys to the Problem Adding the "move window" function in the the Task Bar

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

Recommended Method to Repair the Problem: Adding the "move window" function in the the Task Bar:

How to Fix Adding the "move window" function in the the Task Bar with SmartPCFixer?

Adding a choice to a drop-down list within a template-style workbook

Solutions to the Problem Adding a choice to a drop-down list within a template-style workbook

Recommended Method to Repair the Problem: Adding a choice to a drop-down list within a template-style workbook:

How to Fix Adding a choice to a drop-down list within a template-style workbook with SmartPCFixer?

After I did a system restore the compatablity changed. What happened?

Anwsers to the Problem After I did a system restore the compatablity changed. What happened?

Windows Error Reporting - To Fix After I did a system restore the compatablity changed. What happened?

Another Safe way to Repair the Problem: After I did a system restore the compatablity changed. What happened?:

How to Fix After I did a system restore the compatablity changed. What happened? with SmartPCFixer?

Address Change in Excel Database to Word Label Doc Merge

Solutions to the Problem Address Change in Excel Database to Word Label Doc Merge

Recommended Method to Fix the Problem: Address Change in Excel Database to Word Label Doc Merge:

How to Fix Address Change in Excel Database to Word Label Doc Merge with SmartPCFixer?