Split frame like in Excel

[slinky]

I have a list to the right of my subform with personnel that I want to
stay in place as I scroll horizontally the weeks of the year. Is there
a way to do this in Access. I also have the personeel name scrolling
vertically with their respective weeks following too , so it's
complcated... any ideas? Thanks!!!!

[Steve]

You can freeze a column in datasheet view. Is that what you are looking for?

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
re******@pcdatasheet.com


"slinky" <ca***************@yahoo.comwrote in message
news:11**********************@d55g2000hsg.googlegr oups.com...

>I have a list to the right of my subform with personnel that I want to
stay in place as I scroll horizontally the weeks of the year. Is there
a way to do this in Access. I also have the personeel name scrolling
vertically with their respective weeks following too , so it's
complcated... any ideas? Thanks!!!!

[slinky]

Well usually (to allow conditional formatting of textboxes) I shy away
from datasheet view and choose continuous view to emulate a datasheet
view. This allows me to selectively lock "cells", or change their
appearance based on my code.

On Jul 10, 6:34 pm, "Steve" <[e-mail]:

You can freeze a column in datasheet view. Is that what you are looking for?

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
[e-mail]

"slinky" <[e-mail] in message

news:11**********************@d55g2000hsg.googlegr oups.com...

I have a list to the right of my subform with personnel that I want to
stay in place as I scroll horizontally the weeks of the year. Is there
a way to do this in Access. I also have the personeel name scrolling
vertically with their respective weeks following too , so it's
complcated... any ideas? Thanks!!!!- Hide quoted text -

- Show quoted text -

[Steve]

AFAIK there is no way to freeze a part of a continuous form.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
re******@pcdatasheet.com


"slinky" <ca***************@yahoo.comwrote in message
news:11**********************@q75g2000hsh.googlegr oups.com...

Well usually (to allow conditional formatting of textboxes) I shy away
from datasheet view and choose continuous view to emulate a datasheet
view. This allows me to selectively lock "cells", or change their
appearance based on my code.

On Jul 10, 6:34 pm, "Steve" <[e-mail]:

>You can freeze a column in datasheet view. Is that what you are looking
for?

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
[e-mail]

"slinky" <[e-mail] in message

news:11**********************@d55g2000hsg.googleg roups.com...

>I have a list to the right of my subform with personnel that I want to
stay in place as I scroll horizontally the weeks of the year. Is there
a way to do this in Access. I also have the personeel name scrolling
vertically with their respective weeks following too , so it's
complcated... any ideas? Thanks!!!!- Hide quoted text -

- Show quoted text -

[Tony Toews [MVP]]

slinky <ca***************@yahoo.comwrote:

>I have a list to the right of my subform with personnel that I want to
stay in place as I scroll horizontally the weeks of the year. Is there
a way to do this in Access. I also have the personeel name scrolling
vertically with their respective weeks following too , so it's
complcated... any ideas? Thanks!!!!

Consider exporting the data to Excel so folks can review it all they want.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/