Drag and Drop

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

rascal - 19 Apr 2008 13:05 GMT

I am building a database where I will be tracking meetings attended by our
employees. I have a list of about 75 people. I need to track the date,
type of meeting, who held the meeting, and the people who attended. I have 2
tables called employees, which contacts ID, and EmployeeName. The other
Table is called Meetings and it contains the following fields: ID, DateHeld,
ChairedBy, Type, and Attendees.
I am building a form to enter the information for the meetings, but was
wondering if it is possible to use the Drag and Drop method which I found on
the Microsoft Help and Support page Article ID 210334, to drag the names from
the employee list over to the attendees list, for each meeting.
If so, how would I do it, as the example they give is pretty basic, and
doesn't really cover what I am trying to do.
Thanks for any help or suggestions you can give.

Reply to this Message

Linq Adams - 19 Apr 2008 13:25 GMT

The Microsoft Help and Support page Article ID 210334 you cited is entitled:

HOW TO: Automatically Detect If a Form Is Being Edited in Access 2000

There's nothing in the article about drop and drag. Perhaps it would help if
you re-checked the article number, or even better, if you posted the code
here.

Signature

There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Reply to this Message

rascal - 19 Apr 2008 13:38 GMT

Sorry about that, I have been going through various Articles and put the
wrong 1 in. The Article is called "How to simulate drag-and-drop
capabilities in Access 2002
", Article ID 287642.

> The Microsoft Help and Support page Article ID 210334 you cited is entitled:
>
[quoted text clipped - 3 lines]
> you re-checked the article number, or even better, if you posted the code
> here.

Reply to this Message

Linq Adams - 19 Apr 2008 13:40 GMT

I have seen drop and drag routines around, but probably an easier method
would be to use two Listboxes, with the first holding your employee names and
the second starting out blank, with the Row Source Type of the second set to
Value List. Then simple code

Private Sub EmployeesListBox_AfterUpdate()
AttendeesListBox.AddItem (Me.EmployeesListBox)
End Sub

will move an employee name into the second list box. When you're done you can
loop thru the AttendeesListbox and write the data to wherever you need it.

Signature

There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Reply to this Message

rascal - 19 Apr 2008 19:06 GMT

Thank you, that works and is a lot simpler, however when I go to add a new
meeting the attendees from the previous meeting are still in the attendees
list for the new meeting, so I must have missed something, but can't figure
it out.

> I have seen drop and drag routines around, but probably an easier method
> would be to use two Listboxes, with the first holding your employee names and
[quoted text clipped - 7 lines]
> will move an employee name into the second list box. When you're done you can
> loop thru the AttendeesListbox and write the data to wherever you need it.

Reply to this Message

Linq Adams - 19 Apr 2008 21:00 GMT

I don't know how you're handing things after you have the employees names in
the attendees box, but you just reset it when you go to a different record.
Either

Private Sub Form_Current()
AttendeesListBox.RowSource = ""
End Sub

Or, if you only want to reset it for a new record

Private Sub Form_Current()
If Me.NewRecord then
AttendeesListBox.RowSource = ""
End If
End Sub

Signature

There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Reply to this Message