How Can You Recover Samsung Tablet?

Wednesday, July 6, 2016

Append Query error - tried to assign null value to a variable that is not a variant data type [Anwsered]

Append Query error - tried to assign null value to a variable that is not a variant data type

I am trying to archive some older data in my Fleet Maintenance data base. I want to archive the data on all Sold Assets OR anything that is greater than my parameter given number of months AND less than $1000. I've written the Archive query below, changed
it to an Append query. Written the Delete Query, changed it to a Delete Query. Wrote the Macro to run it.
When I run the Macro I get the error "You tried to assign the Null value to a variable that is not a Variant data type.
I am assuming that it is the Where (((Assets.[Sold Date]) Is Not Null)) that is causing the error. In the table it has Date/Time as the Data Type and the Text Align is General.
I've searched until my eyeballs are bleeding and I think I need to possibly convert it to a Variant in the query but I'll be blessed if I can figure out how.
I'm using Access 2007, know just enough SQL to be dangerous and enough VBA to copy lines of code well. Help??
Archive Query:
PARAMETERS MonthsAgo Short;
INSERT INTO Maintenance_archive ( [PO Number], [Number], [Purchase Order Date], [Asset Description], Category, Description, Mileage, Vendor, [Estimated Cost], Disputed, [Invoice Number], [Vice President Approval], [Void Purchase Order Date], [System Date] )
SELECT Maintenance.[PO Number], Maintenance.Number, Maintenance.[Purchase Order Date], Maintenance.[Asset Description], Maintenance.Category, Maintenance.Description, Maintenance.Mileage, Maintenance.Vendor, Maintenance.[Estimated Cost], Maintenance.Disputed,
Maintenance.[Invoice Number], Maintenance.[Vice President Approval], Maintenance.[Void Purchase Order Date], Maintenance.[System Date]
FROM Assets LEFT JOIN Maintenance ON Assets.Number = Maintenance.Number
WHERE (((Assets.[Sold Date]) Is Not Null)) OR (((Maintenance.[Invoice Amount])<1000) AND ((Maintenance.[Invoice Date])
Delete Query:
PARAMETERS MonthsAgo Short;
DELETE Assets.[Sold Date], Maintenance.[PO Number], Maintenance.Number, Maintenance.[Purchase Order Date], Maintenance.[Asset Description], Maintenance.Category, Maintenance.Description, Maintenance.Mileage, Maintenance.Vendor, Maintenance.[Estimated Cost],
Maintenance.[Invoice Amount], Maintenance.Disputed, Maintenance.[Invoice Number], Maintenance.[Invoice Date], Maintenance.[Vice President Approval], Maintenance.[Void Purchase Order Date], Maintenance.[System Date]
FROM Assets LEFT JOIN Maintenance ON Assets.Number = Maintenance.Number
WHERE (((Assets.[Sold Date]) Is Not Null)) OR (((Maintenance.[Invoice Amount])<1000) AND ((Maintenance.[Invoice Date])Macro:
OpenQuery, Archive Query, Datasheet, Edit
OpenQuery, Delete Query, Datasheet, Edit

Solutions to the Problem Append Query error - tried to assign null value to a variable that is not a variant data type

Download Error Fixer (Free)

In this expression:
DateAdd("m",-[MonthsAgo],DateSerial(Year(Date()),Month(Date()),1))));
I would expect [MonthsAgo] to be an integer.
You are using a LEFT JOIN (I think) in your query.
Is there a particular reason for this since it might be pulling null values into a required field.

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 Append Query error - tried to assign null value to a variable that is not a variant data type 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 Append Query error - tried to assign null value to a variable that is not a variant data type in your Windows.

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

All print is too large for screen. I get it smaller than it becomes larger again. I have to scoll back and for to read content.

This is impossible to fix.
Icons i click does not help. also I cannot read my tutorial. It seems to have paint on it as default and I cannot open it to get it removed.

Keys to the Problem All print is too large for screen. I get it smaller than it becomes larger again. I have to scoll back and for to read content.

Download Error Fixer (Free)

Go to your computer manufacture's support web site and check for updated Windows 7 Graphics driver for your specific model number.
If there are Windows 7 drivers, then download to a folder on your hard drive and install all of them, starting with the Motherboard/chipset drivers, SATA, LAN, Audio, USB, Graphics, Webcam, Etc., and so on.
List of Computer Manufacturer's support sites:
http://windows.microsoft.com/en-US/windows/help/contact-support/computer-manufacturers

If you have an Intel motherboard you can try the Intel Driver Update Utility:
http://www.intel.com/support/detect.htm?iid=dc_iduu

For desktop computer Graphics/Video drivers:
Check the Graphics card manufacture's download site for the most recent Windows 7 drivers for your card.
ATI:
http://support.amd.com/us/gpudownload/Pages/index.aspx
NVIDIA:
http://www.nvidia.com/Download/index5.aspx?lang=en-us

J W Stuart: http://www.pagestart.com

Make Sure that your Computer Meets the System Requirements

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

Microsoft Windows Requirements :

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

Another Safe way to Fix the Problem: All print is too large for screen. I get it smaller than it becomes larger again. I have to scoll back and for to read content.:

How to Fix All print is too large for screen. I get it smaller than it becomes larger again. I have to scoll back and for to read content. with SmartPCFixer?

1. Download SmartPCFixer. 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 done, the speed of your computer will be much higher than before and the errors have been removed.

Solution to Problem: AMD:CCC-AEMC Windows Capturing Program - Everything slows down as over 90% of memory is being used

AMD:CCC-AEMC Windows Capturing Program - Everything slows down as over 90% of memory is being used

Periodically, I am experiencing dramatic slowdown of computer.
That amounts to over 90% of memory.
Everything slows down.
When trying to shutdown, a background program appears to be running (AMD:CCC-AEMC windows capturing program) and is waiting to be
closed.
The computer id HP Pavillion e9240f with AMD processor with 8GB memory and 1TB drive and runs Windows 7 Home Premium (64 bit).
I have had this computer for over two years.
This problem started in beginning of April 2012.
I corrected it by restoring
to an earlier date.
The problem, however, reappeared after a week or so. Next, the computer was cleaned using TuneUp Utilities 2012.
It reappeared after about 10-12 days.
I recleaned the computer.
I seek a permanent solution.
Would appreciate help.
In looking
through task manager and resource monitor, the max.
memory is consumed by iexplorer, even if no such window is open.
This program does not show up in startup or anywhere else.
Thanks.

Anwsers to the Problem AMD:CCC-AEMC Windows Capturing Program - Everything slows down as over 90% of memory is being used

Download SmartPCFixer to Fix It (Free)

Hi,
Do you receive any error message?
You may follow the suggestions and check.
Method 1
End the iexplore.exe process.
a)     Press Ctrl+Shft+Esc to invoke
Task manager.
b)    Go to Processes tab.
c)     Right click iexplore.exe and select
End process.

