Results 1 to 13 of 13
  1. #1
    KitesurfRob is offline Novice
    Windows 11 Access 2021
    Join Date
    Apr 2023
    Posts
    5

    Screen Form multiple columns

    I want to make a Form for displaying records in multiple columns on the screen.
    Something like this:

    Record 1
    Field 1
    Field 2
    Field 3
    Field 4
    Record 2
    Field 1
    Field 2
    Field 3
    Field 4
    Record 3
    Field 1
    Field 2
    Field 3
    Field 4
    Record 4
    Field 1
    Field 2
    Field 3
    Field 4
    Record 5
    Field 1
    Field 2
    Field 3
    Field 4
    Record 6
    Field 1
    Field 2
    Field 3
    Field 4
    Record 7
    Field 1
    Field 2
    Field 3
    Field 4
    Record 8
    Field 1
    Field 2
    Field 3
    Field 4
    Record 9
    Field 1
    Field 2
    Field 3
    Field 4
    Record 10
    Field 1
    Field 2
    Field 3
    Field 4
    Record 11
    Field 1
    Field 2
    Field 3
    Field 4
    Etcetera

    On a paper Form I know how to do it, but how do I make this on a screen Form?
    And I want to be able to edit the records/fields.

    Thanks in advance,

    Rob
    (the Netherlands)
    Attached Thumbnails Attached Thumbnails Columns.jpg  

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    This is not how forms are intended to work. Do you want to be able to do data entry in this structure?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    davegri's Avatar
    davegri is offline Excess Access
    Windows 11 Access 2019
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,388
    Only two ways I can think of: Listboxes or subforms. To keep it manageable, if there are dozens of records, have a button the loads the next x number of records into the boxes.

  4. #4
    KitesurfRob is offline Novice
    Windows 11 Access 2021
    Join Date
    Apr 2023
    Posts
    5
    I prefer to edit in this structure.
    If that is not possible then I have to accept that I only can display it.

    It is a database for my record collection, vinyl and CD.

    So hundreds of records of the albums.
    If I click on the album I want to load a new form with the album items of the clicked album.

  5. #5
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,858
    You would use a Mainform/Subform approach for that.
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  6. #6
    KitesurfRob is offline Novice
    Windows 11 Access 2021
    Join Date
    Apr 2023
    Posts
    5
    I was hoping that Microsoft would have a pretty simple solution. In HTML you have Rows and Colums.
    Now I will make it with VBA. This cost some programming effort.

    Thanks for the reactions.

  7. #7
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,858
    Yes, when you swim against the tide, it always takes more effort.
    We have another member on here, that is hugely dismissive of the way Access does things.
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  8. #8
    moke123's Avatar
    moke123 is online now Me.Dirty=True
    Windows 11 Office 365
    Join Date
    Oct 2012
    Location
    Ma.
    Posts
    1,643
    You could use a report or sub-report with a click event to open an edit form

    https://www.youtube.com/watch?v=_JAk6z8ODvY
    If this helped, please click the star * at the bottom left and add to my reputation- Thanks

  9. #9
    KitesurfRob is offline Novice
    Windows 11 Access 2021
    Join Date
    Apr 2023
    Posts
    5
    You only get the multi comlumns in the Print view mode and unfortunately not in the Report view mode.
    Otherwise it was the solution.

  10. #10
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    If you can do it in HTML, you could display in a large web control

  11. #11
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    What is your objection to using subforms? You only need two forms, the main form and a subform. You can have multiple subform controls on the main form all hosting the same subform. You just need to set the linkchild/master properties to just bring through the one record. The trick is how to do this. Providing your table has a pk, should be pretty straight forward

  12. #12
    davegri's Avatar
    davegri is offline Excess Access
    Windows 11 Access 2019
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,388
    What's your table structure? Is everything in one table or do you have separate tables for album, songs, artists, genre? How much information do you keep track of, like composers, date of production, release date, song time durations, etc?
    Can you upload an image of your table relationships? That would greatly expand our understanding of what needs be involved with your proposed form design.
    Is your music collection actually on vinyl and CD or is it in your Windows Music Library?

  13. #13
    Edgar is offline Competent Performer
    Windows 8 Access 2016
    Join Date
    Dec 2022
    Posts
    271
    Do you want it to be "responsive" as in web design?

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

Similar Threads

  1. Replies: 7
    Last Post: 11-02-2018, 03:04 AM
  2. Replies: 2
    Last Post: 05-21-2017, 05:40 PM
  3. Replies: 1
    Last Post: 05-01-2017, 12:11 PM
  4. Replies: 2
    Last Post: 05-15-2014, 06:15 AM
  5. Replies: 7
    Last Post: 01-02-2013, 11:23 PM

Tags for this Thread

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