With 16 data lines letting the line color to automatic as data lines 11 and 12 virtually the same color. I can not distinguish the lines from one another. Now to find 16 unique colors.....
Yea, I am stumbling across a few options, like Border.LineStyle = 1 <- Don't know what make a dashed line and other options (yet).
Figured this one out: Border.Color = 255
Trial an error, but I didn't figure out what you gave me! lol
Can you selectively remove a line from the legend...
Wonderful! That worked perfect. Is there a list somewhere that shows all available controllable graph options? My help file does not work well. Such as change a line to dashes, dots, smooth, ect. When you have a chart with 18 lines, it is easier to do it in VBA that clicking on the line...
I am a bit rusty. Using a Microsoft Chart Object 6.0 in an Access 2010 report. It's easy enough to do the basics and that chart responds to data.
In my case, I have 12 lines, or columns, being controlled by data. It responds to the data. just fine. What I want to do is control the line...
If I use the following SQL statement, the Dates sort Ascending order and the time assorts in Descending order:
strSQL = "Select * From [tmpTempSAPFiles] Where [Technician] = '" & Forms!frmCertify!Technician & "' ORDER BY [FileDate], [FileTime] DESC;"
I need the data to sort DESCENDING by...
After all these years, I am re-visiting this. I have been using a very similar routines very well and still using it. In a new project, I am using it.
Unlike the old project, I put a "Option Explicit" at the top of the module.
When I compile the datbase I get an error "!Variable Not...
No sorry, never heard of it. We are pretty limitted with software licensing of what can be put on the computers here. I just learned to live with the limitations of the Access report module (mouse screen magnifier options helps a lot on tiny label creation). I learned how to dynaically move...
Well, that thread is going back a bit. With Access 2010, I now output most reports directly to PDF format and then let the user choose where to print them.
That solved a huge problem with me designing the reports in Windows 7 with Windows 7 printer drivers on my computer and then Windows XP...
;)
Good gosh, you know the simplest things! I have spend litterally hours back and fourth between the sub-report and the main report trying everything imaginable.
I took your suggestion seriously, even though I thought "Yes, I have done that, how silly do you think I am ....." - LOL. Well...
More: run sub-report by iteself and print, it does not do that greying after first page. Removed back ground picture (gold border) - still does it.
Main report still does this effect when the subreport overflows first page.
P.S. - just decompiled and that did not help. Sometimes that fixes...
Yup, I know how to do the green bar lines (pretty cool actually and yes, I used to have that kind of paper in my wide dot matix printer all those years ago). Unfortunitely, thar us not what us happening here.
Dave
Created a sub-report (tried same thing using a sub-form on the report) on the main report. At the top of the main report is a graph. Directly below it is the data that supports the graph.
I am finding that if the sub-report had enough data to grow beyond Page 1 (of the main report), after the...
I have a simple access data table that maintains a environmental logger readings every five minutes. Two critical fields: ReadingDate & ReadingTime.
I want to be able to pull all the readings between two date and times, such as 10 June 2012, 10:00AM and 12 June 2012, 10:00 AM.
That sounded...
Wonderfull!! That worked great. Thank you so much! :)
I have designed reports that dynamically move fields up based on other fields not having data and then resizing the detail section. On the reports it works great but not on the forms. InsideHeight did not occure to me; wow, again thank...
I can't figure out why this doesn't work:
MyForm.Detail.Height = MyForm.Detail.Height - Int(0.75 * 1439.98848009216)
I have a start-up that if a data-logger is not detected, I move other various control a little higher as in:
Set MyForm = Forms!frmstartup
For Each CTL In...
The FlexGrid control does not work in reports.
Is there another control, or way way, to show, and format, a lot of columned data in a report without using a bunch of individual text boxes (uggh).
Thanks and happy holidays,
Dave
Thank you, I had tried that and got the same error with Access 2010.
The API Code, which I tried to upload and it looks like garbligoop, I see, worked great to copy any text to the Clipboard. Its a lot more work, but once that function is placed in a module somewhere, it works well.