Recent content by Daveyk01

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

Well, "duh" on me <g>. I could not see the trees for the forest. Thanks!

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

Gosh, here it is October 2012 and I am experiencing the same issue with Access 2010. I didn't see a resolution to this. I will keep searching. Dave

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