Results 1 to 9 of 9
  1. #1
    mainerain is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Sep 2018
    Location
    Maine, USA
    Posts
    146

    Main Menu that has a stat section that has either static or dynamic data

    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

  2. #2
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    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.

  3. #3
    orange's Avatar
    orange is offline Moderator
    Windows 10 Office 365
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    mainerain,

    Can you mock up a graphic to show the concept with some representation of what you want?

    Here's a sample from Alessandro Grimaldi with list boxes on a form showing the various objects in a database -similar to micron's comment.

    Click image for larger version. 

Name:	SampleObjectsInDatabase.PNG 
Views:	16 
Size:	18.4 KB 
ID:	45116

  4. #4
    mainerain is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Sep 2018
    Location
    Maine, USA
    Posts
    146
    Something basic for starters.

    ITEM IN USE NEED REPAIR SPARES
    MODEL 1
    MODEL 2
    MODEL 3

  5. #5
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    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.

  6. #6
    mainerain is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Sep 2018
    Location
    Maine, USA
    Posts
    146
    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.

  7. #7
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    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.

  8. #8
    mainerain is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Sep 2018
    Location
    Maine, USA
    Posts
    146
    Thanks Micron,

    That's what I needed.

  9. #9
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    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.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Dynamic Data, Static fields
    By amitmm_10 in forum Import/Export Data
    Replies: 4
    Last Post: 02-01-2018, 11:06 PM
  2. Main menu
    By BSJoJaMAx4 in forum Access
    Replies: 13
    Last Post: 08-29-2015, 07:36 PM
  3. Main Menu
    By MarkV in forum Access
    Replies: 3
    Last Post: 12-07-2014, 09:57 PM
  4. Create Dynamic Drop Down Menu
    By jmfranqui in forum Access
    Replies: 1
    Last Post: 02-02-2012, 12:11 AM
  5. Main Menu and Sub Menus
    By REngelbr in forum Access
    Replies: 0
    Last Post: 08-25-2009, 03:51 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums