Restrict query running

  • Thread starter Thread starter Rob
  • Start date Start date
R

Rob

Hi,

Is it possible to stop a query being run other than being run via a button
on a form. I have a query that only returns the correct result if certain
dates are entered via a form.

Thanks, Rob
 
You'd have to write code that would "stop" the attempt to run a query if all
data required by it are not entered. Your users shouldn't have access to the
queries directly anyway, so your form should be the only way they run that
query.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Determine what query to run based on a checkbox 0
Form to LoadingForm to run Queries for Report? 1
Major Advise Needed 1
Executing a hidden query 1
Enter date range in a form then run query 1
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Query prompts for StartDt and EndDt? 4
Run a query after selecting from combo box 3

Back
Top