morinia
asked on
using table in access for prompts - Access 2010
Experts,
I am running a job in Microsoft Access that currently prompts for values.
Ex, start date
end date
perecentage
Is there a way to put these parms in a table so they don't have to be typed in each time.
In addition there are three queries that run that the parms must be typed in. If a manual method is used, is there a way to run all three queries so the parms only have to be entered one time and not for each query.
I am running a job in Microsoft Access that currently prompts for values.
Ex, start date
end date
perecentage
Is there a way to put these parms in a table so they don't have to be typed in each time.
In addition there are three queries that run that the parms must be typed in. If a manual method is used, is there a way to run all three queries so the parms only have to be entered one time and not for each query.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.