Recent content by ctarr

I have an Access97 database with twenty text fields and two memo fields in one table. I am upgrading this system to SQL 2k and am attempting to use the import wizard. However, everytime I run the Import/Export wizard I get an error that the data in row one exceeded the buffer. If I filter the...

llambert2, if you are using the full version of adobe go into the Adobe Distiller application (under Start - Programs). In the preferences menu you can check whether or not to open the new PDF on the screen when it is created. Craig

You'll probably have to reinstall Office. My Office 2003 has the same issue with some Internet Explorer pages. More than likely you have some corrupt registry keys and the only way I know to fix this is by reinstalling. Craig

sabloomer, you're on the right track the thread you mentioned will help with the PS files. For #4 it gets kind of tricky, you need to use VB or C to do this automation. You both should see thread thread223-548368. Beside my same response about creating a PS printer there are some good examples...

sablommer, as stated in my other thread, Thread223-548368 Install a new local printer, and choose to use a driver like the "Apple LaserWriter Pro" (good PS print driver). Don't check the "Print to File" box. But rather point the port to "C:\some directory\Postscript.ps" (you may have to...

sabloomer, I don't think you can setup the printer to make a new file name each time. If you change the preferences in Distiller to not ask for a destination it will just print to the location (port) of the postscript file. (Open Distiller and click on File | Preferences, uncheck the box for...

ft, you'll be able to run the sql if you put it into a stored procedure and execute that from the query designer to test. Build your basic select syntax and then move to the stored procedure view to add in the case syntax. The designer cannot build a case statement, it's too complex for the...

JSK, sorry I copied the wrong thread, try this one. thread223-548368. There are a couple of other posts in this same thread that talk about how to do this with VB or VBA if you don't want to use the postscript printer. Craig

JSK, You can create a PS printer on your machine and have the VBA print to this printer, please see my response to thread181-27567 Craig

What about changing the settings in PDFWriter/Distiller. Open the program and check under Preferences or Settings (I forget how version 4 menus look). You should be able to check the box that allows you to always be prompted for a file name. Craig

You mentioned early on that Adobe might be an option. With adobe security you can lock down the PDF so that with a valid password the document can be printed. You must have the full version of adobe to enable security. Basically, you can lock down the PDF so that the contents cannot be copied...

rhoneyfi, so you want each bookmarked page to resize when the bookmark is clicked? If that's the case I would say you will probably need to put some custom Javascript into the PDF file to handle the page load....So when a bookmark is clicked it displays that page, hides the bookmark tab (if...

bastizmars, what is the submit button doing? Post your javascript or action that the submit button is attempting. Also, are the PC's that don't work using different versions of Adobe? Craig

Were you print to a network drive? I've seen this be problems in my environment. Try PDF'ing to a local drive first. Also, check the output DPI. If you are just doing regular printing and viewing then drop the DPI down to 150 or less. I've had P4's top out their memory and shutdown because the...

JerryUSA, it could also be that the site is written to support IE and Netscape. And depending on what browser you use a different set of files are used to display the site. If the IE code has special scripts, activeX, etc it has much more to compile and transmit. The Netscape code may have much...