Recent content by Richard1941

OK, I figured out how to get two tables to have the same columns and how to do a UNION query. It merged the two tables, but not the rows. Where a person is both a member and a volunteer, I want only one row in the table with all the data. It's probably easy, but my brain is fried at the moment...

I'll try that. Thanks.

It's not quite that simple because I'm really working with several tables and many queries. All of the demographic data does come from a common table of people. The key to almost everything is the ID field from that table. There are also tables of membership history that us ID as a foreign key...

I support an organization that has both members and volunteers. Member data includes start and end dates. Volunteer data includes interest areas. A query that draws data from both tables only gives me those people who are both members and volunteers. How can I create a query that produces all...

I have a subform that formats the data in a record in a particular 2D way. I want to use it a variable number of times on a single form. Is there any way to do that? I've tried using CreateControl, but access just says it can't add the controls I've requested -- with no reason given, of course.

I have three subforms for selecting three values for a many-many relationship. When I run each of the subforms alone, they work perfectly. So I put them on the main form and one of them work and the other two don't. In the two that don't, no record is found although the combo box is updated...

I have started a new project where I have tables of people, organization, and roles, as well as one that is supposed to contain the relationships among them. In all four tables there is an AutoNumber ID field as the primary key. The fourth table, the relationship table, has as foreign keys, the...

In a report, I have a text box with variable length text. Can Grow is set to Yes. If the box grows, I would like all the subsequent lines to be indented. Is that possible?

I'm not sure where a delimiter comes in to play. We are entering the name information using a form. Whatever is typed in the field goes in as a value of a field in a table. The special charactes are in the table. Problems arise when trying to get these values back out. Apostrophes cause syntax...

My database has several tables (and queries) that have fields that contain people's names. Some names, like O'Neil, contain apostrophes. Other fields contain couple names, like Tom & Laura Jones. Both the ' and the & prevent queries, forms, and reports from working correctly. Is there anything...

That worked! Many thanks.

Doesn't help. It only shows how to get to the report. I can do that. I can select the parameter I want and bring up the correct report in print preview mode. When I close the report, it goes back to the form. I can then bring up a different parameter and get a different report. Finally, I want...

Private Sub Command6_Click() DoCmd.Close acForm, "frmCommitteeMembersReport" End Sub

I have created a form with a combobox for selecting one of several reports to generate. That part works fine. But I added a Close Form button to the form, and now every time I close the form, it changes the dropdown list of the combo box. How do I prevent the table that holds the list from being...

Let me pose the question differently. How can I get a subform to open only when I do it from the VB code?