Hello,
There's a freeze pane function in datasheet but for horizontal scroll only.
How about for the vertical scroll?
I need to implement this to be able to view the total data of each column by scrolling up and down but maintaining the view of the total data.
Calling all the Access gurus for help.
-= kerinus =-
12 4790
Hi kerinus. It is not possible to 'freeze' one row and still scroll others.
If what you are after is a set of totals remaining on screen whilst you scroll the data you can implement this functionality by using the header or footer area of a continuous form to contain unbound textboxes, one for each total you need. The control source for each unbound textbox would just be =sum([field you are summing])
This is the same technique used to produce group totals and overall totals in a report.
An example of the use of the footer for this purpose is attached. The totals at the bottom are unbound controls which remain in view as the detail rows are scrolled.
Note that this cannot be done in datasheet view, as the form header/footer areas are not visible in that view.
-Stewart
Not in listview control either... -S
I suppose you could implement something where you select a row from a listbox, then apply a filter to a subform based on that row - but it is unlikely to look "clean" from a user perspective. You don't tell us what you envisage this being for - in post 1 you mention totals twice, but without explanation it is hard to visualise what you are trying to achieve.
-Stewart
@Stewart Ross Inverness
oh yeah...that was two "total" words...sorry about that...they are just one and the same...those total data are total per column...so each column has its own total amount.
like what you have stated, remaining a set of totals while scrolling (up and down) the rest of the data.
what if due to lots of data (vertical and horizontal), there would be vertical and horizontal scroll bars...it would be great to maintain the total per column when scrolling either vertically or horizontally... the same "freeze pane" function in MS Excel.
can you suggest of a control in MS Access suitable for that implementation?
You could use a continuous form as a pseudo datasheet. If you put the Column names in the header, data in the detail section and sums in the footer it should give you what you are after. But you will loose the ability to freeze columns then.
Although Excel does have the ability to freeze panes (in multiple windows), I can think of few occasions when I find it either useful or easy on the eye.
As Don says, you can investigate how to use a continuous form to do something like what you are suggesting - but as you have lots of data (as you have said) I think the visual result will be a mess. If you look at examples of good, clean design you will see the embodiment of the maxim that less is more.
Just because in this case you may be able to implement something that mimics the freeze pane functionality it does not follow that it is a good idea to do so, unless your users would find it easy and intuitive.
There is a good reason that no there is no existing control available which does what you suggest...
-Stewart
NeoPa 32,564
Recognized Expert Moderator MVP
There is no equivalent of the Freeze Pane facility in Access. Even if there were, it seems to me that Freeze Panes allows you to keep the titles in view, rather than any possible totals.
Be that as it may, Stewart's solution is a perfectly viable solution as far as I can see. You can use Continuous Forms view instead of Datasheet to see multiple records (I couldn't see a problem with Datasheet view in my testing, but I would never ignore anything Stewart has stated without much more thorough testing).
NeoPa 32,564
Recognized Expert Moderator MVP
Having seen some of the other (quicker) replies, it occurs to me to ask whether you're talking about Freeze panes, or maybe whether Split Windows might be what you're referring to.
I never use Split Windows as I find that quite untidy, but Freeze Panes I use all the time to keep the column & row titles visible in large sheets.
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: Matt Rapoport |
last post by:
If you open a new spreadsheet in Excel and click on cell B1 and then
go to Windows -> Freeze Panes it will create something similar to 4
frames. There will be a horizontal pane that contains 2 parts and a
vertical pane that contains 2 parts. I've labelled the "frames" below
...
1 2
3 4
Here's the tricky part - if you scroll to the...
|
by: ti33m |
last post by:
Hi All,
I'd like to include a datasheet on my user interface but since I'm
starting to run tight on space, I'd like to have a vertically-oriented
datasheet (column 1 has labels, column 2 has values), i.e. a
transposed datasheet or datasheet in column format. A vertical
datasheet will look cleaner, eliminate the need to scroll across (for...
|
by: (Pete Cresswell) |
last post by:
I've got about 4,000 mutual funds.
Each fund currently has up to 255 "returns" associated with it. A 'return'
being a decimal number and a date for that fund.
I have a feeling that the clients will want somewhere tb able to just scroll
through a pivot list of funds and returns (one column for the fund, one column
for each date) like...
|
by: Jenny |
last post by:
Hi all
is there way to realise a function like EXCELs
window/freeze pane within a scrollable panel of a website?
Thanks for each help!
Jenny
|
by: Jenny |
last post by:
Hi all
is there way to realise a function like EXCELs
window/freeze pane within a scrollable panel of a website?
Thanks for each help!
Jenny
| |
by: TD |
last post by:
Hey All-
I don't think this is possible, but we'd love it if it were.
We would like to have a pane of our own design docked along the left
side of our Access application's main window. This pane might have any
number of things on it... buttons, a treeview, etc... and have a layout
we would specify. It would need to be truly docked to the...
|
by: scott8000 |
last post by:
hi all
Access 2K/2003, Win XP Pro
I need to be able to detect when a subform datasheet is currently
displaying a vertical scrollbar.
I.e if the subform datasheet is showing more records than can fit the
subform window Access will make the vertical scrollbar visible.
|
by: Riun |
last post by:
Hi,
I have a huge amount of columns in a list box, but I don't want a very wide list box. I need to see the first 3 columns constantly and want to scroll through the rest of the columns (like the freeze pane function in Excel). Please advice.
|
by: mr3573 |
last post by:
i want to save an excel file as html. the problem is , i want to keep the selected freez pane in html form too. it it possible?. i'm beginner and maybe that will be possible by some software. one way maybe using frames in html but in my case it dosent work because i have several tab sheet which should be keept in final html
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...
| |