开发者

Access VBA vertical 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 lis开发者_JAVA百科t 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.


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.


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.


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 graphics for each row, and do so without any code:

Access VBA vertical scroll bar

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

Access VBA vertical scroll bar

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

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