Re: Draw lines, pset points, draw circles on a report

Tech-Archive recommends: Fix windows errors by optimizing your registry

Yes, I did experiment with the report I downloaded from Corp Tech, but it
does not come close to what I need. There is no text, or bitmap to print,
and the data is not printed... the data dicatates where a point is placed or
a line drawn.

I did try to open the I needed to read the survey, but I got a message that
I could not do that with the "On format" event. Maybe I had the wrong method
or syntax.
If I knew how to open the recordset to make the data visible to "On Format"
or "On Page", that should work.

I don't know what you mean about "binding" the data. But the data will
always changing as new surveys are loaded.

Hgeron

--
hgeron


"Duane Hookom" wrote:

Did you look at the reports in the Corp Tech Demo? It seemed to me that if
you have your values in data, you can "plot" them anywhere you want them on
the page. You have accuracy down to 1/1440 of an inch.

If you don't want to bind the data to your report as the record source, you
can use code to open recordsets and plot you points and draw your circles.
--
Duane Hookom
MS Access MVP

"hgeron" <hgeron@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:8937D188-1A66-4C29-B2D9-9016269976AB@xxxxxxxxxxxxxxxx
Thanks Duane, but this won't work.
See the data to be plotted will be a topographic survey of points and
lines.
The user will supply the surveys, and choose which (x,y) points make up
the lines. Some reports will be plan views, and some reports cross
sections.

It is important that these be accurately scaled (nn feet per inch).
I can do a xy scatter plot of the points, but the scale can't be
contolled.
And it does not have the linear features.

Using the MS access help, it showed how to draw a circle, to scale, pset
points, and draw lines at specific coordinates but it only worked on
reports
and then only in the "On Page" or "On format" events. The coordinates
were
all hard-coded into
the code of the report.

I have an example that works but I had to figure all the scaled points and
lines in a query, then paste them to the report code. If I rescale or
zoom
the plot, all the coordinates must be re-computed.

If I could just pass the points and lines to the "on format" event, they
could be processed from the survey table.

Would it help to see the single report and the code in it?

hgeron



--
hgeron


"Duane Hookom" wrote:

Why not bind your report to the data? You can use a single line of code
to
plot all the points in a single section like:

Me.MoveLayout = False

I believe I have code that does this in the Corp Tech Demos at
http://www.invisibleinc.com/divFiles.cfm?divDivID=4.
--
Duane Hookom
MS Access MVP

"hgeron" <hgeron@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:9089ED1C-78E9-4775-85FA-723DC74FD5FB@xxxxxxxxxxxxxxxx
I can set a scale and draw lines and points on a report by building "on
format" code. But how do I the the "on format" event to read the data
from a
table or query? It is easy to copy the points and paste them into the
code,
like this...

x = 3.285: y = 4.092: Me.PSet (x, y), lngColor
x = 3.279: y = 4.457: Me.PSet (x, y), lngColor
x = 3.569: y = 4.458: Me.PSet (x, y), lngColor

but I have thousands of points to compute and "pset"

How do I get the event "on format" to read my points?


--
hgeron






.

Relevant Pages

  • Re: Bug in Access 2002 Reports
    ... from within the Detail Section format event ... This will give the report a feeling of being "to scale", when you look at it you can see there are smaller, larger or equal intervals. ... Access will format the section but it will remember the last placement of the controls. ...
    (microsoft.public.access.reports)
  • Re: Emailing a Report
    ... "What do you suggest for making sure text on the report is not overlapping, missing, and or out of order? ... I always add icons to my toolbars to make it easier to format forms and reports... ... Align Right -- must have>1 control selected to be enabled ... on the report -- when it generates the reports, if a User_ID has 2 reminders, are they now both showing up on the report? ...
    (microsoft.public.access.modulesdaovba)
  • Re: Rowsource of unbound object
    ... That is because the Format function returns a string. ... This works in a query, not sure how it will work for your Gantt Chart ... The report events are Open, Close, Activate, Deactivate, No Data, ...
    (microsoft.public.access.modulesdaovba)
  • Re: Converting decimal time into hh:nn:ss time in ACCESS
    ... around this issue by changing the format from 'mmmm yyyy' (this is how ... decimal field and it gives me the entire month total for each employee. ... I create a report to bring in all of the ... reformat the decimal time to hh:nn:ss with no problem as long as it is ...
    (microsoft.public.access.formscoding)
  • Re: Problems with exporting controls with borders to .rtf
    ... > With a report, you can use subreports to represent the ... >>Report after it's exported you may want to try exporting ... >>"Microsoft Security Announcement: Have you installed the ... >>editable format such as .rtf, ...
    (microsoft.public.access.reports)