Search results for query: *

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

Thanks for your help Gates A little while back I thought up of a soultion pretty close to what you have. But I didn't use the Docmd.restore part of your code. I will insert it and see what it brings to the party. Thanks for respoonding, ZaZa

Hi everyone, I have a similar problem. I have a form with several selection criteria . When I hit the open report button,I want it to NOT open the report if there is no data. When I try the Cancel=True that Seaport suggested, I get an error " The Open Report Action was cancelled" I...

Hi, For anyone who might be having this problem, the Marquis and MicahealRed helped me to sort it out in another post. THe key was in creating several criteria and joining then at the end by using "And" and PARENTHESES to make a final criteria that will be used to open the report...

Yipee!!! NOW I GET IT! THANKS A LOT MARQUIS AND MICHAEL! I finally got the parnes thing! :~/ I finally got the parens thing! s-) I finalyy got the parens thing! :~/ I finally got the parnes thing! s-) I finally got the parens thing! :~/ I finalyy got the parens thing! s-)...

Marquis thanks for respondinig, I kind of figured that I wasn't communicating clearly but then I thought maybe you guys DID understand BUT I just didn't understand Michael's post very well. Your and Michael'r idea is wrong. I want [SelectStatus]= Open AND [selectPriority] = A and...