Recent content by springwood01

OK, I figured out myself. Instead of having the combo boxes as unbound, I bound them to their field name and that seems to do it. Confuses me a but since most instructions tell you to keep them unbound. Sorry for the premature posting. I had tried everything but this one change. Case closed.

although I know how to do this, I usually have to do it a couple of 3 times to make it work. Can someone explain to me why when I make a selection in combo box one, and then go to combo box 2 and select a name proper for the Box 1 selection, this same selection appears on all suceeding pages...

This thread can be closed as I have figured it out and got to what I wanted with minimal query activitiy. thanks everyone for your responses as it gave me some ideas to proceed.

Sorry I rushed my response back but I was being called into a meeting. Let me give you sample data so you can see what I am working with. This comes from my Corrected SQL above that gives me all the A & B's that have a no listed. The NO means they did not meet the criteria for that health...

Golom, please note the SQL correction I sent before I got your response. My 1st query gives me 315 records of people with a "NO" in the categoryID field for either categories A or B. In some cases, the same person could be listed twice as they have a "no" for both A & B. For report #1 I need...

OPPs, gave you incorrect SQL for problem. Here is the correct one: SELECT AutoCamNo.FullName, AutoCamNo.ActiveContractNum, AutoCamNo.LastOfCompliant, AutoCamNo.CatID, AutoCamNo.CatName FROM AutoCamNo GROUP BY AutoCamNo.FullName, AutoCamNo.ActiveContractNum, AutoCamNo.LastOfCompliant...

This should be easy, but I'm looking for advise on quickest/easiest way to get results I need. Initial query with SQL is below. I have a criteria of A or B in CatID field. This gives me a record of all persons who have a no for either the A or B category. I need to generate 3 reports from my...

While you were working on your return post, I was always trying some different things and came up with the one that works (your 2nd post did not). Note the changes I made in the IIF statements. Works perfectly now. Thanks so much for getting me on the right track. IIF(P0.[0%Contract#] >...

Well, I was somewhat in the right direction but you have now made sense of it. One minior problem, when I run the query, instead of a Yes, I get #Error. I tried to play with it a bit, but obviously I have not touched on what will make it go to yes. Any Ideas?

Have 423 records that needed to determine if they were 0%, 50% or 100% compliant to established criteria. Have this figured out based on a positive entry of their account # in one of the 3 columns. Need to have a report like this that either shows yes when a account# appears or an X. Tried to...

thanks for the starting point PH. I will work with it and think this will get me to where I want to be. Thanks.

I am learning about Smart tags in MS 2003 and they are prety neat. One question though. In this dbase I inherited it uses "SmartTags#PersonsName" in the field "sent to". I have not been able to determine if there is a way to use the same field to set a parameter, IE. [Enter first name]. When...

thnks for your responses. I hadn't planned on putting my code on a close button, but if need be I can do that. This is what I can come up with at this point if I use bottons/check boxes, one for "Open" and one for "Closed". What I really want is to keep my drop down with the "open" and...

I have looked at some of the posts but can't find my situation. I am fairly new at Access and have an project form that is initially filled out by a unit lead, indicating who it is assigned to with a status of “Open” from a drop down box. It is then given to an employee to complete. Once the...