Results 1 to 4 of 4
  1. #1
    Rawb is offline Expert
    Windows XP Access 2000
    Join Date
    Dec 2009
    Location
    Somewhere
    Posts
    875

    Curved Lines

    I'm wondering if there is a way to draw curved lines in Access (on a Form OR a Report)?

    I'm working on a system that will allow the program to draw simple shapes based on a coordinate system and I don't want to have to use multiple, short straight lines to simulate curves if I don't have to!

  2. #2
    hertfordkc is offline 18 year novice
    Windows XP Access 2007
    Join Date
    Mar 2011
    Posts
    481
    Do you have to draw the shapes based on certain data in Access? If not, put the curves or other shapes on a background .jpg. If the data displayed on the form or report determines the shape, then I believe that you can draw the shape onto the background with a VBA event routine, but I haven't done it.

  3. #3
    Rawb is offline Expert
    Windows XP Access 2000
    Join Date
    Dec 2009
    Location
    Somewhere
    Posts
    875
    Unfortunately, I would have to be drawing the shapes in Access (in real time). Basically, I'd be pulling the coordinates from a Table in Access.

    Code:
    Shape_id|X_Coord|Y_Coord|Radius
    1|0|0|0
    1|10|0|0
    1|10|10|0
    1|0|10|0
    1|0|0|0
    For example, the above would draw a 10 by 10 "unit" square. For curved lines, I'd include a positive radius value (for convex curves) or a negative radius value (for concave curves). Straight lines would use a radius value of 0.

  4. #4
    Rawb is offline Expert
    Windows XP Access 2000
    Join Date
    Dec 2009
    Location
    Somewhere
    Posts
    875
    I've found a few VB examples that claim to do what I'm looking for, however they don't seem to be readily convertible into Access VBA.

    They all use the LineTo API and I haven't been able to figure out a way to get it to work in Access.

    Has anyone else worked with this at all? I'm still fairly new at using outside APIs.

    What I've found can be seen here (http://www.bigresource.com/Tracker/Track-vb-U60H68wCfK/).

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Lines duplicated with Queries
    By mari_hitz in forum Queries
    Replies: 3
    Last Post: 10-17-2011, 06:38 AM
  2. Eliminating null lines in report
    By brobb56 in forum Forms
    Replies: 2
    Last Post: 09-26-2011, 11:05 AM
  3. Eliminating null lines in report
    By brobb56 in forum Reports
    Replies: 1
    Last Post: 09-26-2011, 11:01 AM
  4. Lines turning Blue when printing
    By hawkins in forum Access
    Replies: 1
    Last Post: 09-02-2011, 07:28 AM
  5. Querying id by having criteria in two lines
    By ahunter488 in forum Queries
    Replies: 3
    Last Post: 06-21-2011, 05:21 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums