[AccessD] Access 2003 can't cut and paste a control

Darryl Collins darryl at whittleconsulting.com.au
Tue Aug 14 19:49:49 CDT 2012


Hi John

I have seen this behaviour when you try to paste a control whose name already exists on the target form with a different control.  Access is meant to handle that, but in my experience it often doesn't handle it at all and leads to form corruption and crashing.  It seems to behave better if you are using the default control names provided by Access, but if you are usign custom names it is rather flakey at best.

These days I take a long winded route. Copy the control to a dummy form, rename it there and then repaste it back onto the original form to avoid any name duplicates.

A bit of a pain and an extra step, but far less of a pain (and many less steps) then having the whole form go 'splat' as was often the case.

May or may not be relevant to you situation, but it seemed like it could be a contender...

cheers
Darryl.


_______________________________________
From: accessd-bounces at databaseadvisors.com [accessd-bounces at databaseadvisors.com] on behalf of jwcolby [jwcolby at colbyconsulting.com]
Sent: Wednesday, 15 August 2012 4:37 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] Access 2003 can't cut and paste a control

My laptop is running Windows 7 (latest updates) and Office 2003 SP3.  I have a form which contains
controls which I want to cut and paste to another form.  Just works right?

No, it doesn't.  I was able to cut and paste one specific combo box, two text boxes and 2 command
boxes copied just fine.  A second combo refuses to copy.  It alternates between page faulting
(Access has quite working) and appearing that it copies (spinning wheel for a while then returning
but not actually copying the combo).  In no event does it actually copy that specific combo.

I made an empty access container, copied the source and destination forms into that, and tried the
copy of these controls in that new container.  Same thing.  Everything copies except that one combo.

If I try to copy any other control right into the same form it works, that control even into the
same form, does not copy.

I so love Access.

--
John W. Colby
Colby Consulting

Reality is what refuses to go away
when you do not believe in it

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com





More information about the AccessD mailing list