Form Copy & Paste Bug

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I found a bug the hard way in Access 2000, where if you copy and paste a form, it gives you an error whenever you try to do anything. (Thanks to everyone here who gave me information on that, by the way! :)

Two questions.

1. It seems to only have affected the forms. I've upgraded to Access 2002 and started a new database. I imported all the tables, queries, and reports from the affected database, and the macros and forms from an unaffected older version of the database. Is it safe to do this, or can I expect problems again, since I imported files from the affected database? (The older version of the database is several hours behind in development, so I'm trying to do as little rework as possible and still meet my project due date on this.

2. Is this bug only in Access 2000? Am I safe with copying and pasting forms in 2002, or is there a chance of this happening again, even though I've upgraded

Thank you for your help
Avyn
 
You should never cut and paste forms from any version of Access. If you need
to get one form from one database into another always use the tool that is
designed to do this. File | Get External Data | Import. This is built-in to
all Access versions. Once you finish importing forms or other modules always
execute a compile on the database. To compile you need to open the VBA code
editor and select Debug | Compile. This will alert you to any coding
problems as well as missing references that need to be reset in the new
version.


Avyn said:
I found a bug the hard way in Access 2000, where if you copy and paste a
form, it gives you an error whenever you try to do anything. (Thanks to
everyone here who gave me information on that, by the way! :) )
Two questions..

1. It seems to only have affected the forms. I've upgraded to Access
2002 and started a new database. I imported all the tables, queries, and
reports from the affected database, and the macros and forms from an
unaffected older version of the database. Is it safe to do this, or can I
expect problems again, since I imported files from the affected database?
(The older version of the database is several hours behind in development,
so I'm trying to do as little rework as possible and still meet my project
due date on this.)
2. Is this bug only in Access 2000? Am I safe with copying and pasting
forms in 2002, or is there a chance of this happening again, even though
I've upgraded?
 
Avyn said:
I found a bug the hard way in Access 2000, where if you copy and
paste a form, it gives you an error whenever you try to do anything.
(Thanks to everyone here who gave me information on that, by the way!
:) )

Two questions..

1. It seems to only have affected the forms. I've upgraded to
Access 2002 and started a new database. I imported all the tables,
queries, and reports from the affected database, and the macros and
forms from an unaffected older version of the database. Is it safe
to do this, or can I expect problems again, since I imported files
from the affected database? (The older version of the database is
several hours behind in development, so I'm trying to do as little
rework as possible and still meet my project due date on this.)

2. Is this bug only in Access 2000? Am I safe with copying and
pasting forms in 2002, or is there a chance of this happening again,
even though I've upgraded?

Thank you for your help!
Avyn

I'm not sure which bug you're talking about. If it's the bug documented
in MSKB article 304548, then it only affected Access 2000 pre-SP3, under
the conditions described in the article. But I'm not sure that's the
bug you're referring to.
 
You did not tell us *what* error message you are seeing.

Without knowing that, my money would be on Name Autocorrect as the cause of
the problem.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Avyn said:
I found a bug the hard way in Access 2000, where if you copy and paste a
form, it gives you an error whenever you try to do anything. (Thanks to
everyone here who gave me information on that, by the way! :) )
Two questions..

1. It seems to only have affected the forms. I've upgraded to Access
2002 and started a new database. I imported all the tables, queries, and
reports from the affected database, and the macros and forms from an
unaffected older version of the database. Is it safe to do this, or can I
expect problems again, since I imported files from the affected database?
(The older version of the database is several hours behind in development,
so I'm trying to do as little rework as possible and still meet my project
due date on this.)
2. Is this bug only in Access 2000? Am I safe with copying and pasting
forms in 2002, or is there a chance of this happening again, even though
I've upgraded?
 
Back
Top