Hey Greg,
For whatever this is worth, I have found/experienced that VB2005
(VB.Net) greatly simplifies complex operations that would otherwise be
considerably more difficult to perform in Access (requiring a lot of API
code or external com objects created in something other than Access -
C++, .Net...) or flat out just not supported in Access. I mention this
to let you know that there are other viable solutions to your problem.
The VB2005 Datagridview control offers considerably more flexibility
than the Acces Subform - supports all forms of conditional formatting.
Or, if you want to stay with the continuous form option - VB2005 has
another object called a currency manager that you bind with the
underlying dataset(s). You can have multiple datasets and keep them
synched using currency managers. Then VB2005 also has another control
called a panel (which I believe they stole from Java) where you can lay
panels on your form and peform different operations on each panel. One
panel can be static while another panel can have scrolling capabilities,
thus achieving the frozen pane/column feature.
Note: Access is great for small (non-enterprise level) jobs because it
integerates a database system (RDBMS) directly with a programming
environment for which there is no easier way to carry out database
programming. This is quite a feat, but it comes at a price - No one can
package every conceivable programming need into one package. Access
comes fairly close, but it can offer only so much flexibility. Once you
exceed that need, it is time to step up to the non integrated
programming environment.
Rich
*** Sent via Developersdex
http://www.developersdex.com ***