simple list contents of a recordsetclone 1

[brendanmc]

Hi,
I currently have another thread open in which I'm trying to correct a recordsetclone problem.

In the meantime, is there quick and easy routine that lists the contents of a recordsetclone, for example something that I can list in a msgbox?

Thanks
Brendan

 

[KenReay]

Hi

By contents, do you mean columns or data?

For columns, something like

Dim i as Integer
For i = 1 to Me.RecordsetClone.Fields.Count
debug.print Me.RecordsetClone.Fields(i).name
Next i

or

for data, something like

Dim i as Integer
Me.RecordsetClone.MoveFirst
Do until me.recordsetclone.EOF
For i = 1 To me.recordsetclone.fields.count
debug.print me.recordsetclone.fields(i).name & " -> " & me.recordsetclone.fields(i).value
next i

me.recordsetclone.movenext
Loop

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[brendanmc]

Thanks for the suggestion.

I'm still working theough the overall problem, but by adjusting your suggestion to use recordset instead of recordsetclone I was able to get more of an idea where I am at.