How to create a right-click "add then paste" menu item instead of just paste

  • Thread starter Thread starter Zen Tobi
  • Start date Start date
Z

Zen Tobi

Dear Access developers,

I have a lot of cut and pasting to do from Excel to an Access form.
But instead of just pasting, I want to "add then paste" the value.
Does anybody have a way to do this? Existing code would be
appreciated!

In other words, I'd like to right click on a form text box and add the
value stored in the clipboard to the existing value which is in the
text box.

As an example, say I have a current value of 12.2 in the text box. In
Excel, I have a value of 2.5. I'll copy the value in Excel (2.5) to
the clipboard, and then I want the "right click menu item" to add it to
the 12.2 and paste 14.7 in the text box.

The "right click menu item" could be added in Windows or strictly for
Access or a specific database, whichever is easiest. If you have some
exisiting code, please post it!

This contextual right-click menu item could be called "Add then paste".

Thanks for you help!
 
What's the bigger picture? What are you trying to do on a conceptual
level? What SPECIFIC information is in Excel that needs to get into
Access? My inital thought is that you could create a solution that
imports the values into a field assoctated with the related record in
Access and then use an update query to add the value. Such a solution
would GREATLY streamline the process.

David H
 
Back
Top