Recent content by zappa007

Where can i find that?

Hello forum world.... I've been banging my head against the wall for 2 days on this...any help/insight would be appreciated. Objective: Open a main form, whose subform is value is defined by a control on a another form. Background: Main Form = frm_project_update Sub Form =...

I've created a PivotChart on my form, which works nicely. However, I would like to be able to format the PivotChart Field and save those changes. For example, I change the "team" to a blue circle. When it requeries, it sets it back to the default. Does anyone know how to change the...

I posted this in the wrong section...it was reposted in the Forms section and answered by KeithG... Thanks again, Keith

Thanks KeithG..... Worked perfectly....

Hopefully, someone out there can help as I believe the problem is relatively simple.... On my form, I have a combo box that allows only 2 values (planned & actual). When actual is selected, hidden fields appear; when planned is selected other fields appear. The fields are mutually exclusive and...

Hopefully, someone out there can help as I believe the problem is relatively simple.... On my form, I have a combo box that allows only 2 values (planned & actual). When actual is selected, hidden fields appear; when planned is selected other fields appear. The fields are mutually exclusive...

Hey Len, Wanted to give you a quick status.... Like I said, I inherited the database and the flaws in its design. I had to address those before I could get these combo boxes working properly. Once I made those changes, I was able to successing implement the cascading the way I wanted. When...

hey Len, you've given me plenty of insight...as a matter of fact, i think it sparked the answer... I will play around with it over the next day and let you know how I make out... again, i really appreciate the time, patience, and wisdom.. ed

here is the union qry code...may or may not help Select group from list:group UNION Select qry_Update.group from qry_Update;

No.....how about i give a little more info...I inherited the database, so please forgive the naming convention. I know it isn't the best... The groups are R&D, CSS, M&S (and several others)...they were put in a table called List:Group when I created the union query (union_wry_update) between...

Hey Len We're close.... I made the changes but still get this error.... The number of columns in the two selected tables or queries of a union query do not match... here's the code... SELECT DISTINCT union_qry_update.group FROM union_qry_update UNION Select null, "<All>" as Bogus FROM...

Hey Len, We're close....I mean really close... I made the changes but now I receive this error... The Number of Columns in the two selected tables or queries of a union query do not match. here's the code... SELECT DISTINCT union_qry_update.group FROM union_qry_update UNION Select null...

Hey Len, I'm getting very close.... I fixed #2 below...that works fine...just had a little code issue... But I still can't seem to figure out #1...repeating values.... Here's my code... SELECT DISTINCT [list:group].group, [qry_update].group FROM [qry_update], [list:group] UNION Select...

Hey Len, I'm getting closer. Thanks for the point in the right direction. It works with 2 exceptions. 1. I get repetitive values in the combo box. (I think it has to do with the format of the table/query) 2. When I select <all>, no values appear in the next combo box. That one has me...