Really Appreciate Help
in [General]
|
Prev: Data Access Page
Next: Run time error '287'
From: v.k. on 27 Nov 2006 11:51 Well, if the users exit the form for browse the records try this: Private Sub Form_Unload(Cancel As Integer) MiDocView1.FileName = "" End Sub this works for me with a very small MS Access program I just did. But you have to be sure that they exit the form unless is necessary the form to be open. I this case I am trying to find a way Hope this be helpful "Bonnie" wrote: > I understand you fine VK. The only time it's a problem for my users is if > they go out of the form and browse the records (which I allow). I would > really like to fix it but I got busy putting out some other fires. I'll let > you know if I get back to it and find a fix and I would appreciate it if you > let me know if you find a fix also. > > Thanks, > Bonnie > > "v.k." wrote: > > > Hi bonnie > > > > I am actually working with vb6 but we are using the same object. Well, I > > realize that when I run the program and stop it using the exit button in my > > form (code: unload me) then it works. Only when I am using the end button > > from the design mode the tiff file remains locked and does not work for ever > > unless I exit the vb environment. That means that the users who always close > > the program with a proper way, will not have the same problem. Unfortunately, > > that does not work with MS Access and I can not still found a way to unlock > > the locked property. I'll let you know if I have further news. > > > > P.S. Sorry for my english. Hope You can understand what I am trying to say. > > > > > > "Bonnie" wrote: > > > > > Hi VK, > > > > > > Sorry to say I have not fixed the locked file issue yet. When it happens I > > > have been closing the program and reopening it. That releases the lock but > > > of couse that's not a real solution. Let me know please if you find a > > > solution. The issue I did fix was how to view multi-page tifs with the MODI. > > > > > > > > > Thanks. > > > > > > "v.k." wrote: > > > > > > > Hi bonnie, > > > > I have the same problem and I figure out that in a way lock any image that > > > > loads and even if you change the .filename, the image remane open (and > > > > locked). I can not find a way to load the same image again. Pls tell me how > > > > you fix the problem? > > > > > > > > "Bonnie" wrote: > > > > > > > > > Hi Stephen, > > > > > > > > > > Just a note to let you know I figured it out. We are now viewing multi page > > > > > tifs, conveniently moving through pages and keying from image. One funny > > > > > things is happening if you have a thought - after I view an image and go back > > > > > in to the form, try to review the image - I don't see it. After leaving > > > > > Access and re-opening, I can again view the image. Have you any idea. > > > > > > > > > > Thanks for your help. > > > > > > > > > > Bonnie > > > > > > > > > > "Stephen Lebans" wrote: > > > > > > > > > > > First I would never place code in the Current event to resize an ActiveX > > > > > > control. Place it in the form's Load event instead. > > > > > > To programmatically resize the control you have to remember that you are > > > > > > working with TWIPS(1440 per inch). Make sure your underlying form is sized > > > > > > to handle a control of this size. > > > > > > Me![MiDocView1].Width = 8.5 * 1440 > > > > > > > > > > > > Finally, I do not remember ever having the sizing issues you describe. I > > > > > > might try deleting and reinserting the control. > > > > > > > > > > > > -- > > > > > > > > > > > > HTH > > > > > > Stephen Lebans > > > > > > http://www.lebans.com > > > > > > Access Code, Tips and Tricks > > > > > > Please respond only to the newsgroups so everyone can benefit. > > > > > > > > > > > > > > > > > > "Bonnie" <Bonnie(a)discussions.microsoft.com> wrote in message > > > > > > news:DFA90A4B-FB21-4EBD-B7B1-5813A3013EDF(a)microsoft.com... > > > > > > > Good morning, > > > > > > > > > > > > > > I am using the MODI activex control to view tifs. It works great and I > > > > > > > can > > > > > > > see multiple page tifs with one exception - the control is 2" x 2" on the > > > > > > > screen and changing the properties to 8.5" x 11" doesn't work. I even > > > > > > > tried > > > > > > > changing it in VBA which would seem to work then hang. > > > > > > > > > > > > > > Private Sub Form_Current() > > > > > > > Me![MiDocView1].Width = 8.5 > > > > > > > Me![MiDocView].Height = 11 > > > > > > > Me![MiDocView1].FileName = Me![ImageName] > > > > > > > Me![MiDocView1].FitMode = 3 > > > > > > > End Sub > > > > > > > > > > > > > > Does anyone know what I am doing wrong or have suggestions? Your help is > > > > > > > really appreciated. > > > > > > > > > > > > > > Thanks. > > > > > > > > > > > > > > > > > >
From: v.k. on 27 Nov 2006 12:59 Using this way (miDocView1.FileName = "") you give a new parameter to your object and you realise the last document opened. So It does not remain locked. I am looking forward for the result! "Bonnie" wrote: > I understand you fine VK. The only time it's a problem for my users is if > they go out of the form and browse the records (which I allow). I would > really like to fix it but I got busy putting out some other fires. I'll let > you know if I get back to it and find a fix and I would appreciate it if you > let me know if you find a fix also. > > Thanks, > Bonnie > > "v.k." wrote: > > > Hi bonnie > > > > I am actually working with vb6 but we are using the same object. Well, I > > realize that when I run the program and stop it using the exit button in my > > form (code: unload me) then it works. Only when I am using the end button > > from the design mode the tiff file remains locked and does not work for ever > > unless I exit the vb environment. That means that the users who always close > > the program with a proper way, will not have the same problem. Unfortunately, > > that does not work with MS Access and I can not still found a way to unlock > > the locked property. I'll let you know if I have further news. > > > > P.S. Sorry for my english. Hope You can understand what I am trying to say. > > > > > > "Bonnie" wrote: > > > > > Hi VK, > > > > > > Sorry to say I have not fixed the locked file issue yet. When it happens I > > > have been closing the program and reopening it. That releases the lock but > > > of couse that's not a real solution. Let me know please if you find a > > > solution. The issue I did fix was how to view multi-page tifs with the MODI. > > > > > > > > > Thanks. > > > > > > "v.k." wrote: > > > > > > > Hi bonnie, > > > > I have the same problem and I figure out that in a way lock any image that > > > > loads and even if you change the .filename, the image remane open (and > > > > locked). I can not find a way to load the same image again. Pls tell me how > > > > you fix the problem? > > > > > > > > "Bonnie" wrote: > > > > > > > > > Hi Stephen, > > > > > > > > > > Just a note to let you know I figured it out. We are now viewing multi page > > > > > tifs, conveniently moving through pages and keying from image. One funny > > > > > things is happening if you have a thought - after I view an image and go back > > > > > in to the form, try to review the image - I don't see it. After leaving > > > > > Access and re-opening, I can again view the image. Have you any idea. > > > > > > > > > > Thanks for your help. > > > > > > > > > > Bonnie > > > > > > > > > > "Stephen Lebans" wrote: > > > > > > > > > > > First I would never place code in the Current event to resize an ActiveX > > > > > > control. Place it in the form's Load event instead. > > > > > > To programmatically resize the control you have to remember that you are > > > > > > working with TWIPS(1440 per inch). Make sure your underlying form is sized > > > > > > to handle a control of this size. > > > > > > Me![MiDocView1].Width = 8.5 * 1440 > > > > > > > > > > > > Finally, I do not remember ever having the sizing issues you describe. I > > > > > > might try deleting and reinserting the control. > > > > > > > > > > > > -- > > > > > > > > > > > > HTH > > > > > > Stephen Lebans > > > > > > http://www.lebans.com > > > > > > Access Code, Tips and Tricks > > > > > > Please respond only to the newsgroups so everyone can benefit. > > > > > > > > > > > > > > > > > > "Bonnie" <Bonnie(a)discussions.microsoft.com> wrote in message > > > > > > news:DFA90A4B-FB21-4EBD-B7B1-5813A3013EDF(a)microsoft.com... > > > > > > > Good morning, > > > > > > > > > > > > > > I am using the MODI activex control to view tifs. It works great and I > > > > > > > can > > > > > > > see multiple page tifs with one exception - the control is 2" x 2" on the > > > > > > > screen and changing the properties to 8.5" x 11" doesn't work. I even > > > > > > > tried > > > > > > > changing it in VBA which would seem to work then hang. > > > > > > > > > > > > > > Private Sub Form_Current() > > > > > > > Me![MiDocView1].Width = 8.5 > > > > > > > Me![MiDocView].Height = 11 > > > > > > > Me![MiDocView1].FileName = Me![ImageName] > > > > > > > Me![MiDocView1].FitMode = 3 > > > > > > > End Sub > > > > > > > > > > > > > > Does anyone know what I am doing wrong or have suggestions? Your help is > > > > > > > really appreciated. > > > > > > > > > > > > > > Thanks. > > > > > > > > > > > > > > > > > >
From: Bonnie on 27 Nov 2006 13:21 Thanks VK. I may be wrong but I think I tried that. I'll try it again. "v.k." wrote: > Using this way (miDocView1.FileName = "") you give a new parameter to your > object and you realise the last document opened. So It does not remain > locked. I am looking forward for the result! > > "Bonnie" wrote: > > > I understand you fine VK. The only time it's a problem for my users is if > > they go out of the form and browse the records (which I allow). I would > > really like to fix it but I got busy putting out some other fires. I'll let > > you know if I get back to it and find a fix and I would appreciate it if you > > let me know if you find a fix also. > > > > Thanks, > > Bonnie > > > > "v.k." wrote: > > > > > Hi bonnie > > > > > > I am actually working with vb6 but we are using the same object. Well, I > > > realize that when I run the program and stop it using the exit button in my > > > form (code: unload me) then it works. Only when I am using the end button > > > from the design mode the tiff file remains locked and does not work for ever > > > unless I exit the vb environment. That means that the users who always close > > > the program with a proper way, will not have the same problem. Unfortunately, > > > that does not work with MS Access and I can not still found a way to unlock > > > the locked property. I'll let you know if I have further news. > > > > > > P.S. Sorry for my english. Hope You can understand what I am trying to say. > > > > > > > > > "Bonnie" wrote: > > > > > > > Hi VK, > > > > > > > > Sorry to say I have not fixed the locked file issue yet. When it happens I > > > > have been closing the program and reopening it. That releases the lock but > > > > of couse that's not a real solution. Let me know please if you find a > > > > solution. The issue I did fix was how to view multi-page tifs with the MODI. > > > > > > > > > > > > Thanks. > > > > > > > > "v.k." wrote: > > > > > > > > > Hi bonnie, > > > > > I have the same problem and I figure out that in a way lock any image that > > > > > loads and even if you change the .filename, the image remane open (and > > > > > locked). I can not find a way to load the same image again. Pls tell me how > > > > > you fix the problem? > > > > > > > > > > "Bonnie" wrote: > > > > > > > > > > > Hi Stephen, > > > > > > > > > > > > Just a note to let you know I figured it out. We are now viewing multi page > > > > > > tifs, conveniently moving through pages and keying from image. One funny > > > > > > things is happening if you have a thought - after I view an image and go back > > > > > > in to the form, try to review the image - I don't see it. After leaving > > > > > > Access and re-opening, I can again view the image. Have you any idea. > > > > > > > > > > > > Thanks for your help. > > > > > > > > > > > > Bonnie > > > > > > > > > > > > "Stephen Lebans" wrote: > > > > > > > > > > > > > First I would never place code in the Current event to resize an ActiveX > > > > > > > control. Place it in the form's Load event instead. > > > > > > > To programmatically resize the control you have to remember that you are > > > > > > > working with TWIPS(1440 per inch). Make sure your underlying form is sized > > > > > > > to handle a control of this size. > > > > > > > Me![MiDocView1].Width = 8.5 * 1440 > > > > > > > > > > > > > > Finally, I do not remember ever having the sizing issues you describe. I > > > > > > > might try deleting and reinserting the control. > > > > > > > > > > > > > > -- > > > > > > > > > > > > > > HTH > > > > > > > Stephen Lebans > > > > > > > http://www.lebans.com > > > > > > > Access Code, Tips and Tricks > > > > > > > Please respond only to the newsgroups so everyone can benefit. > > > > > > > > > > > > > > > > > > > > > "Bonnie" <Bonnie(a)discussions.microsoft.com> wrote in message > > > > > > > news:DFA90A4B-FB21-4EBD-B7B1-5813A3013EDF(a)microsoft.com... > > > > > > > > Good morning, > > > > > > > > > > > > > > > > I am using the MODI activex control to view tifs. It works great and I > > > > > > > > can > > > > > > > > see multiple page tifs with one exception - the control is 2" x 2" on the > > > > > > > > screen and changing the properties to 8.5" x 11" doesn't work. I even > > > > > > > > tried > > > > > > > > changing it in VBA which would seem to work then hang. > > > > > > > > > > > > > > > > Private Sub Form_Current() > > > > > > > > Me![MiDocView1].Width = 8.5 > > > > > > > > Me![MiDocView].Height = 11 > > > > > > > > Me![MiDocView1].FileName = Me![ImageName] > > > > > > > > Me![MiDocView1].FitMode = 3 > > > > > > > > End Sub > > > > > > > > > > > > > > > > Does anyone know what I am doing wrong or have suggestions? Your help is > > > > > > > > really appreciated. > > > > > > > > > > > > > > > > Thanks. > > > > > > > > > > > > > > > > > > > > >
From: Bonnie on 7 Dec 2006 09:37
Hi VK, I finally got around to trying your simply yet elegant suggestion and it works like a dream. Bonnie "v.k." wrote: > Using this way (miDocView1.FileName = "") you give a new parameter to your > object and you realise the last document opened. So It does not remain > locked. I am looking forward for the result! > > "Bonnie" wrote: > > > I understand you fine VK. The only time it's a problem for my users is if > > they go out of the form and browse the records (which I allow). I would > > really like to fix it but I got busy putting out some other fires. I'll let > > you know if I get back to it and find a fix and I would appreciate it if you > > let me know if you find a fix also. > > > > Thanks, > > Bonnie > > > > "v.k." wrote: > > > > > Hi bonnie > > > > > > I am actually working with vb6 but we are using the same object. Well, I > > > realize that when I run the program and stop it using the exit button in my > > > form (code: unload me) then it works. Only when I am using the end button > > > from the design mode the tiff file remains locked and does not work for ever > > > unless I exit the vb environment. That means that the users who always close > > > the program with a proper way, will not have the same problem. Unfortunately, > > > that does not work with MS Access and I can not still found a way to unlock > > > the locked property. I'll let you know if I have further news. > > > > > > P.S. Sorry for my english. Hope You can understand what I am trying to say. > > > > > > > > > "Bonnie" wrote: > > > > > > > Hi VK, > > > > > > > > Sorry to say I have not fixed the locked file issue yet. When it happens I > > > > have been closing the program and reopening it. That releases the lock but > > > > of couse that's not a real solution. Let me know please if you find a > > > > solution. The issue I did fix was how to view multi-page tifs with the MODI. > > > > > > > > > > > > Thanks. > > > > > > > > "v.k." wrote: > > > > > > > > > Hi bonnie, > > > > > I have the same problem and I figure out that in a way lock any image that > > > > > loads and even if you change the .filename, the image remane open (and > > > > > locked). I can not find a way to load the same image again. Pls tell me how > > > > > you fix the problem? > > > > > > > > > > "Bonnie" wrote: > > > > > > > > > > > Hi Stephen, > > > > > > > > > > > > Just a note to let you know I figured it out. We are now viewing multi page > > > > > > tifs, conveniently moving through pages and keying from image. One funny > > > > > > things is happening if you have a thought - after I view an image and go back > > > > > > in to the form, try to review the image - I don't see it. After leaving > > > > > > Access and re-opening, I can again view the image. Have you any idea. > > > > > > > > > > > > Thanks for your help. > > > > > > > > > > > > Bonnie > > > > > > > > > > > > "Stephen Lebans" wrote: > > > > > > > > > > > > > First I would never place code in the Current event to resize an ActiveX > > > > > > > control. Place it in the form's Load event instead. > > > > > > > To programmatically resize the control you have to remember that you are > > > > > > > working with TWIPS(1440 per inch). Make sure your underlying form is sized > > > > > > > to handle a control of this size. > > > > > > > Me![MiDocView1].Width = 8.5 * 1440 > > > > > > > > > > > > > > Finally, I do not remember ever having the sizing issues you describe. I > > > > > > > might try deleting and reinserting the control. > > > > > > > > > > > > > > -- > > > > > > > > > > > > > > HTH > > > > > > > Stephen Lebans > > > > > > > http://www.lebans.com > > > > > > > Access Code, Tips and Tricks > > > > > > > Please respond only to the newsgroups so everyone can benefit. > > > > > > > > > > > > > > > > > > > > > "Bonnie" <Bonnie(a)discussions.microsoft.com> wrote in message > > > > > > > news:DFA90A4B-FB21-4EBD-B7B1-5813A3013EDF(a)microsoft.com... > > > > > > > > Good morning, > > > > > > > > > > > > > > > > I am using the MODI activex control to view tifs. It works great and I > > > > > > > > can > > > > > > > > see multiple page tifs with one exception - the control is 2" x 2" on the > > > > > > > > screen and changing the properties to 8.5" x 11" doesn't work. I even > > > > > > > > tried > > > > > > > > changing it in VBA which would seem to work then hang. > > > > > > > > > > > > > > > > Private Sub Form_Current() > > > > > > > > Me![MiDocView1].Width = 8.5 > > > > > > > > Me![MiDocView].Height = 11 > > > > > > > > Me![MiDocView1].FileName = Me![ImageName] > > > > > > > > Me![MiDocView1].FitMode = 3 > > > > > > > > End Sub > > > > > > > > > > > > > > > > Does anyone know what I am doing wrong or have suggestions? Your help is > > > > > > > > really appreciated. > > > > > > > > > > > > > > > > Thanks. > > > > > > > > > > > > > > > > > > > > > |