Hi All,
Not sure if this is possible? I would like a form that has a diagram of some plans on, this is the easy part lol
I would then like the user to be able to 'create a job' and on clicking this button some vba makes a new button (or basically a small red circle) that the user can move around the form so it can be placed over a certain position on the plan, this button then opens a 'Job' form when pressed?
Does that make any sense or is it even worth going down that road?
Basically I'd end up with some drawings/plans with a load of red dots on that when each one is clicked it opens up a job record. I've seen VBA to make a button and position it using Left, right, top, and bottom values but haven't come across anything that could do the above? Not sure if this is possible because the form effectively needs to be edited whilst still in form view.
Any ideas most welcome
Not sure if this is possible? I would like a form that has a diagram of some plans on, this is the easy part lol
I would then like the user to be able to 'create a job' and on clicking this button some vba makes a new button (or basically a small red circle) that the user can move around the form so it can be placed over a certain position on the plan, this button then opens a 'Job' form when pressed?
Does that make any sense or is it even worth going down that road?
Basically I'd end up with some drawings/plans with a load of red dots on that when each one is clicked it opens up a job record. I've seen VBA to make a button and position it using Left, right, top, and bottom values but haven't come across anything that could do the above? Not sure if this is possible because the form effectively needs to be edited whilst still in form view.
Any ideas most welcome