Alternative to Double Click Action

[missymarie1014]

This is Access 2000. I have a little dilemma. I have created an onscreen calculator to do some basic division and multiplication which is called up as a modal form by double clicking anywhere in a form. After a calculation is performed I want to give the user the option to click a command button which will close the on screen calculator and copy and paste the value to a control in the form from which the calculator was originally brought up. The only thing is I don't want the pasting to be done automatically to the active control in the current form. In other words I am trying to eliminate the need for the user to move to the control he/she wants to edit before enabling the calculator. I want the user to be able to identify the control at the time of the pasting function. The dilemma is that the control in question is the only enabled, unlocked control in the form and I have already committed the DoubleClick event for this control to another procedure. I am wondering what other event or approach could be used to activate the paste portion of this procedure. What I am trying to accomplish is the user brings up the calculator, performs the calculation, clicks the command button to copy the calculated result which closes the calculator, and then the user moves to the specific control where he/she wants to paste the data and executes some action to paste the clipboard value. Also I don't really want to add a command button to the current form or require a Ctrl-V keyboard entry to accomplish the paste process. Thanks for any help.

 

[MajP]

Here is how I would do it. First forget the cut and paste, that is a poor design.

1) Pop open the calculator. If you hit cancel it closes the calculator, if you hit OK it hides the calculator
2) In your double click event check if the calculator is loaded but hidden. If the form is loaded then paste, else do your other procedure. Once you paste then close the hidden form.

 

[TheAceMan1]

How are ya missymarie1014 . . .

Have you ever walked up behind users of youe DB and noted what they do! ... Be careful! ... this can be mind blowing! ... I know people I would hire to just do what they do and cause an error! I'm actually trying to devise a scheme were I can cut them lose and make money!! Testing whatever I give them.

I don't know why your fighting the obivous (double-click the field where a calculation is required) but believe my years of experience, ... [blue]its more right for the users to double the field of interest and get their answer[/blue], ... then to have to do something else to get the value transfered!

In this secnario I have gone to the extent to give classes (many times) to apprise users of how to recognize and what they need to do ... and Why! Believe me! ... outside of what they think they know, users have to be taught what they don'know is available to them ... or what they should know ... are far as what this scenario can do for them!

You hava it! ... its already there! ... your users just haVe to be aquainted with it! ... yOu want A calculation in a specific spot ... then just double-click on it! ... [purple]Its logical, it makes sense, it fits, it falls right in place, and its the answer![/purple]

Let them double-click on the field where they need the answer and move On!

Special Note: ... [purple]we all have a tendency to over complicate the obvious![/purple] Don't let this be one of them!

[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[TheAceMan1]

BTW . . .

There's no greater info on what to do then going around and logging what users perfer! ... [blue]User input is a very powerful thing![/blue]

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]