Recent content by krberube

I know I have seen this somewhere before but can't seem to find it now. On a report, I have a calculated textbox -- =Sum(IIf([ServiceOrderStatus]="2",1,0)) If the sum = 0 I want to set the visible property to "false" what would be the best way to so this? thanks Kevin

Modest: you have it correct. I Believe it to be pretty straight forward to do. Thanks

I seem to have alot of trouble doing graphs in access, at least getting them to look the way management wants them. I found that by exporting the data to excel, changing the data a little (graph is updates by itself), saving the .xls file. Then show the excel graph in the access report it...

Good afternoon all, If I place some code to export a table to Excel, open excel so a person can do something, then close excel. will my access code wait for excel to close before the code continues running? If not, what would a good way to code this "wait" into the event? Thanks Kevin

ahh, thats how the report ( query) started, it has sinced morphed into a more complicated and useful report. I found a post ( right after i posted the thread) that gave >=DateSerial(Year(DateAdd("m",-6,Date())),Month(DateAdd("m",-6,Date())),1) This seems to have worked Thanks

Good morning all, I currently have the following expression in a query, to go back 6 months from the current date. Between DateAdd("m",-6,Date()) And Date() Does anyone know of a way from the current date, go back to the end of the previous month ( 30th, or 31st) then go back 6 months? hope...

Thanks guys, I will revisit the ON NO DATA EVENT when I complete the items on my "now" list. It sounds like that will also be a good way to do it. Kevin

OK, I was able to get Dcount to verify there is data or not, and with the If/Then run a report based on the answer. This worked out great, thanks for the ideas everyone! If DCount("ShipDate", "ServiceSummaryByCust") = 0 Then MsgBox "No Data found, You will get a summary version."...

I think I am going to change this report abit. If I can figure out how to get code to check for NO DATA, then if no data, run another report which will have no calculated values and give just a few static items. Would SJ's Dcount idea be a good way to check for data, then do something else...

yes, the query uses a date range entered into a form for retrieving the data. if thats what you mean.?

i understand what your saying now. I placed this in the clk event for the button and now I receive a message "run time error 2001 you canceled the previous operation" The error line is: If DCount("*", "my query is here") = 0 Then Thoughts?

Still trying guys. Do you think there may be something I can do in the "on no data" event of the report? thanks for the ideas so far. EDIT: SJ, could you elaborate on that for me abit? Thanks

sorry Ken, still shows #ERROR. Gold007eye, I will try to fool with the IF/THEN.

Hi Ken, here is the calculation I use in 1 of the fields =([closed]-([SW]+[NPF])) Not sure how to get the isnull() or nz() incorporated into this. Kevin

Good morning all, I have a report with several calculated fields in it. When I run the report for a date range that returns a message box "no data found" the report shows up with "#ERROR" in all the calculated fields. Is there a way to just show 0 in these fields instead of the error message...