Drag a text box in a form

[Jael]

Is it possible to click & drag a text box in an open form?

Would I do it by sync'ing its position with the mouse position?

I have an event comming up that has 60 tables with 10 seats at a table. I
have a form that mimics the table layout. When a table is clicked, a listbox
displays the names of the people seated at the table. I'd like to be able to
graphically move names from table to table. What I think would work is when
a name is selected in the list box, it's regenerated in a text box. I can
assign a new table number and refresh the data, but I'd like to just drag the
box to the table and the underlying s/w would update the table number.
Doable?

Thanks,
Jael

 

[Scott McDaniel]

Is it possible to click & drag a text box in an open form?

Would I do it by sync'ing its position with the mouse position?

I have an event comming up that has 60 tables with 10 seats at a table. I
have a form that mimics the table layout. When a table is clicked, a listbox
displays the names of the people seated at the table. I'd like to be able to
graphically move names from table to table. What I think would work is when
a name is selected in the list box, it's regenerated in a text box. I can
assign a new table number and refresh the data, but I'd like to just drag the
box to the table and the underlying s/w would update the table number.
Doable?

Access doesn't really do Drag and Drop, but Peter's Software has a neat DND utility:

www.peterssoftware.com

It's not free but it's pretty cheap and works fairly well.

Thanks,
Jael

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com

 

[Mike Painter]

Is it possible to click & drag a text box in an open form?

Would I do it by sync'ing its position with the mouse position?

I have an event comming up that has 60 tables with 10 seats at a
table. I have a form that mimics the table layout. When a table is
clicked, a listbox displays the names of the people seated at the
table. I'd like to be able to graphically move names from table to
table. What I think would work is when a name is selected in the
list box, it's regenerated in a text box. I can assign a new table
number and refresh the data, but I'd like to just drag the box to the
table and the underlying s/w would update the table number. Doable?

Thanks,
Jael

It's doable with the contents of the box but no pretty.
Got focus and mousedown can pick a seat at a table and save that value in
one variable.
If there is something in that variable and gotfocus reports a "legal"
destination, then you can save the current contents of that location,
replace it with the new one on mouse up and erase the original.

If you do this a lot and have the time it is an interesting programming
problem. Buying the routine would be a quicker solution.

If this is a one time thing I would invest in large pieces of paper for a
layout of the tables and post-it notes for the people. They have post it
cards now that don't stick to themselves so you can shuffle them around.

 

[Jael]

Mike, Thanks for the response. I have a large paper version with post-its.
My laptop is easier to move around to various meetings so I was hoping. This
is an annual event for the last 17 years and my involvement is the last 3
years. I'll look into purchasing a solution as Scott McDaniel suggested

Jeff

 

[Jael]

Thanks Scott. Was hoping for a "simple" soln. I'll look at "Peter's"
solution.
Jeff

 

[Mike Painter]

http://www.perfecttableplan.com/ seems to be a cheap solution
1. Use for any number of events from a small wedding reception to a 2000+
seat banquet.

2. Easier and faster than scraps of paper or Excel

3. Assign seats automatically or by drag and drop.

4. Manage guest details, RSVPs, meal choices and preferences.

5. Experiment with table shapes and sizes.

6. Print elegant floor plans, seating charts, place/escort cards and other
stationery.

7. Handle inevitable last minute changes without stress.

8. Work offline. No Internet connection required.

9. Flexible licensing. Install on more than one PC/Mac.

10. Free support by email.

11. Inexpensive. Probably less than the cost of feeding a single guest.

12. No risk. Try before you buy + 14 day money-back guarantee.

 

[Jael]

Neat & cheap! If I do this again next year, that may be the way to go!

Thanks,
Jeff