Hi, everybody
I have 4 long queries ( really very long!
) and I need them to be run. They promt the user for parameter information, almost the same information. I'd like the 4 queries to be able to run, so that the user is not required to inter the parameter information twise or more.
1. I don't know what is the best to use for a better performance, the VBA DoCmd or the Macro, the OpenQuery or the RunSQL?
2. In addition, in case of long SQL statement, how could I use these options?
3. For the parameters, is it possible to pick up the activated record form a list of records in a form?
Your help is appreciated
I have 4 long queries ( really very long!
) and I need them to be run. They promt the user for parameter information, almost the same information. I'd like the 4 queries to be able to run, so that the user is not required to inter the parameter information twise or more.1. I don't know what is the best to use for a better performance, the VBA DoCmd or the Macro, the OpenQuery or the RunSQL?
2. In addition, in case of long SQL statement, how could I use these options?
3. For the parameters, is it possible to pick up the activated record form a list of records in a form?
Your help is appreciated
