MS Access MSChart.Graph.8 does not print
Software: Microsoft Access 2007 SP2
Database File Version: Access 2000
I have an accessor program that I inherited from a previous employee. It uses forms for reporting, and since I don't have much experience with accessing, I continued to do so. I created a copy of the program for another project and modified it to fit.
I am having problems getting more than one graph to print. All charts are displayed as a form, they all have the same properties (except for data, position, etc.). For some reason, they don't print. They don't even show up in the print preview. In the meantime, there is no need to worry about it. ”
I think it must be something with the graphs themselves, as they sometimes lose all information. I need to open the graphs in edit mode and change the data source from column to row and back so that it redraws. (Refresh doesn't fix it)
So right now I don't even know where to look, so ideas are welcome.
Edit # 1
It seems that the problem is with an unrelated form.
Filtering subform fields: Unable to build a link between unrelated forms.
Main form request
SELECT tTest.ixTest, tMotorTypes.ixMotorType, tMotorTypes.asMotorType, tMotorTypes.fDeprecated, tTestType.asTest, tTest.asSerialNum, tTest.asOrderNum, tTest.asFrameNum, tTest.asRotorNum, tTest.asOperator, tTest.iStation, tTest.dtTestDate, tTest.ixTestType
FROM tMotorTypes
INNER JOIN (tTestType
INNER JOIN tTest ON tTestType.ixTestType=tTest.ixTestType)
ON tMotorTypes.ixMotorType=tTest.ixMotorType;
Request for a chart:
SELECT qGraphRSTTemperatures.Frequency, qGraphRSTTemperatures.[Drive End], qGraphRSTTemperatures.[Non Drive End], qGraphRSTTemperatures.[Air In], qGraphRSTTemperatures.Core
FROM qGraphRSTTemperatures
ORDER BY qGraphRSTTemperatures.ixTemperature;
QGraphRSTTemperatures request:
SELECT tElectricalData.dblFrequency AS Frequency, tTemperatures.dblDrvEnd AS [Drive End], tTemperatures.dblNonDrvEnd AS [Non Drive End], tTemperatures.dblAirIn AS [Air In], tTemperatures.dblCore AS Core, tSubTest.ixTest, tTemperatures.ixTemperature
FROM (tSubTest INNER JOIN tElectricalData ON tSubTest.ixSubTest = tElectricalData.ixSubTest)
LEFT JOIN tTemperatures ON tElectricalData.ixElectrical = tTemperatures.ixElectrical
WHERE (((tSubTest.ixSubTestType)=5))
ORDER BY tSubTest.ixTest, tTemperatures.ixTemperature;
So how, in the view form, it shows the graph with the correct data when linked like this:
Child field: ixTest
Master field: ixTest
but does not print the graph.
The graph will print if I remove the links, but then I have all the data from the chart request since it is not limited by ixTest.
edit # 2
Seems to be a print / render data issue when printing. Is there anything in print that changes the context of the entries regarding the parent / child relationship?
a source to share
My solution for solving the problem.
I have created separate reports with graphs / graphs in them. I just copied and pasted charts from forms into reports and they worked.
I didn't want to do this as he used several sheets of paper more than before. I am also unhappy with this solution as the question of why still remains.
a source to share
Enter a similar problem ... The graph reports worked fine until I had an invalid syntax problem with the report code I didn't find.
Obviously, the code for the report won't compile correctly, so it didn't bind correctly to charts and auxiliary reports, and I would get the same errors even if I manually put in the link fields.
My advice was to check the code in the form or report ... then compile the code and fix any problems. Hope this helps.
a source to share
I have a similar problem with the report. I created a graph that is in a group to give me a separate graph for each category (say sections). The graphs are all displayed in the report view (for each section) and in the preview, but when I print to PDF, only the first graph prints. If I open the report and go to Print Viewer and then print it in PDF, it works fine. If this is the problem you are having, this is my job:
I used VBA to follow the sequence to solve the problem. When a button is clicked on my main form, the following events occur (1) Open the report in print preview (hidden), (2) open the print dialog after generating the PDF report (3). p>
Dim stDocName As String stDocName = "My Reports Name"
(1) DoCmd.OpenReport stDocName, acViewPreview ,, acHidden
(2) DoCmd.RunCommand acCmdPrint
(3) DoCmd.Close acReport, "My Reports Name"
a source to share