What would be a good approach to gather data of varying types from multiple tables and display them on a Main Menu for quick reference? Sort of a Talley Board. Run query's that write to a table and reference the table on the Main Menu?
Thanks
What would be a good approach to gather data of varying types from multiple tables and display them on a Main Menu for quick reference? Sort of a Talley Board. Run query's that write to a table and reference the table on the Main Menu?
Thanks
Last edited by mainerain; 04-29-2021 at 10:38 AM. Reason: title clarity
Probably lots of ways, depending on what exactly you want to see. Your idea would be one, I think. Another might be small subforms or maybe other controls such as listboxes which you can place side by side or beneath. Then there's bound and unbound frames for things like documents or charts, image controls for things like gauges but those are more like dashboard items.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
Something basic for starters.
ITEM IN USE NEED REPAIR SPARES MODEL 1 MODEL 2 MODEL 3
As long as you can get a query to look like that, a simple subform should suffice. If there's no related data on the main form, then you don't even have to worry about subform linking.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
How do I get the various data in one place?
i.e. how many model x from tbl1, how many model y from tbl1, how many model z from tbl2, how many model a from tbl3 etc.
Create a query that does that. Include the necessary tables with the required joins. If you must do totals from various tables, you'll probably have to create a Totals query on each table to get the desired results per table, then join the queries (as if they were tables) in a final query that pulls it all together. Your subform recordsource would be whichever query gives you the data the way you need it to be. I have no idea what your tables look like or anything else, so that part is up to you.
Last edited by Micron; 04-30-2021 at 07:57 AM. Reason: clarification
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
Thanks Micron,
That's what I needed.
You're welcome. Sorry I didn't grasp that right away.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.