Steve Lebans pdf conversion

[Guest]

I am using Steve Lebans pdf conversion code to convert an access report to a
pdf without having to have pdf drivers. Works great! Except for other
people. When I click the button to do the process it works beautifully. But
when other people on the network click the button they get a "Output command
isn't available" type message. Any ideas?? Thanks for your help!

 

[Douglas J. Steele]

Have you copied StrStorage.DLL onto all of their machines?

 

[Guest]

I put it in the network folder where the database is. But it sounds like
you're saying it needs to be on all of their local drives. I will try this,
thanks!!

at

 

[Guest]

Ok, I had our network administrator put the two .dll files on each persons
windows/system32 folder. They are still getting the same error message:
Command or Action 'output to' isn't available now. I failed to mention that
I was having it do 2 reports at a time. Could this be the problem? But why
does it work for me and not for other people? Any ideas??

Thanks!!
at

 

[Douglas J. Steele]

Sorry, no idea. Hopefully Stephen will take a break from building his new
house to check the newsgroups... <g>

 

[Stephen Lebans]

It's a timing issue. Programmatically output all of the desired reports to
Snapshot format, then convert these Snapshots to PDF.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

 

[Guest]

I haven't tried what you wrote yet, I've been trying to narrow it down as to
why it works for me but doesn't work for the other users. The reason why is
when I open the program I open it up using the shift key so that I can see
the database window. When I open it up without using the shift key and the
database window isn't displayed it errors out. So I've tried to use
windowunhide and hide code, but that gives me a different error. Any ideas??

Thanks!!

at

 

[Stephen Lebans]

AFAIK the main database window must be open.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

 

[Guest]

I have "docmd.runCommand acCmdWindowUnhide" on the on open event of the form
where they choose to run the reports. Before the form opens, it brings up a
little window titled "Unhide Window" where it lists the db window and another
form that I have open and hidden. Is there anyway to bypass this window and
just have it open the db window?

at

 

[Stephen Lebans]

Honestly I have no idea as I have not had to do this before. Perhaps you
should start a new thread and just focus on this single issue. Also have you
searched GoogleGroups on this issue. It's most likely a common issue with a
ready solution.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

 

[Guest]

I added "docmd.SelectObject acTable, "", True" to my code and that seems to
have eliminated that extra unhide window option that came up. So it's
working fine now, except I have the db window behind the form which doesn't
look very nice. But the pdf feature is great! Thanks for your help!

at

 

[Marshall Barton]

I have "docmd.runCommand acCmdWindowUnhide" on the on open event of the form
where they choose to run the reports. Before the form opens, it brings up a
little window titled "Unhide Window" where it lists the db window and another
form that I have open and hidden. Is there anyway to bypass this window and
just have it open the db window?

Try using this to unhide the fb window:

DoCmd.SelectObject acTable, , True