Connecting Tech Pros Worldwide Help | Site Map

Split frame like in Excel

 
LinkBack Thread Tools Search this Thread
  #1  
Old July 10th, 2007, 07:55 PM
slinky
Guest
 
Posts: n/a
Default 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!!!!


  #2  
Old July 10th, 2007, 10:35 PM
Steve
Guest
 
Posts: n/a
Default 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...
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!!!!
>

  #3  
Old July 11th, 2007, 12:25 PM
slinky
Guest
 
Posts: n/a
Default 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:
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 -

  #4  
Old July 11th, 2007, 02:55 PM
Steve
Guest
 
Posts: n/a
Default 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...
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 -
>
>

  #5  
Old July 16th, 2007, 10:05 PM
Tony Toews [MVP]
Guest
 
Posts: n/a
Default Re: Split frame like in Excel

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/
 

Bookmarks

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Popular Articles

What is Bytes?

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 220,662 network members.