Position slide bar

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Frank H - 09 Mar 2005 23:40 GMT

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

Reply to this Message

PC Datasheet - 10 Mar 2005 22:11 GMT

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.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
resource@pcdatasheet.com
www.pcdatasheet.com

> Can anybody assist ?
>
[quoted text clipped - 9 lines]
>
> TIA Frank H

Reply to this Message

anonymous@discussions.microsoft.com - 11 Mar 2005 04:37 GMT

Thanks PC

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

Frank H

Reply to this Message