Access VBA verticle scroll bar

views:

answers:

+1 Q:

Access VBA verticle scroll bar

I am building a quite complex form in Access. I would like to have a vertical scroll bar control that will scroll through a list of pictures. What I want the scroll bar to actually do is change the pictures in the picture control when it is scrolled.

Is there a way to insert a vertical scroll bar into an Access form where the scroll events can be automated?

I would rather not get into a discussion defending my UI, as it is pretty complex.

+1 A:

If an Active X Scroll bar is available on your system, you can use that. It should have values that you can use VBA to compare to determine movement (up or down) and based on that, change the picture.

Jeff O 2010-09-10 17:41:36

Non-native ActiveX controls are almost never a good idea in an Access app.

David-W-Fenton 2010-09-10 19:14:05

I have used ActiveX controls in projects in the past and that may be my only solution in this situation. The problem I had was ensuring that the control was available on the clients system. Is there a simple way to feel confident that a certain MS ActiveX control will be available on the target systems(s)?

Icode4food 2010-09-13 12:07:39

@David-W-Fenton: Would you mind elaborating a bit more as to why non-ActiveX controls aren't a good idea?

Icode4food 2010-09-13 12:08:14

Only some non-native ActiveX controls are compatible with Access. Secondly, when you introduce an outside dependency into your app, you're making it more fragile. That is, installing it is much more likely to break. But to me, a scrollbar is not the most "intuitive" UI for navigating a slideshow, so I don't think you even need to get into the ActiveX issue.

David-W-Fenton 2010-09-13 18:56:05

A scrollbar is never going to work. I'd suggest previous/next command buttons as the absolutely simplest solution to the problem, as well as being a UI that is quite familiar to anyone who has ever used any kind of slideshow anywhere.

David-W-Fenton 2010-09-10 19:16:47

You can see an example of such at http://granitefleet.com/ScreenShots/screen_MainMenu.htm

Tony Toews 2010-09-10 23:34:31

Just about every slideshow on the Internet uses < and > buttons, so I can't imagine that wouldn't be the most intuitive interface. I don't know what would be more intuitive about a scrollbar -- to me it's much less clear, not to mention the fact that there are no hooks are vents to make it move the current record.

David-W-Fenton 2010-09-11 19:22:12

In access 2010, or 2007, you can use the new image control. You can point to a file on hard disk. You don't need any code, and you can thus display icons, or grapics for each row, and do so without any code:

alt text

And, you can also use the attachment collum. And again, display pictures in continues forms without code. Here is a another screen:

alt text

So, we don't need any 3rd party controls here.

Albert D. Kallal 2010-09-11 12:52:49

Albert, I don't see how this answers the question, which is about the UI control for navigating between images, not about what control to use for displaying them. Your examples both use continuous forms (I'm guessing), which displays more than one image, where the original question describes a single form with a single image control, and some method for swapping the image in and out of that control. I just don't see how your answer addresses the actual question asked.

David-W-Fenton 2010-09-11 19:24:18

ansaurus

tags:

views:

answers:

Access VBA verticle scroll bar

related questions