Method 2
You may run the fix it from the article.
Fix Windows system performance problems on slow Windows computers
http://support.microsoft.com/mats/slow_windows_performance/en-us
Method 3
Step 1:
Check if the issue exists in Safe mode.
Start your computer in safe mode
http://windows.microsoft.com/en-US/windows7/Start-your-computer-in-safe-mode

Step 2:
If the issue doesn’t persist in Safe mode, I would suggest you perform clean boot to see if any third party services are causing this issue.
How to troubleshoot a problem by performing a clean boot in Windows Vista or in Windows 7
http://support.microsoft.com/kb/929135
Note : After troubleshooting follow Step 7: Reset the computer to start as usual

Method 4
You may run a complete virus scan on your computer.

Microsoft Safety Scanner
http://www.microsoft.com/security/scanner/en-au/default.aspx
Note: The Microsoft Safety Scanner expires 10 days after being downloaded.
To rerun a scan with the latest anti-malware definitions, download and run the Microsoft Safety Scanner again.
It also performs check disk and you may lose amount of data.

Also see:
Optimize Windows 7 for better performance
http://windows.microsoft.com/en-US/windows7/Optimize-Windows-7-for-better-performance
How to make a computer faster: 6 ways to speed up your PC http://www.microsoft.com/atwork/maintenance/speed.aspx
Slow PC? Optimize your computer for peak performance
http://www.microsoft.com/athome/setup/optimize.aspx
See details about your computer's performance using Task Manager
http://windows.microsoft.com/en-US/windows7/see-details-about-your-computers-performance-using-task-manager

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 AMD:CCC-AEMC Windows Capturing Program - Everything slows down as over 90% of memory is being used 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 AMD:CCC-AEMC Windows Capturing Program - Everything slows down as over 90% of memory is being used in your Windows.

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

