Recortsetclone

[Lindie]

When using Northwind and accessing the Telephonebook when clicking on
one of the alfa buttons I get the error message

the Object doesn't contain the automation object 'RecordSetClone'

the names are still selected but this box appears. I have never noticed
this before. What is this thing?
Lindie

 

[Ken Snell [MVP]]

RecordsetClone is a property of a form's Recordset that is a copy of the
form's recordset. Sounds as if you may have changed something in the form's
code that is now causing this error....you'll need to post some of the code
so that we can see what it might be.

 

[Lindie]

It is beginning to dawn on me, slooowly.

I have not changed a thing though. Just opened up the Northwind db
from the box so to speak. I wonder whether some files are missing from
the install??
When I remove the [RecordsetClone] part of
[RecordsetClone].[RecordCount]>0 this is in the Customer Phone
List:Macro
the error message does not show up. Another one does though.
So I have looked for the RecordsetClone but cannot find it. If this is
a property, well I cannot find it inProperties either.
Clearly I am not understanding much of this. Any further guidance
please?
Lindie


Lindie

 

[Ken Snell [MVP]]

Post all the code in which this error is occurring. I am not familiar with
Northwind, having not used it as examples for anything, and as such do not
know what code you're using from there.

 

[Lindie]

Thanks; what code do I send? the macro/VBA?

 

[Ken Snell [MVP]]

I assume that you're using VBA? Post whatever you're using.

 

[Lindie]

I believe it is not the code but some file on my PC. I have tried the
same on a PC not running XP Prof and there were no problems. Surely if
it were the code it would not have run on the other machine either?
Lindie

 

[Ken Snell [MVP]]

Could be that the Northwind form is corrupted. You can try reinstalling the
Northwind database or do a repair on ACCESS/Office.

 

[Lindie]

repaired/reinstalled but no luck.

 

[Ken Snell [MVP]]

I just checked my copy of Northwind's "Customer Phone List" macro (Office XP
Professional)... I don't see any use of RecordsetClone in any of the macro
steps.... this suggests that something was changed at some point in the
database you're using.

I don't know what you mean by trying the "code" on another PC without Office
XP... did you use the same database file (copied it to the other PC), or
were you using Northwind that was already on that PC?

Again, without knowing details about the macro's actions that are being run,
I cannot provide any suggestion about what might be going on, especially as
I don't see in my copy of Northwind what you're describing.

Can you post the exact steps that are in the macro in your Northwind?

 

[Lindie]

Thanks for your tenacity Ken. In the Macro there is reference to
RecordClone as follows: (straight from Northwind's Customer Phone List
Macros-design)

RecordsetClone].[RecordCount]>0 GoToControl If records
are returned for the selected letter, go to the SurName control.

[RecordsetClone].[RecordCount]=0 MsgBox

Simply running the database on a computer with an earlier than Office
2003 Access there are no problems. Despite trying hard to understand
this business about RecordsetClone I just don't grasp how it works-
sorry to be dense. The bit I just cannot grasp is the "Clone". What
clone where??

Lindie

 

[Ken Snell [MVP]]

Is what you posted exactly what is in the macro? If yes, there is a typo in
the first step; it should be this (note the [ character that I added to the
beginning of the info):

[RecordsetClone].[RecordCount]>0

If the [ is actually in the macro, then I am not sure why you're having this
problem. In my copy of Northwind, those two steps are
[CurrentRecord]>0
and
[CurrentRecord]=0

which is not how I would code the macro; I would be more likely to use
RecordsetClone.RecordCount, similar to what you have in your copy of
Northwind.

The RecordsetClone is a property of the form. A form has a Recordset, which
is the dataset that contains the data that are in the form's RecordSource.
The RecordsetClone is an exact copy of that Recordset; the form maintains
this extra copy so that you can use it for finding data and doing things
with the form as a result; and this doesn't make the form "move" to other
records until you want it to.

If adding the [ character doesn't fix the problem, try these two lines:

[Form].[RecordsetClone].[RecordCount] > 0
and
[Form].[RecordsetClone].[RecordCount] = 0

 

[Lindie]

Funny that! Sorry I did leave the "[" out.
Tried the [Form] but got error messages, changed it all to
[CurrentRecord]>0 and ...it works. I can sleep again, eat and be
happy.

Many thanks Ken.

L

 

[Lindie]

Just found out that the problem was one of security settings.
changing the Macro security setting to low soles all these problems.
I spent weeks re-writing my old code- pre access 2003- and it was
security all the time!
Tools - Macros - Security and change it to low. Apparantly, when the
security is set to medium or higher, there are some commands that will
not
run.
L