Create Forms Wider Than the Access Limit

[isladogs]

As most developers will be aware, Access has for many years had a specified form and report width limit of 22.75 inches (57.79cm).
The Access team are currently working on large monitor support and form responsiveness. As a result, this restriction is likely to be removed later this year.

However, my article, Create Forms Wider Than the Access Limit, shows that you can already exceed the specified limit for certain form and control types including datasheets, charts, images and browser controls allowing you to get maximum benefit from ultra high definition monitors.

This can be useful in certain situations e.g. for displaying charts with a lot of data or when doing presentations to a group on a large monitor
For example, here's an example of an Access stacked column chart with 99 columns that is 36 inches wide! It was illegible on a standard 22 inch wide form

You may need a widescreen UHD monitor to do it justice
How is it done? Read my article!

 

[GPGeorge]

As most developers will be aware, Access has for many years had a specified form and report width limit of 22.75 inches (57.79cm).
The Access team are currently working on large monitor support and form responsiveness. As a result, this restriction is likely to be removed later this year.

However, my article, Create Forms Wider Than the Access Limit, shows that you can already exceed the specified limit for certain form and control types including datasheets, charts, images and browser controls allowing you to get maximum benefit from ultra high definition monitors.

This can be useful in certain situations e.g. for displaying charts with a lot of data or when doing presentations to a group on a large monitor
For example, here's an example of an Access stacked column chart with 99 columns that is 36 inches wide! It was illegible on a standard 22 inch wide form

View attachment 118219

You may need a widescreen UHD monitor to do it justice
How is it done? Read my article!

Sweet screenshot. Fortunately I do have a 28" UHD monitor.

Question for follow up.

Does anyone have a use case for a report like this? I can think of one that I now produce in PowerBI for pricing history of common purchases.

I may try to reproduce it in Access this way instead.

 

[DHookom]

George, maybe for someone who walked regularly and stored all of these excursions in a database for several years. This could provide a great overview graph

 

[GPGeorge]

George, maybe for someone who walked regularly and stored all of these excursions in a database for several years. This could provide a great overview graph

Oh, even better. Unfortunately, the downward trend over the last couple of years might be depressing laid out like that.

 

[isladogs]

George, maybe for someone who walked regularly and stored all of these excursions in a database for several years. This could provide a great overview graph

Good idea! I've got walking step data on my phone for each day for the past few years - not sure if it can be exported though!

In the meantime, here are two more examples:

1. A Pareto chart of the same data as in post #1

2. Combo chart of blood health data (not my own!) - really needs more data points though. . .

 

[GPGeorge]

Good idea! I've got walking step data on my phone for each day for the past few years - not sure if it can be exported though!

In the meantime, here are two more examples:

1. A Pareto chart of the same data as in post #1

View attachment 118222

2. Combo chart of blood health data (not my own!) - really needs more data points though. . .

View attachment 118224

Re: data extraction. I use MapMyWalk on my iPhone. It supports exporting the data as a .csv file from their website. However, I also have an Access/SQL server database application which I have used for years, going back to before I acquired MapMyWalk. That is admittedly redundant.

I don't know if the native apps on a smart phone would support exporting the data, but I'd almost expect that to be possible via an API somehow.

 

[The_Doc_Man]

This was years ago, but we had a situation where we had to demonstrate compliance levels for machine security and a bar chart allowed us to show percent compliance for a given server. When the chart in question was for a single project, ordinary screens were fine. But with the military, there are groups within groups within groups. If we had to build a report for one of the wider groups, with the Y axis as compliance and the X axis as the base for the bars of potentially several hundred individual systems, this would have been helpful.

 

[isladogs]

Re: data extraction. I use MapMyWalk on my iPhone. It supports exporting the data as a .csv file from their website. However, I also have an Access/SQL server database application which I have used for years, going back to before I acquired MapMyWalk. That is admittedly redundant.

I don't know if the native apps on a smart phone would support exporting the data, but I'd almost expect that to be possible via an API somehow.

Thanks
According to CoPilot the Health data can be exported without the need for an API. I'll try it later

You can export your walking step health data from your iPhone using the Health app. Here are the steps:

1. Open the Health app: On your iPhone, open the Health app.
2. Tap your profile picture: In the top right corner, tap your profile picture.
3. Select Export All Health Data: Scroll down and tap "Export All Health Data".
4. Create the export file: Your iPhone will create a ZIP file containing all your health data.
5. Transfer the file: You can transfer this ZIP file to your computer using AirDrop, email, or any other file-sharing method.

Once you have the ZIP file on your computer, you can unzip it and access the data. The data is typically in XML format, which can be imported into spreadsheet programs like Excel ...

 

[DHookom]

I had used MapMyRide years ago but switched to Strava. Strava data can be pulled into VelowViewer which is data paradise. All data can then be exported easily to CSV.

 

[Mark_]

Last "WIDE" report I had to do was for manpower management. For a joint task force I had to show each position in the task force, who was in it (horizontal bar, vertical lines for end of week) and when they were arriving / departing. Needed to show overlap for handover and the nice gaps for when a position would not be filled timely.

And you wonder why the military LOVES giant printers!