Clever Geek Handbook

Merging cells in ms-access

I am using access 03. let's say I am modeling the sides database. each party has invited people. each side also has a place and date. when presenting information in a form, I want to be able to combine repeating cells. something like:

 _________________ ____________ ___________
|                 |            | invitee 1 |
|                 |            |-----------|
| partly location | party date | invitee 2 |
|                 |            |-----------|     
|                 |            | invitee 3 |
 ------------------------------------------

This is very similar to what you can do in ms-excel. is there any way to do this?

edit: Subforms suggested. however, it seems that when using subforms, I can only show one side at a time, and I need to scroll through them using the arrows when I instead want to show all sides at once.

+1


source to share


5 answers


In the form, you can use the main form with the location and date of the party, and then have a subform with the list of invitees.



+3


source


Access just has no function. You can do this in the report, but not in the form. There are several things that might come close. If you create a data subformat with the original data table shape, you get expanding and collapsing cells. IIRC you can programmatically expand all cells at the initial presentation.

You will need to nest data subformats to navigate to the third column in your example.



It might also be possible to use the form view to nest multiple subforms at the level you want, but I think you'll run into some ugly scrollbars at some point. It will be difficult to make him worthy.

I would give crushing data. Other than that, I think you are looking at custom, third party controls that can be a pain in Access.

+2


source


Don't use datagrid access view for access.

You can achieve this by creating a form with an additional form, so that the main form will display the location and date, as well as a sub-item, a list of invitees.

+1


source


Flex Grid Control will probably do what you need, but you will need to write some VBA code, take a look at my Flex Grid Demo for some examples.

Go to http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=180

NTN

Peter Hibbs.

0


source


You can do this with Access 03. Just create two tables: tblParty and tblInvitees. The tblParty table will contain location and date information. The tblInvitees table will contain the names of the invitees. Create a link between the two tables with "PartyID". You can enter information into a table, but it is best to use it in a form / sub-format because it is easier to look at.

0


source






More articles:


All Articles