mikecollett
Technical User
hello all!
i have three wierd happenings that may or may not be related. (each in a different db)
1 - setup:
form to enter reporting criteria and button to print report (and preview).
query makes table for report based on above criteria.
report consisting of 8 graphs selecting different columns from table. (all select date, and one other eg production volume).
all basic and works well but...
sometimes, randomly, one or more of the graphs will be missing. repeated clicks on preview will show/hide different graphs. the graph object is there when you click on design view and the data is there in the table, but cannot be seen on screen and is missing when printed. if i click on the preview button (and then close print preview of course)on the form repeatidly, either all of the graphs will dissappear or reappear. weird man!
2 - setup
form with critera and report preview button.
query based on one data table and form criteria to pull info together.
one graph (bar graph looking like a pareto)on a report based on this query.
sometimes, randomly, the results vary when going into and out of report preview, both the categoreies and order - both important in a pareto of highest costs!! The graph is always visible though.
3 - setup
a form with many subforms and stuff pulling together about 6 seperate databases.
queries galore pulling together graphs, files, comments, names, dates, numbers etc etc - a real mixed bag.
a button on the form to print out the info - report has a graph based on a sub table shown on the form (data in the queries is always correct).
randomly again, a print out of record 1 will be fine. printout of record 2 will be fine. print out of reord three will have record 1's graph. look at record 2 again - has record 1's graph. look at record 2 again - everything ok. really weird man!
in all cases, the data as shown in queries and made tables is perfect - it seems to be a problem with the report views maybe.
i have tried printing without preview, but the same thing happens.
btw i am using xp and access 2k
cheers
one completely confused mike
i have three wierd happenings that may or may not be related. (each in a different db)
1 - setup:
form to enter reporting criteria and button to print report (and preview).
query makes table for report based on above criteria.
report consisting of 8 graphs selecting different columns from table. (all select date, and one other eg production volume).
all basic and works well but...
sometimes, randomly, one or more of the graphs will be missing. repeated clicks on preview will show/hide different graphs. the graph object is there when you click on design view and the data is there in the table, but cannot be seen on screen and is missing when printed. if i click on the preview button (and then close print preview of course)on the form repeatidly, either all of the graphs will dissappear or reappear. weird man!
2 - setup
form with critera and report preview button.
query based on one data table and form criteria to pull info together.
one graph (bar graph looking like a pareto)on a report based on this query.
sometimes, randomly, the results vary when going into and out of report preview, both the categoreies and order - both important in a pareto of highest costs!! The graph is always visible though.
3 - setup
a form with many subforms and stuff pulling together about 6 seperate databases.
queries galore pulling together graphs, files, comments, names, dates, numbers etc etc - a real mixed bag.
a button on the form to print out the info - report has a graph based on a sub table shown on the form (data in the queries is always correct).
randomly again, a print out of record 1 will be fine. printout of record 2 will be fine. print out of reord three will have record 1's graph. look at record 2 again - has record 1's graph. look at record 2 again - everything ok. really weird man!
in all cases, the data as shown in queries and made tables is perfect - it seems to be a problem with the report views maybe.
i have tried printing without preview, but the same thing happens.
btw i am using xp and access 2k
cheers
one completely confused mike