Command Button Problem

[NHC]

Hello again,
I'm sorry to make so many requests all of a sudden, but I'm not well trained in access and was put in charge of making major modifications to our system. I need the code for the event procedure to make a command button change the size mode of an image box to zoom. I also want to make another to change it to cut. When it is set to cut, is there any way to have scroll bars so that you can scroll to see the whole image, and how could I include that in my event procedure for the button. Any help with that would be greatly appreciated!

P.S. - Just for kicks - Is there any way to use VBA code in an event procedure to open a photo in the default photo editor on my system?

Thanks Again !

 

[mikebaldam]

use the

DoCmd.DoMenuItem

commands. Do a search to find the full use but u can do anything u can do from the toolbars i.e. cut paste, zoom, compact and repair

 

[ghudson]

use the

DoCmd.DoMenuItem

commands. Do a search to find the full use but u can do anything u can do from the toolbars i.e. cut paste, zoom, compact and repair

Do not use the outdated DoCmd.DoMenuItem commands. DoCmd.RunCommand has since replaced that old method since Access 97.

Here is the correct command to do what you want...

Me.YourImage.SizeMode = acOLESizeZoom

To figure this stuff out on your own all you have to do is put your cursor in the Size Mode field of the property box for you image and press the F1 key to open the help file for that specific property.

 

[mikebaldam]

DoMenuItem

opps.. outdated methods...lol

Heres a helpful link... On DoMenuItem Commands / RunCommand Conversions and list of commands

http://home.clara.net/tkwickenden/domenuitem.htm

 

[NHC]

Thanks a lot! That answers my question. That F1 trick is proving very handy now. Thanks