Export error "Subscript out of range" (1 Viewer)

D

DevKumar

New member

Local time

Today, 07:46

Joined

Mar 1, 2004

Messages

7

• Mar 1, 2004

• #1

Hello

I am trying to export a report to Excel but get the "Subscript out of range" error. I haven't been able to find a reason or solution for this error.There are similar posts in this forum, but none have any replies. Can anyone help, please?

I would appreciate it very much.

 

D

DevKumar

New member

Local time

Today, 07:46

Joined

Mar 1, 2004

Messages

7

• Mar 18, 2004

• #2

As there isn't much information available, I thought I would post what I have found out so far...

This is, apparantly, an acknowledged Microsoft Bug in Access, that existed until SR1. I believe it has been subsequently fixed but cannot confirm this as our software is restricted and we are running Access 2000 SR1.

 

Kodo

"The Shoe"

Local time

Today, 02:46

Joined

Jan 20, 2004

Messages

707

• Mar 18, 2004

• #3

subscript out of range is an array error message. It means the counter has gone beyond the bounds of the array.

Since you can't update your software, try putting
On Error Resume Next
before your export and see what happens.

 

D

DevKumar

New member

Local time

Today, 07:46

Joined

Mar 1, 2004

Messages

7

• Mar 19, 2004

• #4

Kodo,

Unfortunately, I am using the built in "Analyze it with MS Excel" button, so I can't add the error trap. If you have an alternative method for exporting to excel, I would appreciate it.

Thanks for your help.

Dev

 

D

dangermouse

Guest

• Mar 19, 2004

• #5

I had a similiar problem and sent the query to excel in portions to limits the maximum output and stop the crashes...

have you tried this?