If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
run-Time error 2501 when i'm trying to open a report
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 |
#2
|
|||
|
|||
run-Time error 2501 when i'm trying to open a report
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. -- Dave Hargis, Microsoft Access MVP "Marco" wrote: 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 |
#3
|
|||
|
|||
run-Time error 2501 when i'm trying to open a report
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 "Klatuu" wrote: 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. -- Dave Hargis, Microsoft Access MVP "Marco" wrote: 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 |
#4
|
|||
|
|||
run-Time error 2501 when i'm trying to open a report
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. -- Dave Hargis, Microsoft Access MVP "Marco Silva" wrote: 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 "Klatuu" wrote: 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. -- Dave Hargis, Microsoft Access MVP "Marco" wrote: 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 |
#5
|
|||
|
|||
run-Time error 2501 when i'm trying to open a report
Nothing is wrong. In all computers works well. and this only start to crash
yesterday. "Klatuu" wrote: 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. -- Dave Hargis, Microsoft Access MVP "Marco" wrote: 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 |
#6
|
|||
|
|||
run-Time error 2501 when i'm trying to open a report
Something is wrong or it would be working.
Did you try any of my suggestions? -- Dave Hargis, Microsoft Access MVP "Marco" wrote: Nothing is wrong. In all computers works well. and this only start to crash yesterday. "Klatuu" wrote: 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. -- Dave Hargis, Microsoft Access MVP "Marco" wrote: 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 |
#7
|
|||
|
|||
run-Time error 2501 when i'm trying to open a report
Hello. I tried to replace the front-end. With no sucess.
"Klatuu" wrote: Something is wrong or it would be working. Did you try any of my suggestions? -- Dave Hargis, Microsoft Access MVP "Marco" wrote: Nothing is wrong. In all computers works well. and this only start to crash yesterday. "Klatuu" wrote: 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. -- Dave Hargis, Microsoft Access MVP "Marco" wrote: 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 |
#8
|
|||
|
|||
run-Time error 2501 when i'm trying to open a report
Go back to my first post and try the info there.
-- Dave Hargis, Microsoft Access MVP "Marco Silva" wrote: Hello. I tried to replace the front-end. With no sucess. "Klatuu" wrote: Something is wrong or it would be working. Did you try any of my suggestions? -- Dave Hargis, Microsoft Access MVP "Marco" wrote: Nothing is wrong. In all computers works well. and this only start to crash yesterday. "Klatuu" wrote: 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. -- Dave Hargis, Microsoft Access MVP "Marco" wrote: 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 |
Thread Tools | |
Display Modes | |
|
|