Recent content by scottk

Thanks for the help Pat, the report w/ nested subreports worked perfectly. I was so insistent on queries earlier b/c I was hoping to use the same query for several different reports but oh well, what is, is. Thanks again.

There definately must be a many to many relationship between categories and personal Information. "Chapter Member" is just one of several categories a person can belong to and they can belong to several at once. Really for the Officer section I could convert it to a one to many realtionship...

What I am ultimately attempting to do is create a list of chapter members and officers without duplicating. Let me explain how the tables are organized. There are 5 tables pertinent to this process. Please note that I am not able to change the structure of the tables without destroying...

Ok, I believe this is what you want to do: 1) set up three tables. One for customer information. One for Product information. One for order information. The order information table should contain two fields the Customer ID field and the Product ID field. Use the relationships menu to...

No. It does not do it. Thanks though for the quick responce.

I have a multiselect list box and I would like to place a button below it that will clear the highlighted rows when pressed. However I am having difficulty figuring out the code to place behind it. Can anyone help me with this?

You'll have to write code. I'm not 100% sure that I understand your question though. In the givin example are your trying to obtain the answer 9/12/01 or are your trying to obtain "Tuesday" or are you looking for something different?

I assume that the color is entered into a text box. With this assumption place this code in the "after update" event of the text box. Private Sub ColorBox_AfterUpdate() On Error GoTo Err_ColorBox_AfterUpdate Dim strColor As String If Me.ColorBox = "White" Then strColor = 16777215...

That did it. Thank you Pat.

I am having difficulty appending records to my tables becaue of validation rule errors. I have recieved a complete list of newspapers, radio stations and television stations for my state from another company. The list was originally in an excel spreadsheet so I imported it as a new table. I...

I have three tables in my database. Personal Information -------------------- Personal ID Name Address Phone Attendance ---------- Personal ID Event ID Events ------ Event ID Event Name Date The obvious fields relate to each other. What I need to do is query for people who attend one...

Well done Rich, that works perfectly! Thanks for the help.

The objects used here are: polLabels, a button, PoliticsSelect, a list box, and Branch, an option group. The idea here is to open a selected report and apply a filter based on whatever is selected in the option box The problem exists with the following two lines DoCmd.OpenReport "Address...

I think what davids is grappling with is a similar problem I am encountering. It would be helpfull to set this up like mailing labels where the fields dissappear automatically. I have tried duplicating the mailing lables using the Trim function, and the can grow, can shrink property but still...

Thanks for the help guys. Travis, I think I've filled in all the field names propperly but I'm gettinga type mismatch error. Any tips on how I can troubleshoot this? Here is the modified code. Private Sub cmdChapter_Member_Click() On Error GoTo Err_cmdChapter_Member_Click Dim stDocName As...