S
Sean
I have a switchboard that is linked to several premade
queries.
What I want is for a person to click on a command button,
the query will run, and then the individual can export the
results into dbase so it can be used to create a shapefile
in ArcGis.
The individual cannot have access to any part of the
access database with the exceptions of the switchboard and
the results from the queries that are run when you click
on the commond button of the switchboard.
My problem is when a person clicks on the command button
of the switchboard the parameter query comes up asking a
question (for example "what species are you looking for?"
the person enters the species name and the query runs
finding all the records for that species. but when the
person goes to export the data the window comes up ask you
what you want to call the exported data and how you want
to save the data but then when you hit the export button
you are required to rerun the parameter query.
Is their any way to have the parameter query run and then
be able to export the results into something besides
access without having to rerun the query.
queries.
What I want is for a person to click on a command button,
the query will run, and then the individual can export the
results into dbase so it can be used to create a shapefile
in ArcGis.
The individual cannot have access to any part of the
access database with the exceptions of the switchboard and
the results from the queries that are run when you click
on the commond button of the switchboard.
My problem is when a person clicks on the command button
of the switchboard the parameter query comes up asking a
question (for example "what species are you looking for?"
the person enters the species name and the query runs
finding all the records for that species. but when the
person goes to export the data the window comes up ask you
what you want to call the exported data and how you want
to save the data but then when you hit the export button
you are required to rerun the parameter query.
Is their any way to have the parameter query run and then
be able to export the results into something besides
access without having to rerun the query.