Position slide bar

  • Thread starter Thread starter Frank H
  • Start date Start date
F

Frank H

Can anybody assist ?

I have a diary type application where a subform contains
time slots for 0700 - 1900
I can only see about half of the slots at any time
because of design / size restrictions, so use the
slidebar to view all of the slots. I wish to open the
form so the sub form is positioned in the 'middle'
position, ie so I start of with say 1000-1700 displayed.

Is there any way of accomplishing this

TIA Frank H
 
Frank,

Write two queries where #1 gives you the hours 0700 to 1000 and #2 gives you
the remaining hours. Create a copy of your existing subform. Base your
existing subform on query#1 and base the copy on query#2. Add a tabcontrol
with two pages on your main form. Put subform #1 on page 1 and subform #2 on
page 2. You can now go quickly to the subform with the time sloy you want.
 
Thanks PC

Not quite what I wanted to achieve, however gives me a
different way to approach my problem

Frank H
 
Back
Top