Wei,
Again you have not included any part of the previous messages making it difficult for people to support you. It has already caused some confusion. Please don't post on an existing thread without including significant content from earlier messages.
Duane
From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of Wei Qian via groups.io <wei_qian2001=yahoo.com@groups.io>
Sent: Sunday, July 19, 2020 11:42 AM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: Re: [MSAccessProfessionals] Access report, need to pass parameters to SQL Server back end
Sent: Sunday, July 19, 2020 11:42 AM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: Re: [MSAccessProfessionals] Access report, need to pass parameters to SQL Server back end
Arnelito,
Thanks so much for trying to help me out. Sorry I was out earlier and I couldn't see the whole messages from my phone so I didn't reply. The problem I have is my back end database is converted from Access to SQL Server and my front end is still using Access for data entry and reporting. Some reports run very slow when Access tries to run through all records and filter later. So I was trying to use the pass through query to only get only the intended records. Duane's function works fine, I can change the query according to the parameters selected and it reports run much faster. But I got the error of 'can't process opening reports' though sometimes it did run the report after I stopped the debugger. You are saying I can put the code in report open event. But the report open event has the macro of opening the form for parameter selection which is necessary before running the report. Should I still put the code in the OK click button on the form? I guess I can clone the selection form for each report though it sounds stupid. I'm not dealing with sub report, I only try to run the main report. Thanks very much!
Thanks so much for trying to help me out. Sorry I was out earlier and I couldn't see the whole messages from my phone so I didn't reply. The problem I have is my back end database is converted from Access to SQL Server and my front end is still using Access for data entry and reporting. Some reports run very slow when Access tries to run through all records and filter later. So I was trying to use the pass through query to only get only the intended records. Duane's function works fine, I can change the query according to the parameters selected and it reports run much faster. But I got the error of 'can't process opening reports' though sometimes it did run the report after I stopped the debugger. You are saying I can put the code in report open event. But the report open event has the macro of opening the form for parameter selection which is necessary before running the report. Should I still put the code in the OK click button on the form? I guess I can clone the selection form for each report though it sounds stupid. I'm not dealing with sub report, I only try to run the main report. Thanks very much!
Tidak ada komentar:
Posting Komentar