I cannot print my envelope from access throught word because it cannot find the query as a data source to mail merge from.
For starters, why not initiate the mailmerge from Access?
You do that, selecting the query in Access and then from the Tools menu, select Office Links and then Merge it with Microsoft Office Word.
As an alternative
From the Tools menu in Word, select Options and then go to the General tab and check the box against the "Confirm conversions at open" item. Then when you attach the data source to the mail merge main document, select the DDE option.
You also need to turn macros security down to low. in options/security.
After years of frustration looking through the web for someone who knew
how to pull this off, and thinking it wasn't possible, I finally got it
to work!! If I am not the first, at least there is another hit on the
search to help now!
The problem was, as previous threads indicated, only basic support was
provided in Windows XP for the stick. There was no control panel for
programming it, and no test forces, and worst of all, the forces were
all at MAXIMUM in games, which rendered it pretty much unusable.
Too bad, the stick is so well built too. Trust me, I opened mine to
try to find a force adjustment. There isn't one. But a very
impressive mechanism!!!
This procedure may work for the wheel, and the affected gamepads, I
don't know.
TO GET IT TO WORK...
1. Joystick is assumed plugged in.
2. Get ahold of the sidewinder 4.0 drivers for the stick. On
driverguide.com, I had this success with the ff2_software4.0.zip file.
Extract the zip.
3. Right click the setup.exe file, and hit Compatability.
Select 'Run this Program in Compatability Mode' for Windows 2000.
Go through setup. You should SEE the control panel, and have SOME
operation at this point in Control Panel / Game controllers, but the
changes don't stay in effect. Keep going!
4. In the device manager.... (Control Panel / System / Device Manager)
Double Click 'Human Interface Devices'. On EACH of the Force Feedback
2 entries, click update driver, NO to Windows Update, Install from List
or specific location, Don't Search, Pick the entry that is... NOT
digitally signed. Do this for BOTH entries.
5. In the driver archive, under '\SETUP\setupdir\win2k' select the
GcKernal.sys file, and hit CTRL-C (Copy). Browse to the
windows\system32\drivers\ folder, and hit CTRL-V and agree to copy over
the newer file. Cleck the date of the file in this folder to be sure
that the correct one is there. Or just hit control-V again to see if
both files are dated the same in the warning box If they are, you are
good.. (Date: 6/28/2000)
System file protection tried to replace it back with the newer one for
me, but after repeated pastes, it stayed. Doesn't make sense to me
either. If you have trouble, try it in safe mode! Your goal is to get
the file dated in the year 2000 to STAY in the folder. (gckernal.sys)
6. Once alll of these steps have been done successfully, reboot.
7. To Test Operation - Control Panel / Game Controllers / Make sure
Force Feedback device is highlighted, and hit properties. On the
'Forces' tab. Change the force strength, and see if the changes STAY IN
EFFECT after repeated presses of the test buttons. If they do, the
GAME will work with the newly adjusted force! FINALLY!
Summary - Yes - we are tricking Windows XP to install the driver and
software, then FORCING it to install part of it that it didn't like.
Perhaps driver signing checking, if turned off, will allow a person to
skip steps 4 and on? Seems undesirable. Step 4 may be unneeded, I
don't know. I don't feel like undoing everything to find out. We are
getting Sidewinder 4.0 software to work in Windows XP! I just repeated
that to help searchers.
This is caused by a virus running. Virut or a variation usually, do the following with the hard drive mounted on another PC
Then run all virus and spyware precautions again when the drive is back in its original Pc
When removable media or a digital camera are inserted to the PC no autoplay occours.
These instructions should fix both issues. My solution is what i have confirmed worked for me, start there and work throught the solutions.
My Solution
This will take a few seconds to run and you will get a "success" message.
here is how you can enable Autoplay using group policy...
Tutorial from techarena
Windows XP Autoplay Repairing Tutorial
Autoplay requires the Shell Hardware Detection service, make sure
it's set to automatic and is running. To access Services, open the
Run box and enter: %SystemRoot%\system32\services.msc /s
================================================== ======
CD-ROM May Not Run Automatically in Windows XP
http://support.microsoft.com/kb/314855
The Autorun.inf file and the programs that the Autorun.inf file is
designed to run may not run if you are logged on to Windows XP as
a user without either Power User or Administrator rights.
By default, only users who are logged on to Windows XP with Power
User or Administrator rights are allowed to install software. In
Windows XP, files that have an .inf extension are considered to be
setup information files. As a result, the Autorun.inf file does not
run if you do not have Power User or Administrator rights.
================================================== ======
A users comment on a forum somewhere:
"I installed CCleaner today and it removed some obsolete CLSID registry
entries. Now AutoPlay works!"
CCleaner - Slim 900 KB (Freeware)
http://www.ccleaner.com/download/builds.aspx
================================================== ======
Make sure that this registry value is set to 0:
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Winlogon]
"allocatecdroms"="0"
And that this one is set as shown:
[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Servic es\Cdrom]
"Start"=dword:00000001
"Autorun"=dword:00000001
================================================== ======
How to restore Autoplay to its default settings:
Enable/Disable Autoplay in Windows XP
http://www.typhoonsoftware.com/configxp.htm
================================================== ======
Disable Autorun while keeping all the functionality of Autoplay!
1. Copy below and paste into Notepad.
----------copy inside only----------
Windows Registry Editor Version 5.00
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\IniFileMapping\Autorun.inf]
@="@SYS:DoesNotExist"
----------copy inside only----------
2. Save-as Autorun_Disable.reg (or any name + .reg)
3. Double-click or right-click and merge into the registry.
The effect is immediate, no restart or logoff required.
================================================== ======
The BEST software for fixing autoplay:
Autoplay Repair Wizard 1.0 77 KB (Freeware)
http://www.microsoft.com/downloads/d...DisplayLang=en
AutoPlayConfig 1.0 164 KB (Freeware)
Info: http://www.typhoonsoftware.com/autoplayconfig.htm
Download: http://www.autoruntyphoon.com/AutoPlayConfig.zip
Autoplay Repair 2.2.2 225 KB (Freeware)
Main page: http://www-stud.uni-essen.de/~sddabacz/prog.php?id=apr
Homepage: http://www.orangeblue.net.ms/
Download: http://www-stud.uni-essen.de/~sddabacz/apr/APR.zip
CleanHandlers 2.4 73 KB (Freeware)
Info: http://windowsxp.mvps.org/autoplayhandlers.htm
Download: http://windowsxp.mvps.org/utils/cleanhandlers_2_4.zip
AutoRun Settings 0.x 9 KB (Freeware)
Info: http://www.uwe-sieber.de/drivetools_e.html
Download: http://www.uwe-sieber.de/files/autorunsettings.zip
ju.c
You can no longer access the CD drive or the DVD drive. The problem is not hardware (ie you have tried another drive) and you still cannot see the optical drive in windows, or you can see the drive with an exclamation mark (code 39) but no mounted volume, the following should help
NB: If there are no drives at all in Drive Manager then this is likely the cause of a virus and should be treated first.
There are software utilities available
Try these additional links for software if the solutions below do not work, this link is only a reference
How to Fix CD/DVD Drive Problems With 18 Freeware Tools and Scripts
Solution 1
Solution 2
Solution 3
If you are receiving this Code 39 error and your CD or DVD drive is missing and has a yellow exclamation mark in Device Manager,
To solve this Code 39 error, follow these instructions:
NOTE: After removing these registry keys and rebooting, it may be necessary to reinstall any CD or DVD recording applications.
1) Close all open programs
2) Click on Start, Run, and type REGEDIT and press Enter
3) Click on the plus signs (+) next to the following folders
HKEY_LOCAL_MACHINE
SYSTEM
CurrentControlSet
Control
Class
{4D36E965-E325-11CE-BFC1-08002BE10318}
4) This folder is the DVD/CD-ROM Drive Class Description in the registry. Look for any of the following names in the right hand column.
UpperFilters
LowerFilters
UpperFilters.bak
LowerFilters.bak
5) If any of the above keys shown in step 4 are listed, right-click on them and choose Delete
6) After deleting the keys, close the Registry Editor
7) Reboot your computer
8) Open My Computer and check to see if your CD or DVD drives have returned. You may also want to open Device Manager and verify that the yellow exclamation and error code on the CD or DVD drive is gone.
Solution 4
tyr installing the correct chipset drivers
Solution 5
Try this Fixit from microsoft
Your CD drive or DVD drive is missing or is not recognized by Windows or other programs
Solution 6
This is a more indepth tutorial but relavent if the summarised version above do not work.
How to properly fix filter driver problems in Windows XP
(Note: this is an article for technicians, so common technical terminology and procedures will not be spelled out.)
Most technicians are familiar with the issue where optical drives disappear from My Computer, only to be found in Device Manager with an exclamation point on them, indicating a problem.
Most technicians also have no idea what filter drivers are, or how this can happen, so I'm here to explain this and show you the proper way to repair a driver whose filter chain is broken.
I've noticed that most people completely blast all of the filter drivers away until it works, and although that works, it's really not the best way to go about things, especially since the other filters might be working properly. Also, don't you want to know the why and the how? This problem can apply to more than just optical drives.
A filter driver intercepts requests/communication in order to extend or replace functionality in the driver or hardware that it is filtering. There are three types of filter that you should know about: bus filter drivers, upper filter drivers, and lower filter drivers.
A bus filter driver extends functionality (usually for proprietary features) on a bus driver, such as ACPI. An ACPI filter driver, for example, could add additional power management modes or communicate with proprietary modifications to ACPI (such as in laptops).
An upper filter driver filters data between the main driver and the application/operating system service. Microsoft's example: a keyboard filter driver could perform additional security checks before passing the data along to the application or OS/module that is receiving the data.
A lower filter driver filters data between the hardware itself and the main driver, providing extra security/stability or translating proprietary communication into a standard language for the main driver. A good example of this is when you press a button on a piece of hardware: you may have only pressed the button once, but internally, the button may have made electrical contact repeatedly within mere milliseconds, sending more than one signal when only one was intended. A filter driver can recognize that this isn't intended behavior, and can refine the data to expected specifications (it turns multiple contacts into the intended 1 contact). This way, the main driver receives a stream of cleaned/stable data, and from the end user's perspective, everything is OK. Since hardware is physical and anything can go wrong, filter drivers are quite necessary for operating system sanity.
There are two ways to install a filter driver in Windows: at the class level, and at the device level. If you install a keyboard class filter driver, EVERY keyboard you ever install will be filtered by it. If you only install it on the device level (which is done by unique device ID), then it will only filter the exact device that you put it on originally and all other devices, even in the same class, will be unaffected.
Here's the part everyone is really reading this for. How do you know when you have a filter driver problem, and how do you properly solve it?
If you go into Device Manager and see a device with an exclamation point on it (CD-ROM or not) you should not immediately try to remove and refresh it. Double-click the device so you can see the error code. If it's anything other than "the drivers aren't installed for this device", then you should click the Details tab.
Pull down the drop-down box on the Details tab and look at the following four items:
In each of these sections, there may be zero or more items. Note the name of each item in each section. They are all drivers, so they should be in %systemroot%\System32\Drivers with a .sys extension. If you investigate your CD-ROM drive's filter drivers and notice GEARAspiWDM (for example), then you should find a corresponding GEARAspiWDM.sys file in the %systemroot%\System32\Drivers folder. If you don't find a corresponding file, then you've found a broken driver chain. Your next course of action is to either find the .sys file and put it in System32\Drivers and reboot, or remove the registry entry and reboot. In most cases you'll just be removing the registry entry that is pointing to a non-existent driver.
How does this happen? If you uninstall iTunes (for instance) then it will remove the GEARAspiWDM.sys file and its filter driver entry from the registry. If you then System Restore to a date prior to this uninstallation, it may or may not put back the .sys file but it will definitely put back the registry entry, and thus the filter chain will be broken. This can happen with any device, as all are capable of hosting filter drivers above or below the main driver. Again, this is not exclusive to that well-known CD-ROM drive problem.
If the missing file came from either of the two "Class" filter categories, drill-down in Regedit to HKEY_LOCAL_MACHINE\System\CurrentControlSet\Control\Class. Hit CTRL+F and type the entry as you saw it in Device Manager (i.e., "GEARAspiWDM" — without the .sys part) and try to find it. It should quickly bring you directly to the Upper or Lower filters value that contains this driver's reference. Double click the value that it was found in (in the right-hand pane of Regedit), and remove just the line of the missing file, leaving everything else alone (specifically anything that DOES actually exist in %systemroot%\System32\Drivers). Make sure there's only one item per line and that there are no blank lines and that you are modifying the intended driver. The (Default) value of every class key should describe the class' name in English (i.e., "DVD/CD-ROM Drives")
If the missing file name came from either of the two "Device" filter categories, drill-down to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Enum. Hit CTRL+F and type the entry as you saw it in Device manager, etc, and remove the line in the same way as explained in the paragraph above this one. If more than one device is using this particular filter, then you will have to search again and remove it from each device.
After you've discovered and removed the offending filter driver entry from the registry, restart the computer. All should be well again at this point, if it was indeed just a filter driver problem. Try not to attempt to remove and reinstall the driver before at least rebooting first, as it should be fixed on the next system startup.
Solution 5
Solution 6
also read this article How To Delete the UpperFilters and LowerFilters Registry Values.
Note: A few of the more common Device Manager error codes that are often caused by UpperFilters and LowerFilters issues include Code 19, Code 31, Code 32, Code 37, Code 39, and Code 41.
Firstly if your site is only a couple of days old to a few weeks this tutorial might not work.
My zencart shop had been open for 8 months and was still not listed in the search engines. This was despite have an adwords campaign and submitting a site map. A few backlinks but not many, it still should of responded to site:mywebsite.com. I had no listings at all in any search engines.
I pulled may hair out trying to fix this, i was using 1.38 with a few standard mods.
Cause:
Why does this effect my search results:
Session IDs
In the case of zencart every time you visit the shop you get a session ID, this is presented via the url. This url is unique for every visit. zencart recognises a spider/bot when it visits and so does not issue a session ID to the crawler. In my shop this was not working and every time a spider/bot visited it was assigned a url with a session ID, therefore the spider/bot would never see the same page twice hurting SERPS (search engine placement).
For my site i discovered that on yahoo / alltheweb / altavista I had 14,000 links to my site in the search engines yet no search results pointing to my site, I looked more closely at these results and noticed the url was the same in everyone except the end bit 'zenid=......' These 14,000 links had caused my site to have an extremely low rating which prevented the homepage coming up the the search results. 14,000 bad pages = bad site. As far as the search engines knew my site was a spam site because they were all individual and were not verified, ie read twice. I did check this but the shop was not blacklisted, the engines would just put it down as a 'bad' site.
NoIndex, NoFollow
This is simple, this tells google, yahoo etc on every page this command is present not to index the page at all, so zencart says 'dont index this page', i do not want you too', so they dont.
Conclusions
These two errors combined will completely prevent the search engines displaying your site, even if you have submitted a sitemap and the search engines regulary visit your site. The searchbots and the computer programs that display your results in a search engine are completely different and use different criteria.
Solution (after months of thinking)
It turns out that zencart 1.38 has 2 bugs in it causing it to add NoIndex, NoFollow to every page, the session IDs added to every page is caused by user error, this is most likely to occur when you transplant a site. To fix these problems read below, not all issues might be present.
Session ID
NoIndex, NoFollow Always Present
Repairing the Damage
To get rid of those unwanted links in search engines add the following to your robots.txt
User-agent:*
Disallow: *zenid=*
Disallow: /*zenid=*
when these are all done your site could get listed in the search engines within 6 hours but more than likely a couple of days. mine took six hours to get into yahoo, 12 into bing and then i was in the google cache within 24 hours, google search results about 36hours.
I have put together this information because i know i am not the only one and the solution is tricky if you are not an experienced web developer (or even if you are).
shoulders
http://www.zen-cart.com/forum/showthread.php?t=134865
Debugging messages are a powerful tool; however, many production systems (and test systems for that matter) have them disabled by default. If your PHP script is crashing horribly and you are not getting any runtime error messages, it is likely that this is the case for you.
You can initiate PHP debugging messages for the server by changing the display_errors and error_level settings in php.ini. Unfortunately, this is not the best situation in a production system. Luckily, you can enable error reporting on a page by page basis by simply adding the following lines to the top of your PHP script: {geshibot language="php"}
Additionally, to assist with debugging MySQL errors in PHP scripts, you can tack on an additional die clause to your MySQL queries. The following lines will cause your script to halt when a MySQL query fails, and report the error message:
{code class="brush: php"}mysql_query($query, $link_id) or die('If you script is not producing any error messages, please try these two methods before posting your question in the board. Remember, the community experts can only be as helpful as you are, and they can only work with what you give them.
http://api.moreover.com/RPC2
http://api.my.yahoo.com/RPC2
http://blog.with2.net/ping.php/
http://blogpeople.net/servlet/weblogUpdates
http://blogsearch.google.ch/ping/RPC2
http://blogsearch.google.cl/ping/RPC2
http://blogsearch.google.com.ar/ping/RPC2
http://blogsearch.google.com.co/ping/RPC2
http://blogsearch.google.com/ping/RPC2
http://blogsearch.google.es/ping/RPC2
http://hamham.info/blog/xmlrpc/
http://hamo-search.com/ping.php
http://ping.blogoon.net/
http://ping.blogranking.net/
http://ping.fc2.com/
http://ping.feedburner.com/
http://ping.namaan.net/rpc
http://ping.namaan.net/rpc/
http://ping.syndic8.com/xmlrpc.php
http://rpc.blogrolling.com/pinger/
http://rpc.pingomatic.com/
http://rpc.reader.livedoor.com/ping
http://rpc.technorati.com/rpc/ping
http://rpc.twingly.com/
http://rpc.weblogs.com/RPC2
http://services.newsgator.com/ngws/xmlrpcping.aspx
http://topicexchange.com/RPC2
http://wasalive.com/ping/
http://www.blogpeople.net/servlet/weblogUpdates
http://www.syndic8.com/xmlrpc.php
http://xping.pubsub.com/ping
http://1470.net/api/ping
http://a2b.cc/setloc/bp.a2b
http://api.feedster.com/ping
http://api.moreover.com/RPC2
http://api.moreover.com/ping
http://api.my.yahoo.com/RPC2
http://api.my.yahoo.com/rss/ping
http://bitacoles.net/ping.php
http://bitacoras.net/ping
http://blogdb.jp/xmlrpc
http://blogdigger.com/RPC2
http://blogmatcher.com/u.php
http://blogoole.com/ping
http://blogoon.net/ping
http://blogpeople.net/servlet/weblogUpdates
http://blogshares.com/rpc.php
http://blogsnow.com/ping
http://blogstreet.com/xrbin/xmlrpc.cgi
http://blog.goo.ne.jp/XMLRPC
http://bulkfeeds.net/rpc
http://coreblog.org/ping
http://lasermemory.com/lsrpc
http://mod-pubsub.org/kn_apps/blogchatter/ping.php
http://newsisfree.com/xmlrpctest.php
http://ping.amagle.com
http://ping.bitacoras.com
http://ping.blo.gs
http://ping.bloggers.jp/rpc
http://ping.blogmura.jp/rpc
http://ping.cocolog-nifty.com/xmlrpc
http://ping.exblog.jp/xmlrpc
http://ping.feedburner.com
http://ping.myblog.jp
http://ping.rootblog.com/rpc.php
http://ping.syndic8.com/xmlrpc.php
http://ping.weblogalot.com/rpc.php
http://ping.weblogs.se
http://pingoat.com/goat/RPC2
http://rcs.datashed.net/RPC2
http://rpc.blogbuzzmachine.com/RPC2
http://rpc.blogrolling.com/pinger
http://rpc.pingomatic.com/
http://rpc.technorati.com/rpc/ping
http://rpc.weblogs.com/RPC2
http://snipsnap.org/RPC2
http://trackback.bakeinu.jp/bakeping.php
http://topicexchange.com/RPC2
http://weblogues.com/RPC
http://xping.pubsub.com/ping
http://xmlrpc.blogg.de
http://bblog.com/ping.php
http://blogbot.dk/io/xml-rpc.php
http://catapings.com/ping.php
http://effbot.org/rpc/ping.cgi
http://thingamablog.sourceforge.net/ping.php
http://blogsearch.google.com/pingRPC2
http://rpc.newsgator.com
http://newsisfree.com/RPCCloud
http://mod-pubsub.org/ping.php
http://pingqueue.com/rpc
http://rpc.britblog.com
http://services.newsgator.com/ngws/xmlrpcping.aspx
http://holycowdude.com/rpc/ping
http://wasalive.com/ping
http://blogsearch.google.com/pingRPC2nd
http://api.my.yahoo.com/rpc2
http://pinger.blogflux.com/rpc
http://rpc.icerocket.com:10080
http://blog.goo.ne.jp/xmlrpc
http://pingoat.com/goat/rpc2
http://rcs.datashed.net/rpc2
http://rpc.blogbuzzmachine.com/rpc2
http://newsisfree.com/rpccloud
http://queerfilter.com/ping
http://weblogues.com/rpc
http://api.mw.net.tw/RPC2
http://api.my.yahoo.com/ping
http://blogsdominicanos.com/ping
http://blogsearch.google.co.uk/pingRPC2
http://blogsearch.google.us/pingRPC2
http://feedsky.com/api/RPC2
http://fgiasson.com/pings/ping.php
http://focuslook.com/ping.php
http://imblogs.net/ping
http://ping.blogg.de
http://ping.blogs.yandex.ru/RPC2
http://ping.fakapster.com/rpc
http://ping.wordblog.de
http://pinger.onejavastreet.com
http://rpc.tailrank.com/feedburner/RPC2
http://rpc.wpkeys.com
http://rssfeeds.com/suggest_wizzard.php
http://rssfwd.com/xmlrpc/api
http://signup.alerts.msn.com/alerts-PREP/submitPingExtended.doz
http://weblogalot.com/ping
http://xianguo.com/xmlrpc/ping.php
http://zhuaxia.com/rpc/server.php
http://focuslook.com/ping
http://www.feedburner.com/fb/a/ping
http://api.feedster.com/ping.php
http://blogsearch.google.com/ping/RPC2
http://godesigngroup.com/blog/feed/
http://mod-pubsub.org/kn_apps/blogchatt
http://rpc.pingomatic.com
http://www.a2b.cc/setloc/bp.a2b
http://www.bitacoles.net/ping.php
http://www.blogdigger.com/RPC2
http://www.blogoole.com/ping
http://www.blogoon.net/ping
http://www.blogpeople.net/servlet/weblogUpdates
http://www.blogroots.com/tb_populi.blog?id=1
http://www.blogshares.com/rpc.php
http://www.blogstreet.com/xrbin/xmlrpc.cgi
http://www.focuslook.com/ping.php?url=http://www.yourblog.com
http://www.godesigngroup.com
http://www.holycowdude.com/rpc/ping
http://www.imblogs.net/ping
http://www.lasermemory.com/lsrpc
http://www.mod-pubsub.org/kn_apps/blogchatter/ping.php
http://www.newsisfree.com/RPCCloud
http://www.newsisfree.com/xmlrpctest.php
http://www.popdex.com/addsite.php
http://www.snipsnap.org/RPC2
http://www.weblogues.com/RPC
https://phobos.apple.com/WebObjects/MZFinance.woa/wa/pingPodcast
http://ping.blogs.yandex.ru/RPC2
http://blogsearch.google.com.ru/ping/RPC2
Vista guests require the E1000 virtual NIC. Edit your vmx file and change/add the line
ethernet0.virtualDev = "e1000".