Really Appreciate Help
in [General]
|
Prev: Data Access Page
Next: Run time error '287'
From: v.k. on 21 Nov 2006 12:51 "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 21 Nov 2006 12:56 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 21 Nov 2006 14:23 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 11:23 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 11:29
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. > > > > > > > > > > > > > > > |