Recent content by ZaZa

Hi Waynest or Wilson, Did any of you guys fuigure this one out? or anyonbe out there, for that matter? I have a similar situation, The difference is that on my main form I have an option group and I need to requery the subreport's recordscource based on the value in the option group. My code...

ANYONE???[Sadeyes] [Sadeyes] [sadeyes] ZaZA

Opps, It looks like the CT Table is not properly aligned. The /'s are supposed to represent vertical lines between columns and the words "Pass/Fail" are supposed to fall directly under the word "TestY". Regards, ZaZa

Hi Everyone, I have a really sticky problem with a cross tab query that I am developing for a welding department. I want to split the column Heading into two "sub columns" depending on the value Column having a certain criteria. Let me explain: I have a CT query with the follwong...

Hi, Thanks to Pezamystick, I can now show the criteria in a report. BUT I HAVE A COMPLICATION: I used list boxes and combo boxes on a form to allow the user to select a combination of criteria. By hitting a button, the report would run with the selected criteria as the filter. However these...

Thanks Pezamysti, That advice was really helpful to me also!! ZaZa

Jerby, Thanks for yout last post! I finally got it to work with your and Rick Spur's help and adding that last piece of code to the after update event of the "Systems" listbox. Only thing is that I had to omit the word [DISTINCT]from the sql statement for it to work. I don't know...

Hi , RickSpur and Jerby, Thanks a lot for responding. I am attempting to do what you two have advised and so far in the debug window, I get what looks like an appropriate string . I think my problem starts when I try to write the SQl statement becuase the VAlUES list box does not get...

Hi folks, I have a question, I hope that you good people out there can help me. I have a list box ( called SYSTEMS) which I use to limit the contents of another list box ( called Valves). The row source of the listbox "VALVES" is based on a query that relates the valves to the...

To: MichaelRed, Marquis or ANYONE, There is now a continuation to the above story.... I am trying to add another textbox called [SelectResolvedDate] which allows the user to get records that were "resolved" (i.e.[StatusID] = Closed) AFTER any date specified . Ultimately, I want all...

Hi everyone, I orginally set up my reports so that they fit on an 11.7 x 17.7 paper ( because my bosses wanted it so). Now they want to know if they can have the option of resizing the report to fit unto a normal letter sized page. But I Don't want to give them design rights to the reports...

ChristyT, I had two date fields on my report that i wanted to compare: Me![Date1] and Me![Date2]. If date2 was later than date1, I wanted the entire row in the report to be grey. SO leaving out the mod parts of Katerine's code I just used the following on the format event of the deatil section...

Jenny, A breif description can also be found in the Access help under "Mod operator". ZaZa

Katerine, Thanks for posting that tip! I used it in a report to highlight any row of info where the date was greater than another date. I kept using "me.backcolor" with no results until I saw you use "DETAIL.backcolor" and then the lights and sirens started going off in my...

Linda, I looked at the site but I didn't see any tips on conditional formatting. Can you give me a liitle more directions please? Regards, ZaZa