Recent content by zollo9999

Hi PHV Thanks This hotfix exactly addresses this issue. I have requested the hotfix be tested and installed on all our desktops. I'll give you a star for this tip. Paul Zollo VBA Developer [thumbsup] http://msdn.microsoft.com/en-us/library/bb190882(office.11).aspx

Hi Remou Yes we are now running Access 2003 SP3. It sounds like you know a bit about the impact of SP3 changes. Anything you can add on this front? Zollo VBA Developer [thumbsup] http://msdn.microsoft.com/en-us/library/bb190882(office.11).aspx

Firstly. Have you checked the formatting for those columns in excel to see it the data is coming across, but just appears to be zero. If the data is coming across there are automation methods for formatting the spreadsheet. Secondly, if the data is not coming across, there could be something...

Hi I'm using a combo box to display a list a staff, which the user selects. The combo has a row source set to a SQL query statement with 2 columns. The formatting is set to display the 2 columns when selecting a staff member. The second column is a Yes/No field in the source table. It...

Hi Steve Thanks for the info. Unfortunately your very cool fish icon grabs my attention so much it took me twice as long to read your posts. (They appear several times on the page one for each post of course) Could you perhaps substitute a static icon to help other readers? Thanks Zollo VBA...

Hi Just last week, hermanlaksko in thread705-1478540 recommended the following link to solve your problem: http://www.lebans.com/reporttopdf.htm I have not tried it yet as it was not relevant to me, but this is a FREE solution to your problem. :) Cheers Zollo VBA Developer [thumbsup]

Yes I agree. I will have to spend some time tweaking it and testing it. One thing that may help in my case is installing the PDFs on the users desktop or a local server. "What the... ?" I here you say! Our IT systems are mildly schizophrenic. My work section has been added two other large...

Perhaps I'm already using the following pausefor sub Public Sub PauseFor(intSeconds As Integer) Dim dtEndTime As Date dtEndTime = DateAdd("s", intSeconds, Now()) Do Until Now() >= dtEndTime DoEvents Loop End Sub Zollo VBA Developer [thumbsup]

Hi again As I don't have any version of the full acrobat product, it appears my prefered solution (direct control of adobe reader to print documents) is not possible, unless I can find a free reader plug-in that enables control of printing. No Luck yet but will keep looking. The following...

Thanks Herman. I appreciate the efforts you have made. Sorry I didn't get back to you sooner, perhaps to save you some trouble. I did try the /p /h commands last night and they did work as you described. (I've got some other problems with my app that are also taking lots of my time to resolve...

Hi again I don't think your code will work with Acrobat / Reader 8.0 We had Reader 7.x previously but now we have 8.0. I can't wind back to 7.x as I'm part of a big government Department. Here is the code I used previously with the /t command parameter which does not work for Adobe 8.0...

Hi again. I don't know where you are going with those thoughts about printing to the screen. Perhaps viewing and then printing. I can get all the docs open using a shell command and the string path to each document. As there are 7 documents to print at one time, I'd rather be able to just...

Hi Herman Thanks for your reply. That info will be useful and I will look into it further. Unfortunately, it is not an answer to my problem as I'm not creating pdf reports from access, but needing to print existing PDF documents. Is there anyone else with any help? I will attempt to run the...

Hi I need to print on demand 7 external PDF documents. I've already successfully implemented the legacy methods of using the shell command and passing the /t print command line, as shown here: thread707-860631 I now have Adobe Acrobat & Reader 8.0 where this method no longer works. There is a...