make scrollbar scroll up

[mcnews]

i need to tell the scrollbar on a subform to scroll up with VBA.
can do?
how?

tia,
mcnewsxp

 

[BruceM]

To what end? I'm not at all sure it's possible in Access, but even if so it
may be simpler to set the focus to a particular control.

 

[Dale Fye]

Check out this.

http://www.lebans.com/List_Combo.htm

 

[mcnews]

Check out this.

http://www.lebans.com/List_Combo.htm

--
Don''t forget to rate the post if it was helpful!

email address is invalid
Please reply to newsgroup only.

not

 

[Dale Fye]

What do you mean, "Not"? Not helpful?

I just assumed the scrollbar you were talking about was in a list, is this
scrollbar in a continuous subform?

Dale

 

[mcnews]

What do you mean, "Not"? Not helpful?

I just assumed the scrollbar you were talking about was in a list, is this
scrollbar in a continuous subform?

Dale

i need to tell the scrollbar on a subform to scroll up with VBA.

 

[Stephen Lebans]

Hi Dale,
I have mcnews in my Killfile. Please do not bother pointing him to solutions
on my site. He's not worth the trouble.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

 

[mcnews]

Hi Dale,
I have mcnews in my Killfile. Please do not bother pointing him to solutions
on my site. He's not worth the trouble.

--

HTH
Stephen Lebanshttp://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

some people understand the question and have an answer and some don't.
nothing to upset yourself over, stephen.

 

[BruceM]

People here volunteer their time. If an answer does not address the
question, something like "Thanks, but I was referring to the scroll bar on a
continuous subform" is appropriate; "not" as the entire message is not.
You have provided no information about what would cause the "scrolling" to
happen, whether you wish to have continuous scrolling like movie credits or
rather go to a particular record, or any details that would enable somebody
either to provide a definite suggestion or say that what you seek is not
possible.

 

[mcnews]

People here volunteer their time. If an answer does not address the
question, something like "Thanks, but I was referring to the scroll bar on a
continuous subform" is appropriate; "not" as the entire message is not.
You have provided no information about what would cause the "scrolling" to
happen, whether you wish to have continuous scrolling like movie credits or
rather go to a particular record, or any details that would enable somebody
either to provide a definite suggestion or say that what you seek is not
possible.

please tell me what is not clear about
"i need to tell the scrollbar on a subform to scroll up with VBA."
the scrollbar is on the subform - nowhere else.
that is clear because i did not say that is was anywhere else but on
the subform.
i want it to scroll up with VBA code.
what else is there to say?

me.scrollbar.scrollup
or
me.scrollbar.movetop
or
me.frmSubform.ScrollBar.GoTop
or something

 

[BruceM]

please tell me what is not clear about
"i need to tell the scrollbar on a subform to scroll up with VBA."
the scrollbar is on the subform - nowhere else.
that is clear because i did not say that is was anywhere else but on
the subform.
i want it to scroll up with VBA code.
what else is there to say?

me.scrollbar.scrollup
or
me.scrollbar.movetop
or
me.frmSubform.ScrollBar.GoTop
or something

My point was about courtesy, not about somebody misinterpreting your cryptic
question.

You ask what else there is to say. Addressing requests for clarification
would be something to say. I asked "to what end?" in my first post. In my
post before this one I wondered what is to cause the scrolling to happen,
what is the effect of the scrolling, and whether you wish to go to a
specific record.

There is no ScrollBar property. There is a ScrollBars property, but that
has to do with whether a scroll bar appears. What you seek can not be done
by manipulating the scroll bar. However, you can set the timer interval to
1000 (one second), and use some code in the Timer event:

DoCmd.GoToRecord , , acNext

Now when you open the form it will immediately move from one record to the
next. Note the error numbers when you reach the end of the recordset, and
either trap these errors or take some other action when you arrive at the
last record.

 

[mcnews]

My point was about courtesy, not about somebody misinterpreting your cryptic
question.

You ask what else there is to say. Addressing requests for clarification
would be something to say. I asked "to what end?" in my first post. In my
post before this one I wondered what is to cause the scrolling to happen,
what is the effect of the scrolling, and whether you wish to go to a
specific record.

There is no ScrollBar property. There is a ScrollBars property, but that
has to do with whether a scroll bar appears. What you seek can not be done
by manipulating the scroll bar. However, you can set the timer interval to
1000 (one second), and use some code in the Timer event:

DoCmd.GoToRecord , , acNext

Now when you open the form it will immediately move from one record to the
next. Note the error numbers when you reach the end of the recordset, and
either trap these errors or take some other action when you arrive at the
last record.

<What you seek can not be done by manipulating the scroll bar>

that's all i needed.
thanks.