Re: To Mike D Sutton...need help..again

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

Now that I have the graphical part arranged (thanks to Mike) I need to
load some stuff
on my page from a recordset.
I have been trying to get things in a function but I can't seem to get
my fingers behind it.
It is rather complex with six entities and so many linked tables.
<snip>
The related links will be shown with a Box and a Rope connecting them
with the entity.
So I have to do the above for all the other related entities.
The problem is that I first need the total of related records so I can
define the:
CircPts, otherwise I can do the math thing to make a need circle.

Sounds complicated, and it is I think.

As far as I can see you answered your own question - Get a list of all the entities you wish to draw before plotting
their positions, I'm not sure what else you want me to suggest?
Presumably each entity has an icon and a name associated with it, so iterate all your associations and create either
collection of simple objects or even an array of UDTs holding this data, then once this process is complete you have the
full count and can plot+draw based on those.
Hope this helps,

Mike


- Microsoft Visual Basic MVP -
E-Mail: EDais@xxxxxxxx
WWW: Http://EDais.mvps.org/


.

Relevant Pages

  • Re: search valors in access table
    ... The following code can be used to load either a listbox or a combobox ... ' Set the number of Columns = number of Fields in recordset ... Then you use the .BoundColumn property of the Combobox to specify the column that contains the required data. ...
    (microsoft.public.word.vba.userforms)
  • RE: Datarepeater and Radiobuttons
    ... into a RecordSet each and when the user clicks the first option, ... load it's contents however you wish. ... I don't recommend that way because you would load the Queries into ... Once you knwo which query via the button ...
    (microsoft.public.vb.database)
  • Re: Poor perfomance with Spreadsheet OWC 10 with more than 200 columns
    ... then i load into the spreadsheet using XMLLOAD. ... HTML portion is what is slowing it down. ... > OWC Version: 10.0.0.2621 ... >>> to design the html table, reading from a Recordset. ...
    (microsoft.public.office.developer.web.components)
  • Re: VB application crashes
    ... When I load the form in Private Sub Form_ActivateI have the ... These are functions that load data into Listviews, ... Set rsjob = dbfASIC.OpenRecordset ... I used to use the same Public recordset rs all the time but I changed ...
    (microsoft.public.vb.general.discussion)
  • Re: Drop Down getting values from Excel
    ... ' Set the number of Columns = number of Fields in recordset ... ' Load the SchoolField with the retrieved records ... Load a ListBox from a Named Range in Excel using DAO ... We want to establish a spreadsheet that has ...
    (microsoft.public.word.vba.general)