Hot Topic (More than 10 Replies) PrintAForm quandary (Read 1814 times)
tcgeo
Full Member
***
Offline



Posts: 278
Location: Traverse City, Michigan
Joined: May 13th, 2008
PrintAForm quandary
Jan 23rd, 2012 at 10:13pm
Print Post Print Post  
I want the option to print a form, on exit, to PDF995.

So,

On Form Exit

vTmp = @PrintAForm(0, 1, 1, 1, 28, -1, -1, -1, -1, 1, 1)

When PDF995 is selected from the print dialog, I get this warning:

Error: Cannot save changes to the current database.
File permissions may be locked.

The changes do get saved to the database and the document prints fine. This does not happen if I select PrintAForm from a command button and select PDF995.

Also, I do not get the error from On Form Exit programming if I select my One Note Printer, Microsoft XPS Document Writer, or my real printer.

Any thoughts as to what might be going on?

Thanks
  
Back to top
IP Logged
 
Hammer
YaBB Administrator
Lanticans
*****
Offline


Fire bad. Tree pretty.

Posts: 3436
Location: Ohio
Joined: Nov 22nd, 2002
Re: PrintAForm quandary
Reply #1 - Jan 23rd, 2012 at 10:17pm
Print Post Print Post  
That's...odd. We'll check it out. Anyone else with PDF995 is also welcome to try this and let us know what you see.
  

- Hammer
The plural of anecdote is not data.
Back to top
IP Logged
 
tcgeo
Full Member
***
Offline



Posts: 278
Location: Traverse City, Michigan
Joined: May 13th, 2008
Re: PrintAForm quandary
Reply #2 - Jan 23rd, 2012 at 10:26pm
Print Post Print Post  
Thank you Erika!
  
Back to top
IP Logged
 
Carl Underwood
Senior Member
Members
*****
Offline



Posts: 1351
Location: New Hampshire
Joined: Mar 11th, 2003
Re: PrintAForm quandary
Reply #3 - Jan 24th, 2012 at 5:49am
Print Post Print Post  
I have PDF995. I'm not seeing any problems at all while testing this. I tested on simple forms, and complex forms; and in preview mode and in runtime. I also tested it in standalone and in client/server.
  


Carl Underwood
CDU Computer Consulting LLC
Epsom, New Hampshire
Back to top
IP Logged
 
tcgeo
Full Member
***
Offline



Posts: 278
Location: Traverse City, Michigan
Joined: May 13th, 2008
Re: PrintAForm quandary
Reply #4 - Jan 24th, 2012 at 12:44pm
Print Post Print Post  
Thanks for all of your testing work Carl, I appreciate it.

I’ve now tested it as you have, and on two different machines, one XP, the other Win7. Here is a copy and paste of the code I put in to the Countries sample, On Form Exit. I still get the warning.

Code
Select All
var vTmp as Int

vTmp = @PrintAForm(0, 1, 1, 1, 28, -1, -1, -1, -1, 1, 1)
 



Another bit of info that I didn’t think would make a difference one way or the other, is that when the issue first presented itself, the database I was working on had security. I’ve seen this warning before when I’ve changed a user’s password and forgot to change the “x user name password” if it was the same. Of course I removed all security (although you have to manually remove the “x user name password”) for testing with no change.

I’ve now completely removed and then downloaded the latest driver for PDF995 and reinstalled, no change, still get the warning. BTW, this kinda thing can only happen to me,Right? LOL! I guess I'll be using the XPS writer.

Thanks again for your time Erika & Carl,

Brandon
  
Back to top
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2482
Joined: Aug 20th, 2003
Re: PrintAForm quandary
Reply #5 - Jan 24th, 2012 at 4:35pm
Print Post Print Post  
Hello Brandon,

When are you getting that error message? Are you clicking the save button to save the form? If so has pdf995 finished printing when you click it?

From what I have seen what PDF995, and other printing programs as well, does is it changes Sesame Current Working Directory, usually to "My Documents" when it displays the save dialog, Then it prints the document, displays the document, then switches our Working Directory back to what it was. If you try to do a save while the directory is switched, you'll get that error.

-Ray
  

Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
IP Logged
 
tcgeo
Full Member
***
Offline



Posts: 278
Location: Traverse City, Michigan
Joined: May 13th, 2008
Re: PrintAForm quandary
Reply #6 - Jan 24th, 2012 at 5:00pm
Print Post Print Post  
Hello Ray,

Using the Countries sample database.

I open the database

Select Retrieve Matching Records button

Select Next Record button

The print dialog opens

From the name drop down, I select PDF995, then OK.

If I wait about 3 seconds the warning pops up.

Thanks for the help.
  
Back to top
IP Logged
 
tcgeo
Full Member
***
Offline



Posts: 278
Location: Traverse City, Michigan
Joined: May 13th, 2008
Re: PrintAForm quandary
Reply #7 - Jan 24th, 2012 at 6:41pm
Print Post Print Post  
Went out and bought a new machine! Ok, not really, I stole my wife’s! Installed the free sponsor version of PDF995 and I don’t get the error.

Talked with PDF995 tech support to make sure that I was removing it completely from one of the machines I’m having the trouble on, I had not been. After uninstall I had to also delete C:\Windows\wpd99.drv. After complete uninstall, reinstalled, and did not install my key, so I’m using the sponsored version. The error still pops up.

Don't know if this is useful at all but thought I'd pass it along.
  
Back to top
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2482
Joined: Aug 20th, 2003
Re: PrintAForm quandary
Reply #8 - Jan 24th, 2012 at 10:06pm
Print Post Print Post  
Hi Brandon,

What's odd is that the database at that time should not be trying to save anything back to disk. Can you shoot your sesame.ini file over to support@lantica.com so I can have a look at it and see what is going on?

-Ray
  

Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
IP Logged
 
tcgeo
Full Member
***
Offline



Posts: 278
Location: Traverse City, Michigan
Joined: May 13th, 2008
Re: PrintAForm quandary
Reply #9 - Jan 26th, 2012 at 7:26pm
Print Post Print Post  
Just an update,

I've now uninstalled/removed Sesame, re-downloaded, using the default .ini, and I still have the warning popup. Is it a Windows issue?
  
Back to top
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2482
Joined: Aug 20th, 2003
Re: PrintAForm quandary
Reply #10 - Jan 26th, 2012 at 7:54pm
Print Post Print Post  
tcgeo wrote on Jan 26th, 2012 at 7:26pm:
Just an update,

I've now uninstalled/removed Sesame, re-downloaded, using the default .ini, and I still have the warning popup. Is it a Windows issue?



Hi Brandon,

Tried with your ini file and the default one on several machines and I can only get this if I click the save button while PDF995 is in the process of printing, after it's done printing everything is fine. But the message doesn't just pop up for me, I have to attempt a save. I am wondering if it is somehow caused by windows. If you are on a newer OS do you have User Account Control turned on?

-Ray
  

Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
IP Logged
 
tcgeo
Full Member
***
Offline



Posts: 278
Location: Traverse City, Michigan
Joined: May 13th, 2008
Re: PrintAForm quandary
Reply #11 - Jan 26th, 2012 at 8:57pm
Print Post Print Post  
I have re-installed Sesame on my XP and 7 machines. XP machine still gets warning. I turned off UAC on the 7 machine and still get the warning. Can't figure out what would be different on the wife's machine where I don't get the warning.
  
Back to top
IP Logged
 
tcgeo
Full Member
***
Offline



Posts: 278
Location: Traverse City, Michigan
Joined: May 13th, 2008
Re: PrintAForm quandary
Reply #12 - Jan 26th, 2012 at 9:26pm
Print Post Print Post  
For the 7 machine, went to PDF995 Properties, advanced tab, and selected “Print directly to the printer” and the warning has not come back. Made the same change on the XP machine but still get the warning. Does that uncover any more clues?

EDIT - Scratch that, the warning is back now.....
  
Back to top
IP Logged