PDA

Click to See Complete Forum and Search --> : Error 2501


Tesita
Jun 15th, 2003, 08:15 AM
I have an MDE access application created using Access 2000. I installed office 2000 on a machine running Windows 98 and put the application on there. When I try to open my reports I am getting an error 2501 on the OpenReport method of the DoCmd object in my code. This error is supposed to be generated when there is no data as far as I know. There is data in my database but for some reason the error is being generated.
Also, it doesn't appear that the nodata event is being accessed in the report at all so it definitely is not a case of No data in the report. I am able to look at the report in design view but not to preview it.

Any suggestions Anyone?

Bazzlad
Jul 3rd, 2003, 07:14 AM
long shot, but I got that error when using the line

.text

I found that using

.value

stopped it....
I think that was it, or that was error 3330 .

It was an error somewhere...
:S
hope that helps....

Bazzlad
Jul 3rd, 2003, 07:15 AM
No it was

Runtime error 2110 - Microsoft Access can't move the focus to the control txtTotal.

Runtime error 2185 - You can't reference a property or method for a control unless the control has the focus.

\Sorry!

Bazzlad
Jul 3rd, 2003, 07:16 AM
Post your code and details, I'll have a look