G
gr
Hi, I have a nested query which takes about 30 seconds in
load. But a soon as it is opened using a requering it
takes 3 secs. This query recieves 3 parameters from a form
something like Criteria: [Forms]![frmNames].[Form]![MyName]
I have tried many ways to improve the performance but
nothing seemed to help. Now what I'm trying to do is to
open the form (which record source is the query) as Hidden
when loading the application Splash form. the problem is
that the query prompts the user for the parameters. is
there a way that I can send an empty string for the
parameters so that the users don't see the prompting
window?? doing this the query and form will be opened and
so I will only need to make it visible and requery when
necessary (which takes 3secs.)
How can send or trick access to think he recieved the
parameters and not prompting the user??
thx.
load. But a soon as it is opened using a requering it
takes 3 secs. This query recieves 3 parameters from a form
something like Criteria: [Forms]![frmNames].[Form]![MyName]
I have tried many ways to improve the performance but
nothing seemed to help. Now what I'm trying to do is to
open the form (which record source is the query) as Hidden
when loading the application Splash form. the problem is
that the query prompts the user for the parameters. is
there a way that I can send an empty string for the
parameters so that the users don't see the prompting
window?? doing this the query and form will be opened and
so I will only need to make it visible and requery when
necessary (which takes 3secs.)
How can send or trick access to think he recieved the
parameters and not prompting the user??
thx.