473,491 Members | 2,159 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

Problem Duplicating Forms in Access 2000

The following problem seems to manifest itself in Access 2000, but I
have not experienced it with Access 97.

When I make a duplicate of a form before I make design changes to that
form that I may want to reverse, it seems to screw up the code for the
whole database. This seems to be caused by some sort of conflict
between the code for the two identical forms.

Obviously, if one doesn't have a recent backup, they have a major
problem on their hands.

Has anyone experienced this behaviour, and is there a way around it?
Why does it seem to manifest itself in Access 2000 but not in Access
97?

Thanks in advance.
Nov 12 '05 #1
2 1328
I believe that I did this in Access 2000 without a problem. However, I
wonder if it is a side effect of the following article. If it is, I believe
that the vbe6.dll file mentioned in the article is updated in Office 2000
SP3.

http://support.microsoft.com/default...roduct=acc2000

--
Wayne Morgan
Microsoft Access MVP
"Wayne Aprato" <cq*******@volcanomail.com> wrote in message
news:4d**************************@posting.google.c om...
The following problem seems to manifest itself in Access 2000, but I
have not experienced it with Access 97.

When I make a duplicate of a form before I make design changes to that
form that I may want to reverse, it seems to screw up the code for the
whole database. This seems to be caused by some sort of conflict
between the code for the two identical forms.

Obviously, if one doesn't have a recent backup, they have a major
problem on their hands.

Has anyone experienced this behaviour, and is there a way around it?
Why does it seem to manifest itself in Access 2000 but not in Access
97?

Thanks in advance.

Nov 12 '05 #2
"Wayne Morgan" <co***************************@hotmail.com> wrote in message news:<o3*******************@newssvr32.news.prodigy .com>...
I believe that I did this in Access 2000 without a problem. However, I
wonder if it is a side effect of the following article. If it is, I believe
that the vbe6.dll file mentioned in the article is updated in Office 2000
SP3.

http://support.microsoft.com/default...roduct=acc2000

--
Wayne Morgan
Microsoft Access MVP
"Wayne Aprato" <cq*******@volcanomail.com> wrote in message
news:4d**************************@posting.google.c om...
The following problem seems to manifest itself in Access 2000, but I
have not experienced it with Access 97.

When I make a duplicate of a form before I make design changes to that
form that I may want to reverse, it seems to screw up the code for the
whole database. This seems to be caused by some sort of conflict
between the code for the two identical forms.

Obviously, if one doesn't have a recent backup, they have a major
problem on their hands.

Has anyone experienced this behaviour, and is there a way around it?
Why does it seem to manifest itself in Access 2000 but not in Access
97?

Thanks in advance.

Thanks very much Wayne. That was the problem. I think I'll just use
Access XP in future and use Access 2000 to compile the mde if I need
it in Access 2000 format.

Regards.
Nov 12 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
2125
by: dananrg | last post by:
I've created a small company database where the tables reside in a SQL Server database. I'm using Access 2000 forms for a front end. I've got a System DSN set-up to SQL Server and am using links...
1
2943
by: Sam Gledhill | last post by:
I hope somebody can help me, I have a problem executing this line of sql: Dim rstur As New Recordset Dim sql As String sql = "SELECT * FROM tblpat WHERE ='" & Me! & "'" Set rstur =...
2
9256
by: Chris Bolus | last post by:
I'm a teacher using MS Access on an RMConnect 2.4 network. On some workstations both I and my students sometimes get an error message when attempting to insert a command button on a form which...
0
2395
by: Sabine Oebbecke | last post by:
Hi Experts! I have several forms and reports where controls get their values with 'Forms!MainForm!Control' or 'Forms!MainForm!Subform!Control' resp 'Forms!MainForm!Subform.Form!Control' which...
0
1281
by: Chris | last post by:
I am trying to do a mail merge from Access 2000/2002 through VBA to a Word document. It all works fine on all Windows 2000 machines (regardless of if it is Office 2000 or 2002) but it doesn't work...
6
1661
by: gsb58 | last post by:
Hi! Recently we, in Norway changed to three different VAT levels. All three needs to be on the invoice program. This is easy obtained via a new field and set the rowsource to valuelist and make...
9
2469
by: Anthony Paul | last post by:
Hello everyone, There's an interesting SQL problem I've come across that I'm currently banging my head against. Given the following table that contains item location information populated every...
8
2040
by: zufie | last post by:
Hi, I created some forms using the "Create form using Wizard". However, I cannot view the forms I created with Wizard unless I click on the Design View icon. I checked the forms' properties...
15
3086
by: rleepac | last post by:
This is a little complicated but I'll do my best to explain. In my db I have a table called L_AgeCorrection which has the following fields: Age, Sex, Frequency, AgeValue This is a table used to...
0
7115
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
7190
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
1
6858
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
7360
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
5451
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
1
4881
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
3086
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
3076
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
633
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.