Split frame like in Excel

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!!!!

re: Split frame like in Excel

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
resource@pcdatasheet.com




"slinky" <campbellbrian2001@yahoo.comwrote in message
news:1184096729.192075.159940@d55g2000hsg.googlegr oups.com...

re: Split frame like in Excel

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" <s...@private.emailaddresswrote:

re: Split frame like in Excel

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
resource@pcdatasheet.com




"slinky" <campbellbrian2001@yahoo.comwrote in message
news:1184156397.462742.254610@q75g2000hsh.googlegr oups.com...

re: Split frame like in Excel

slinky <campbellbrian2001@yahoo.comwrote:
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/