Search results

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...

Hey Len, I've been playing with the code and can't seem to get the ALL part right. Could you have a look at it and maybe point me in the right direction. **Note: This is the code from the first combo box. It works perfectly, however, when I put in the UNION...etc, it bombs. May just be the...

Hey Len, This was my first post to this forum and if you are representative of the people that lend their help to people like me, then this site is far superior to any comparable site. So far, the advice you gave has worked perfectly. I'm still playing with the ALL portion of the code but it...

I agree about controlling the user...I am having a hard time finding the example you referenced...if you could get it from the database you mentioned, i'd appreciate it... thanks

Hi Len, Thanks for taking the time to reply. I do have one question, maybe problem, with the your idea. In some cases, cmbo1 will be null, i.e., users may not wish to filter based on that value. They may just want to see all records pertaining to the value selected in cmbo2. I've read...

I have 4 Combo Boxes on my form (cmbo1, cmbo2, cmbo3, cmbo4). I have successfully managed to get the cascading down as long as the user starts with cmbo1. What I would like to be able to do is have the user select any combo box on the form and have the rest of the boxes filter automatically...