473,326 Members | 2,010 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Horizontal Scroll with first field Fixed.

I have created a Search Form that is basically a Popup ContinuousForm
that consists of 15 fields(columns). When the user clicks on a
record(row) the form closes and the selected record displays on my
MainForm.

Because there are 15 fields, they will not all fit on the screen so
the Horizontal Scroll bar is used. the problem is that the first
field ITEMNAME scrolls off the screen and the user loses track of the
record they were focused on.

Is there a way to keep the first field ITEMNAME fixed, and have only
the remaining 14 fields scroll???

Thanks
Greg

May 22 '07 #1
6 5644
On 22 May 2007 08:27:41 -0700, "Ap******@gmail.com" <Ap******@gmail.comwrote:
>I have created a Search Form that is basically a Popup ContinuousForm
that consists of 15 fields(columns). When the user clicks on a
record(row) the form closes and the selected record displays on my
MainForm.

Because there are 15 fields, they will not all fit on the screen so
the Horizontal Scroll bar is used. the problem is that the first
field ITEMNAME scrolls off the screen and the user loses track of the
record they were focused on.

Is there a way to keep the first field ITEMNAME fixed, and have only
the remaining 14 fields scroll???

Thanks
Greg
How about having the selected 'record' be two records, ITEMNAME and selected
field

Chuck
May 22 '07 #2
Hi Greg,

You are referring to freezing a pane (Column) like in Excel. That would
require OOP environment, which VBA does not have OOP capabilities. One
workaround would be to use subforms instead of a continuous form. You
could have 2 subforms. The first subform would contain the first field
in your table. The 2nd subform would contain the rest of the fields.
When you scroll the 2nd subform, the first subform remains static. The
only catch would be that the user would have to scroll the first subform
and the 2nd subform to keep them lined up correctly.

In VB.Net(2005) the datagridview (which replaces the subform) has a
Frozen Column property.

If you have conditional formatting, then the subform idea might not work
out. Again, the VB.Net(2005) datagridview supports as much formatting
(conditional and otherwise) as a RichTextBox control

Rich

*** Sent via Developersdex http://www.developersdex.com ***
May 22 '07 #3
Thanks

One poster suggested datasheet mode. I'm not sure if I will lose my
current functionality. I'll have to give it a go.

Greg

May 23 '07 #4
My appologies. I forgot that you can freeze panes/columns in Access
just as well as Excel. Use a subform and select datasheet view in the
properties of the Subform. This will display your data in a table
format within the main form. You can then freeze your desired columns
using the Format Menu/Freeze column selection. You will be prompted if
you want to save that setting so it will persist. There is probably a
way to automate the freezing of the column(s) so you can freeze and
unfreeze columns without going to the Format menu - I believe using the
DoCmd Object.

Again, the only catch would be if you had conditional formatting. I am
pretty sure that the datasheet view does not support formatting.
Rich

*** Sent via Developersdex http://www.developersdex.com ***
May 23 '07 #5
Thanks Rich

As a matter of fact I am using Conditional Formatting to set
background colors
as highlights. Just my luck. I'll experiment!

Greg

May 25 '07 #6
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 ***
May 25 '07 #7

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

14
by: Dave | last post by:
My web site is not particularly theme-based, but it contains an Art Gallery I'd like to display in a different perspective. I would like to horizontally scroll it, rather than vertically - as if...
1
by: Jeremy Chapman | last post by:
I've got a grid inside a div so that it's got scroll bars around it. What I want to do is have the header row fixed at the top, so that the vertical scroll bars scroll just the data rows of the...
2
by: Tina | last post by:
Am I missing something or does the listbox web control not have a horizontal scroll capability? Thanks, T
2
by: Martin Schneider | last post by:
Hi! Thanks for your ideas for the following problem: The text field has only a vertical scroll bar, but no horizontal one. When typing across the right boundary of the field the text is...
3
by: Taras_96 | last post by:
Hi everyone, I've got a select box with multiple="yes" with fixed width. Unfortunately the content that goes into the box is too wide (and I can't make the box any bigger due to layout...
3
by: lolo | last post by:
hello. happy new year. I'm trying to build a website for my wife and she is adament on having a horizontal thumbnail scrolling div. great. I have a good vertical scrolling thing, but can't...
3
by: ApexData | last post by:
I have created a SearchForm which is basically a PopUp Continuous Form that displays 15 Fields. Each field is displayed as a column and when the user clicks on any record or row, the form closes...
0
by: ApexData | last post by:
I have created a Search Form that is basically a Popup ContinuousForm that consists of 15 fields(columns). When the user clicks on a record(row) the form closes and the selected record displays on...
1
by: amuven | last post by:
Hi All, I need to put a horizontal scroll bar for 4 cells alone where my first cell in table should not contain any horizontal scroll bar . In clear, let us say there are 5 columns in my...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.