Search results for query: *

Thanks PH. This syntax definitely works. My problem now is that the HTML files created do not hold all the native access formatting details. Vertical lines are dropped, the header format is not exactly the way it appears in either the Access preview of the report, or the PDF files which I was...

I have a module which outputs a .pdf file per loop out to a location. I am trying to modify the code below so that it outputs the object as an .html image instead. I am chnaging 2 lines of code to achieve this. The first is changing the forrmat type from: 'strOutputFormat = "PDF Format...

[" & [intPeriod] & "] This did the trick. Thank you Gentlemen!

I have a basic query shown below which has a crosstab as a datasource. The fields in the crosstab contain periods of the year as the Column header. The query below is pulling period 2 data. SELECT Branch.Branch, Sum(Abs([ReportGroupBook] In ("12Actual"))*[2]/1000*-1) AS WO_GrossRev_Actual...

Very helpful. Thanks Again Duane.

Thanks Duane. This works perfectly. I'm not quite sure why the format didn't work based on the previous code. It seems like since the abs value was >10 the first format should have applied and yielded a ?. Why did the line require an additional ""?"" . Thanks again.

Thanks Duane. I hadn't used the tag property before. This works perfect for converting the values above 1000% to "?". I'm having difficulty coming up with a test for +/-1000%. I attempted using Abs on the ctl.value statement but it is not picking up the negative as being >10. Private Sub...

Thanks Duane. I've altered the names as to include "format" such as [ScheduleADBudget1Format] which is used in my January column. Does modifying the tag achieve the convention you mentioned? I've added the code on the format event of the Report Footer where my text boxes are but getting the...

I have all my controls tagged. I'm having difficulty finding the SQL to test the value. One such tag is [ScheduleADBudget1]. Do you know of any references for SQL on testing where the value exceeds a certain number of digit? This Control is formatted as a percentage with one decimal.

Thanks Duane. I'll try to test this on one control in the on format event. I'll do some searching on syntax for setting the format property based on the values exceeding a certain number of characters.

I have 5 Crosstab's unioned. The union Qry is the datasource for the report. ActBud can equal Actual, Budget, PriorYear, LYFull Year, TY FY Budget. I need to distinguish which ActBud is to be used in the appropriate text box calcs.

Thanks Duane. Currently I'm not summarizing the data on the Cross tab enough to perform this test at that level. My Cross tab groups and categorizes the specific branch data by period 1-12 with SumOfCurrentPeriod as the value. TRANSFORM Sum(BranchMasterTbl.[SumOfCurrent Period Budget $])...

I have many text boxes on a crosstab report which have percent calculations. In some cases the result of a calculation will exceed 6 digits, such as 647925%. I want to be able to control the outcome to lets say 6 digits, and a question mark if that size is exceeded. Right now if the width of...

I was missing a name on my control source and this SQL appears to work for the second condition. If you see any other problems please advise. Thank you..

I have an additional condition format to be applied to the problem above which I need some help with. The test above was for a format to be applied (backcolor = yellow)if a condition was met for a specific period. Now I need an additional format to be applied (backcolor = red) if the same...

Changing Backstyle = normal does the trick. Thanks Duane.

Backstyle = transparent backcolor = #FFFFFF

Thanks MajP. I used your suggested method first and strangely it will apply a bold type face when the condition is met, but won't apply a backcolor of yellow. Therefore I tried the VBA method on the report detail section. There must be some other backcolor property overriding the conditional...

I have a report with Field Name = [WO_GrossRev_Var1] which is in the Detail Section of the report. The Datasouce contains a hundred records or so. I want each record on the report to have a BackColor of Yellow (RGB(255, 255, 0))if the value is <-0.0050 else black. On the On Format Event of...

Thank You PHV. Problem solved!