Paste Append not working

[martinshort]

Hi



I've recently been forced to migrate to Access 2007 (much prefer 2003 unlike Excel and Word!)

I've got a problem with locking down a database and creating a custom toolbar to Paste Append records. The aim is that the user should be able to manually select and copy records from one table to another via the clipboard. When I add Paste Append it is disabled. When I use Paste, it creates a brand new table and pastes all the records in there rather than the one selected. (Also the user isn't even allowed to see the new table as I have intentionally hidden all extraneous windows and functionality). So...at present, I've had to leave the users with instructions to use Ctrl-C and Ctrl-V and remove all ribbons and toolbars, which is less than ideal for many users. I want my cut, copy, paste and paste append!

Any ideas what I'm doing wrong?

Thanks

Martin

[NoellaG]

Hi,

from Access 2007 you have the ribbon in stead of the old tool bars. You could check the following link to see how to customize the ribbon:

http://msdn.microsoft.com/en-us/libr...elopers_Access

[martinshort]

Thanks for the reply, and whilst the link is very much appreciated, I'm not sure that this is going to solve my problem. It's the actual paste functionality that is misfiring and when I enable the standard ribbons the same unhelpful behaviour is replicated.

Martin

[adelang]

Hi Martin
How are you telling your database to perform this, please? I'm having a similar probkem, but not pasting at-all
I have a simple two-field table in a subform. A button on the main form does the following..

strKey = "%" & "(HVN)"
me.frmsInput1!itemno.setfocus (frmsInput1 is the Subform)
SendKeys strKeys

where %HVN is [Alt],Home-Paste-Append for the ribbon

I've trie different combinations of brackets and spaves, but can't get it to paste append via code.. but actually pressing [Alt] then H V and N in sequence works very well :-(

Any input appreciated,
Cheers, Ade