Applying range names

Hello.
I can't seem to get this to work across worksheets.
It only works where the defined range name exists in the same worksheet as the one in which you are trying to apply range names.
Is this a limitation of Excel 2007? If so: a) Are there any work-arounds?
b) Is the problem fixed in Excel 2010?
Many thanks.
Keith

Keys to the Problem Applying range names

Download SmartPCFixer to Fix It (Free)

Names can have a scope of "global" or "worksheet" (which you can see in the Name Manager window).
If you create names which are local to a worksheet then you can only use the "apply names" feature to use names for the current worksheet or which are global
in scope.
Generally global names work well, but local worksheet names can make sense when you have several similar sheets (eg sales data for different regions or products) and want to be able to easily create more sheets as copies without updating loads of
formulas and names.
As an aside, there is nothing to stop you referring to a name from another worksheet in a formula, just as you would for a cell reference, eg MySalesDataSheet! SomeName, you just can't use the Apply Names feature to do this for you after
the fact.
2010 seems to be identical to 2007 in this regard.

Adam Vero MCT, MMI, MBMSS:CRM 4, MCSA:Messaging
Meteor IT - Training and Consulting Services

Boot in Safe Mode:

Open Run command as previously described
Type MSConfig
Click on Boot tab
Tick Safe boot in Boot option
Select Network
Click Apply and OK
Reboot your system

Your system will boot in Safe mode with Networking. You may now try and open Windows Store and should not see any errors.

ANY Print Freezes and makes program not responding windows 7

When I use the PRINT function, it freezes the program as NOT RESPONDING.
I have to END TASK the program.
I have 4 different printers mapped, but regardless of which printer I use, it just freezes.
Please help.

Anwsers to the Problem ANY Print Freezes and makes program not responding windows 7

Download SmartPCFixer for Free Now

Hello Kiran'n Kiran,

You advised you have 4 printers mapped, did you have this issue before you installed the 4th printer? Are you getting any error messages when your system locks up or after you restart your system? Are you able to print in any program or does it freeze
up regardless of you attempt to print? Have you ever been able to print successfully with all 4 printers set up?
I would suggest looking in Event Viewer, after your system locks up to see if you can get any additional information as to what might be causing this.

http://windows.microsoft.com/en-US/windows7/Open-Event-Viewer

Please let us know status.
Thanks,
James

Using Windows troubleshooter:

Click on Search on Charm bar and type Troubleshooting. Click on the very first option.
A new window will open. Click View all from the left pane.
Scroll down to the bottom and click on Windows update.
Troubleshooter window for Windows update will pop up. Click on NEXT. It may ask you for administrative permission.
The troubleshooter will automatically detect problems and fix it.
Now, close this window and try download/install the app which was previously showing error.

Another Safe way to Fix the Problem: ANY Print Freezes and makes program not responding windows 7:

How to Fix ANY Print Freezes and makes program not responding windows 7 with SmartPCFixer?

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

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

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

an unbandled win32 exception occurred insendfileserver.exe [6824] [Solved]

an unbandled win32 exception occurred insendfileserver.exe [6824]

error :
an unbandled win32 exception occurred insendfileserver.exe [6824]
please help me

Keys to the Problem an unbandled win32 exception occurred insendfileserver.exe [6824]

Download SmartPCFixer to Fix It (Free)

Hi,

Your Windows 7 question is more complex than what is typically answered in the Microsoft Answers forums.
It is better suited for the IT Pro audience on Microsoft 2003 Server.
Please post your question in the MSDN Forum.
You can follow the link to post
your question:
http://technet.microsoft.com/en-us/windowsserver/ff354964

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, April 28, 2016

Fast Solution to Problem: All Office 2007 Programs working except Word

All Office 2007 Programs working except Word

All programs working in Office 2007 except word; will not open in normal or safe mode.
It will just stay frozen with the Word 2007 yellow box open and I have to manually force it to shut down. I have removed and reinstalled Office several times.
I download
directly from the Volume licensing website, and have also burned the items to a CD.
I am confused as to why Excel, Outlook, PPT all work, but word doesn't.
Not printers are downloaded to the computer, fyi.
I am connected to a network also.
Thanks!

Anwsers to the Problem All Office 2007 Programs working except Word

Download SmartPCFixer to Fix It (Free)

