Go Back   Access World Forums > Microsoft Access Discussion > Modules & VBA

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 11-10-2019, 06:02 PM   #1
craigachan
Newly Registered User
 
Join Date: Nov 2007
Posts: 253
Thanks: 9
Thanked 0 Times in 0 Posts
craigachan is on a distinguished road
Drag and Drop in Schedule Form

I have a form that I use for my schedule that has 4 columns and enough rows for 8am to 5 pm in 10min increments. Each time slot = 1 textbox on the form. And appointment might take up many timeslots. Each textbox has a invisible associated textbox that holds appt and control data to control clicks to that textbox.

Right now when I click on an appointment, it opens a dialog box that shows the details of that appointment and the info that goes along with that appointment. I can then move that appointment on my schedule by reassigning that appointment to the new parameters (Time and column).

What I want to do is to be able to click on a textbox and use some kind of drag and drop function to move an appointment to another timeslot. Does anyone know of any sample or other posting that might help me out?

Thanks for any help.

craigachan is offline   Reply With Quote
Old 11-10-2019, 06:10 PM   #2
June7
AWF VIP
 
June7's Avatar
 
Join Date: Mar 2014
Location: The Great Land
Posts: 2,403
Thanks: 0
Thanked 559 Times in 555 Posts
June7 will become famous soon enough June7 will become famous soon enough
Re: Drag and Drop in Schedule Form

This topic has been discussed in numerous threads. Have you searched? There is no true drag and drop for data. Code would create a new record and delete the old.

To get an idea of what might be involved, review https://vb123.com/drag-and-drop-in-access/
__________________
Attach File Manager is below Advanced editor window, click Go Advanced below Quick Reply window. To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
DEBUG! DEBUG! DEBUG!
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
June7 is offline   Reply With Quote
Old 11-10-2019, 06:13 PM   #3
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 5,721
Thanks: 57
Thanked 1,260 Times in 1,241 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: Drag and Drop in Schedule Form

Hi. There are a few demos for drag and drop, but I'm not sure they do what you're asking. One demo allows you to drag say a file to a form or another allows you to reposition a control on a form. If I understand it correctly, you want to rearrange the time slots when you drag an appointment around, is that correct?

__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is online now   Reply With Quote
Old 11-10-2019, 06:14 PM   #4
nhorton79
Newly Registered User
 
Join Date: Aug 2015
Posts: 108
Thanks: 12
Thanked 13 Times in 13 Posts
nhorton79 is on a distinguished road
Re: Drag and Drop in Schedule Form

I haven't personally done this, but I checked out the Similar Threads section below and saw this post:
https://www.access-programmers.co.uk...d.php?t=298195

Which had a link to this post:
https://www.access-programmers.co.uk...d.php?t=228040

Supposedly, there is a example database (A restaurant floorplan) in there that allows you to drag boxes around on a floorplan, this may be able to be adapted to do what you want.
nhorton79 is offline   Reply With Quote
Old 11-10-2019, 08:34 PM   #5
craigachan
Newly Registered User
 
Join Date: Nov 2007
Posts: 253
Thanks: 9
Thanked 0 Times in 0 Posts
craigachan is on a distinguished road
Re: Drag and Drop in Schedule Form

Thanks for all of your suggestions. I'm going to test the ideas out. I've always lacked in using the mouse events, but I guess there is no better time than now. Wish me luck.

Thanks again.
craigachan is offline   Reply With Quote
Old 11-10-2019, 09:18 PM   #6
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 5,721
Thanks: 57
Thanked 1,260 Times in 1,241 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: Drag and Drop in Schedule Form

Good luck! Let us know how it goes.
__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is online now   Reply With Quote
Old 11-10-2019, 09:44 PM   #7
nhorton79
Newly Registered User
 
Join Date: Aug 2015
Posts: 108
Thanks: 12
Thanked 13 Times in 13 Posts
nhorton79 is on a distinguished road
Re: Drag and Drop in Schedule Form

All the best! Hopefully something there can assist. Keep us in the loop with how it works out.


Sent from my iPhone using Tapatalk


nhorton79 is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
drag and drop within access form rwahdan General 1 02-07-2018 12:35 AM
Drag & Drop Images in a form john_gringo General 0 01-20-2013 10:01 AM
Drag-and-Drop fills in the Form kevin_Carr Forms 2 09-27-2012 04:53 AM
Drag and Drop without Form code. ChrisO Sample Databases 0 01-30-2012 09:28 PM
Drag & Drop on Form matthewnsarah07 Forms 1 05-12-2009 09:13 AM




All times are GMT -8. The time now is 08:04 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World