Expandable Forms
- Thread starter Thales750
- Start date
- Local time
- Today, 16:08
- Joined
- Feb 28, 2001
- Messages
- 30,085
Can you be more specific in what you want to expand? We have heard of a move for new versions of Access to break some form/report size limits that would perhaps contribute to expanding forms (by making a lot more room). It is possible for you to dynamically change the height or width of a form or report up to 22.75 inches for a given section. You could surely create a sub-form in continuous form or datasheet view and dynamically change the size of the control. You can even make things visible or not, and take up more or less room accordingly. But were any of those ideas relevant to what you were asking?
We can't forget that forms exist in windows, and to make a form bigger you might have to use an API call to expand the size of the window in which your form resides.
We can't forget that forms exist in windows, and to make a form bigger you might have to use an API call to expand the size of the window in which your form resides.
Like an outline in a Word Doc . A Tree would be similar
Click a heading, it expands. It would actually be nice if Microsoft made Access able to make the kinds of forms available on Website databases in general.
Click a heading, it expands. It would actually be nice if Microsoft made Access able to make the kinds of forms available on Website databases in general.
I think I'm gong to repurposed one my "not for Win 11" pcs to run Linux on it, and and get the GPT to help me build a web based "Local" database from scratch. Something I should have done years ago.
Sidebar: I'm going to start a new thread Doc about my recent experience using the GPT for developing in Python.
I've been dissatisfied with the lack of new features (in Access) and inadequate web integration for some time.
Sidebar: I'm going to start a new thread Doc about my recent experience using the GPT for developing in Python.
I've been dissatisfied with the lack of new features (in Access) and inadequate web integration for some time.
arnelgp
..forever waiting... waiting for jellybean!
- Local time
- Tomorrow, 05:08
- Joined
- May 7, 2009
- Messages
- 20,256
you can make it happen using VBA. I've seen many samples in this forum, lately.
- Local time
- Today, 16:08
- Joined
- Feb 28, 2001
- Messages
- 30,085
There IS such a thing as a TreeView in Access.
Access Europe - Wed 7 Aug: Using Treeviews with Access Applications (Pete Poppe)
The next Access Europe User Group meeting will be on Wednesday 7 Aug 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 Pete Poppe who is very well known to Access World Forum members as MajP In this session, Pete will...
www.access-programmers.co.uk
Hierarchical Data, Recursion, Tree-Views, and a Custom Class to Assist
Can someone point to the latest database with the latest features mentioned in this thread? There seems to be a lot of conversation and additional code, but I haven't found the authoritative file with latest info. MajP, you've done a lot of great work on this !!
www.access-programmers.co.uk
Hierarchical Data, Recursion, Tree-Views, and a Custom Class to Assist
I have had some people ask questions on working with Hierarchical data and Tree Views, which often involves using recursion. If not familiar with recursion this is where a procedure repeatedly calls itself until hitting a condition where it is told to stop. This is used often where you have to...
www.access-programmers.co.uk
isladogs
MVP / VIP
- Local time
- Today, 22:08
- Joined
- Jan 14, 2017
- Messages
- 18,801
Treeviews are definitely worth looking at.
Perhaps this idea will also be useful
www.isladogs.co.uk
Perhaps this idea will also be useful
Subform Shrink & Grow
This example shows how a subform can be shrunk/hidden or made visible/enlarged at the click of a button
www.isladogs.co.uk
GPGeorge
George Hepworth
- Local time
- Today, 14:08
- Joined
- Nov 25, 2004
- Messages
- 2,862
"...inadequate web integration for some time."
You probably remember two previous attempts to "Webify" Access. First in 2010 and then in 2013.
The problems associated with making Access work in the web environment are simply too hard to overcome. Plus given the fact that there are multiple alternatives, including the Microsoft PowerApps platform, it makes little sense to worry about too much about web integration for Access.
In the future, I foresee a category of hybrid apps, with rich, powerful Access interfaces on the desktop linked to cloud databases of some sort, probably SQL Server or Azure SQL, along with one or more browser-based interfaces to that same cloud database to support those functions that can benefit from a mobile, off-premises presence.
There's little incentive, I think, to try to return to the attempt to put Access in a browser given the other, more powerful options available for that purpose.
Granted, that means expanding your skillset dramatically, or perhaps not so dramatically. But definitely, to some extent you'll need to acquire new skills. On the other hand, it sounds like you're up for that challenge, so the opportunity is there.
That is exactly what I am building right now. As far as the skillset, Well, I'm getting the GPT to do Python coding and I'm acting like a designer not a developer. I'm going to start a new thread on what I have learned in the last few hundred hours of this project.
Thanks Doc,
MajP
You've got your good things, and you've got mine.
- Local time
- Today, 17:08
- Joined
- May 21, 2018
- Messages
- 9,493
Working closely with @dalski on a pretty robust treeview application
This is a large outlines of up to about 7k nodes. The levels are added dynamically and outlined numbered as nodes are added, deleted, and moved.
Nested Headers - Nested Subqueries/ Normalization Correct?
Video linked for explanation. I have 7 different HeaderTypes. Which I need to be displayed in a continuous form; similar to grouping on a report. Do not be fooled by the apparent sorted order of the BillTemsF. It appears sorted because correctly because BillHeadersAndItemsT ID has been created...
www.access-programmers.co.uk
MajP
You've got your good things, and you've got mine.
- Local time
- Today, 17:08
- Joined
- May 21, 2018
- Messages
- 9,493
Also if it is for display purposes and limited functionality you can use subdatasheets. If you are careful in what you show and play with the formatting you can make them pretty understandable. People often criticize them because users try to do too much with them and do not format them to make understandable.
Opinions on form design
I see. Thank looks soo much simpler than messing with a tree view. Thanks MajP!
www.access-programmers.co.uk
arnelgp
..forever waiting... waiting for jellybean!
- Local time
- Tomorrow, 05:08
- Joined
- May 7, 2009
- Messages
- 20,256
if you are looking for something to expand/collapse section of a form and
not a Treeview, then see if this demo is close to your need.
open MainForm.
// Edit: updated the code on the form.
not a Treeview, then see if this demo is close to your need.
open MainForm.
// Edit: updated the code on the form.
Last edited:
Web browser controls do it. You will have to code it yourself though. The link in post #11 will take you to an example you can adapt.
If you only require one level, you have a few options, such as:
1. Report embedded in report
2. Subform height programming
3. Section height programming
If you have the Edge browser control enabled, you could even import a react library for UI such as Ant Design and do cool stuff like:
https://ant.design/components/table#table-demo-nested-table <-- nest tables, anything really
https://ant.design/components/table#table-demo-tree-data <-- nest whatever in a row, can be a nested row
https://ant.design/components/collapse <-- nest whatever you need to any level
https://ant.design/components/tree <-- use the icon to embed whatever in the tree
Similar threads
