Special Control Needed

[BruceS]

Hi, all!

I'm trying to develop a form for Access 2003 that will allow the user to
"connect" unreleated items in two different lists. I'd like to show
connecting lines between the items in the two lists as they are "joined" by
the user. What I envision is something similar to the upper window of the
Query design view or in the Relationship window, where you drag between two
tables to relate the fields.

I've done this in the past with two list boxes (You select one item on each
side and click a button to join the items.), but it doesn't have the lines
showing which items are already connected.

Has anyone ever seen a control like this with the lines? I think it would
be a nice improvement for the app.

Thanks,
Bruce

 

[David H]

Trying Googling 'Access ActiveX Controls' and variants. While there might be
something like that out there, I wouldn't get my hopes up.

 

[[MVP]]

Hi, all!

I'm trying to develop a form for Access 2003 that will allow the user to
"connect" unreleated items in two different lists.  I'd like to show
connecting lines between the items in the two lists as they are "joined" by
the user.  What I envision is something similar to the upper window of the
Query design view or in the Relationship window, where you drag between two
tables to relate the fields.

I've done this in the past with two list boxes (You select one item on each
side and click a button to join the items.), but it doesn't have the lines
showing which items are already connected.

Has anyone ever seen a control like this with the lines?  I think it would
be a nice improvement for the app.

Thanks,
Bruce

Hi,

What have I done in the past is import form for Excel/Access where
user connect database fields with import file fields. Here is a screen
capture:

http://www.praktikum.rs/mihaljev/images/sms.ht11.jpg

This is possible to do, but behind is a huge code and is adopted for
this particular database (blame me). This is just to give you an idea
how you can do it, as it easier to read field names from the list
bellow when code actually import data. It just loops, read database
field name and import file field name and build append record. That
may give you an idea.

Regards,
Branislav Mihaljev
Microsoft Access MVP