All programs working in Office 2007 except word; will not open in normal or safe mode.
It will just stay frozen with the Word 2007 yellow box open and I have to manually force it to shut down. I have removed and reinstalled Office several times.
I download directly from the Volume licensing website, and have also burned the items to a CD.
I am confused as to why Excel, Outlook, PPT all work, but word doesn't.
Not printers are downloaded to the computer, fyi.
I am connected to a network also.
Thanks!
See the KnowledgeBase article "How to troubleshoot problems that occur when you start or use Word 2010, Word 2007, Word 2003, or Word 2002" at:
http://support.microsoft.com/default.aspx/kb/921541?p=1

How to Avoid Downloading Malware

Where are you getting the download?

There are malicious people who download valid copies of a popular download, modify the file with malicious software, and then upload the file with the same name. Make sure you are downloading from the developer's web page or a reputable company.

Don't install download manager

Many sites suggest or require you to install an installer or a download manager before allowing you to download a program you may be interested in downloading. These tools almost always cause your computer more problems and may even have malware or other spyware. Avoid any site claiming anything must be installed first before you can continue with your download.

Avoid advertisements on download pages

To help make money and pay for the bandwidth costs of supplying free the software, the final download page may have ads. Watch out for anything that looks like advertisements on the download page. Many advertisers try to trick viewers into clicking an ad with phrases like "Download Now", "Start Download", or "Continue" and that ad may open a separate download.

Cancel or deny any automatic download

Some sites may automatically try start a download or give the appearance that something needs to be installed or updated before the site or video can be seen. Never accept or install anything from any site unless you know what is downloading.

Wednesday, July 6, 2016

Append Query error - tried to assign null value to a variable that is not a variant data type

Solutions to the Problem Append Query error - tried to assign null value to a variable that is not a variant data type

Running System Update Readiness Command

Recommended Method to Repair the Problem: Append Query error - tried to assign null value to a variable that is not a variant data type:

How to Fix Append Query error - tried to assign null value to a variable that is not a variant data type with SmartPCFixer?

All print is too large for screen. I get it smaller than it becomes larger again. I have to scoll back and for to read content.

Keys to the Problem All print is too large for screen. I get it smaller than it becomes larger again. I have to scoll back and for to read content.

Make Sure that your Computer Meets the System Requirements

Another Safe way to Fix the Problem: All print is too large for screen. I get it smaller than it becomes larger again. I have to scoll back and for to read content.:

How to Fix All print is too large for screen. I get it smaller than it becomes larger again. I have to scoll back and for to read content. with SmartPCFixer?

AMD:CCC-AEMC Windows Capturing Program - Everything slows down as over 90% of memory is being used

Anwsers to the Problem AMD:CCC-AEMC Windows Capturing Program - Everything slows down as over 90% of memory is being used

Running System Update Readiness Command

Recommended Method to Fix the Problem: AMD:CCC-AEMC Windows Capturing Program - Everything slows down as over 90% of memory is being used:

How to Fix AMD:CCC-AEMC Windows Capturing Program - Everything slows down as over 90% of memory is being used with SmartPCFixer?

Applying range names

Keys to the Problem Applying range names

Boot in Safe Mode:

Recommended Method to Fix the Problem: Applying range names:

How to Fix Applying range names with SmartPCFixer?

ANY Print Freezes and makes program not responding windows 7

Anwsers to the Problem ANY Print Freezes and makes program not responding windows 7

Using Windows troubleshooter:

Another Safe way to Fix the Problem: ANY Print Freezes and makes program not responding windows 7:

How to Fix ANY Print Freezes and makes program not responding windows 7 with SmartPCFixer?

an unbandled win32 exception occurred insendfileserver.exe [6824]

Keys to the Problem an unbandled win32 exception occurred insendfileserver.exe [6824]

Recommended Method to Fix the Problem: an unbandled win32 exception occurred insendfileserver.exe [6824]:

How to Fix an unbandled win32 exception occurred insendfileserver.exe [6824] with SmartPCFixer?

Thursday, April 28, 2016

All Office 2007 Programs working except Word

Anwsers to the Problem All Office 2007 Programs working except Word

How to Avoid Downloading Malware

Recommended Method to Repair the Problem: All Office 2007 Programs working except Word:

How to Fix All Office 2007 Programs working except Word with SmartPCFixer?