run-Time error 2501 when i'm trying to open a report

  • Thread starter Thread starter Marco
  • Start date Start date
M

Marco

Hi. I have a front-end and back-end system. I have one backend and serveral
front-ends.

All front ends are using access 2003 and windows xp with last updates.

In one computer I returning me the error "Run-Time Error 2501" this the last
code line in the following code:
"Dim strMapa As String

Select Case Me.Frame2
Case 1
strMapa = "12_rpt_Producoes_NotaProducao_PorNumero_qry"
Case 2
strMapa = "rpt_Producoes_RFT_datas_qry"
Case 3
strMapa = "rpt_Producoes_NotaProducao_PorDatas"
End Select

DoCmd.OpenReport strMapa, acPreview" <--- This one.

What is happening in this computer???

Regards,
Marco
 
Hard to tell from the infor provided. An error 2501 when a report is
involved means the report was canceled for some reason. This will always
happen when there is no data available for the report.

You may try opening the table or query that is the record source for the
report using any filtering imposed in your app to see if there is any data.
Also check to be sure there are no naming errors. Since it is happening only
on that computer, you may also want to check your VBA references on that
computer and on one where it works to be sure they are the same.
 
Hello,

All computers have the same copu of the front-end.

It was working perfectly only from yesterday start to crash. Besides that
all date from the back works ok.

Regards,
Marco
 
It may be a corruption problem. Copy a working copy of the front end to the
computer where it is not working and see if that makes any difference.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top