Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. JStrand

    DoCmd.OutputTo Method - HTML Syntax - Output Format Not Available

    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...
  2. JStrand

    DoCmd.OutputTo Method - HTML Syntax - Output Format Not Available

    ....html image instead. I am chnaging 2 lines of code to achieve this. The first is changing the forrmat type from: 'strOutputFormat = "PDF Format (*.pdf)" to: strOutputFormat = "HTML Format (*.html)" The 2nd change is the output To statement from : DoCmd.OutputTo acReport, strObjectName...
  3. JStrand

    Passing Variable From Form to Module - Syntax Problem

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

    Passing Variable From Form to Module - Syntax Problem

    ...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 INTO WO_Contract_Watchlist_Tbl_All FROM Branch INNER JOIN UnionScorecardBranchQryCrosstab_All_ForAnalysis ON...
  5. JStrand

    Limit Digits on Text Box in Output

    Very helpful. Thanks Again Duane.
  6. JStrand

    Limit Digits on Text Box in Output

    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.
  7. JStrand

    Limit Digits on Text Box in Output

    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...
  8. JStrand

    Limit Digits on Text Box in Output

    ...box, therefore ######## appears. The result when I increase the width of the test box is 221120.4% which I want to be represented as a "?" or "*" instead of the # signs. I must be missing something. Private Sub ReportFooter_Format(Cancel As Integer, FormatCount As Integer) Dim ctl As...
  9. JStrand

    Limit Digits on Text Box in Output

    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.
  10. JStrand

    Limit Digits on Text Box in Output

    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.
  11. JStrand

    Limit Digits on Text Box in Output

    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.
  12. JStrand

    Limit Digits on Text Box in Output

    ...if the denominator happens to be very small for that branch and period...
  13. JStrand

    Limit Digits on Text Box in Output

    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...
  14. JStrand

    Conditional Formatting Problem - VBA

    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..
  15. JStrand

    Conditional Formatting Problem - VBA

    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...
  16. JStrand

    Conditional Formatting Problem - VBA

    Changing Backstyle = normal does the trick. Thanks Duane.
  17. JStrand

    Conditional Formatting Problem - VBA

    Backstyle = transparent backcolor = #FFFFFF
  18. JStrand

    Conditional Formatting Problem - VBA

    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...
  19. JStrand

    Conditional Formatting Problem - VBA

    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...
  20. JStrand

    Customizing Output To Object Location

    Thank You PHV. Problem solved!

Part and Inventory Search

Back
Top