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

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

Quote:

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

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:

Quote:

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
resou...@pcdatasheet.com
>
"slinky" <campbellbrian2...@yahoo.comwrote in message
>
news:1184096729.192075.159940@d55g2000hsg.googlegr oups.com...
>
>
>

Quote:

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 -

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

Quote:

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:

Quote:

>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
>resou...@pcdatasheet.com
>>
>"slinky" <campbellbrian2...@yahoo.comwrote in message
>>
>news:1184096729.192075.159940@d55g2000hsg.googleg roups.com...
>>
>>
>>

Quote:

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

>
>

slinky <campbellbrian2001@yahoo.comwrote:

Quote:

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

Split frame like in Excel

re: Split frame like in Excel

re: Split frame like in Excel

re: Split frame like in Excel

re: Split frame like in Excel

Similar Microsoft Access / VBA bytes

/bytes/development

/bytes/it

/bytes/about