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!
_._,_._,_
Groups.io Links:
You receive all messages sent to this group.
View/Reply Online (#115715) | Reply To Group | Reply To Sender | Mute This Topic | New Topic
Your Subscription | Contact Group Owner | Unsubscribe [sugeng.panjalu.access@blogger.com]
_._,_._,_
Tidak ada komentar:
Posting Komentar