Good Afternoon,

Does anyone know how to run an Update Query from a Switchboard? 

This is essential as I do not want the users of the database to be in the 
query list section of the database.

Hi Aaron!

At least two options here! If you use the Switchboard Wizard two of the
offered options for new actions are "Run Code" and "Run Macro".

If you create your Update Query in the normal way you could write a macro to
run it. If you call up this macro from the switchboard - Bob's Your Uncle!

HTH - Spike

> -----Original Message-----
> From: Aaron Dennis [mailto:aarondennis@s...]
> Sent: Thursday, March 28, 2002 1:33 PM
> To: Access
> Subject: [access] Running An Update Query From Switchboard
> 
> 
> Good Afternoon,
> 
> Does anyone know how to run an Update Query from a Switchboard? 
> 
> This is essential as I do not want the users of the database 
> to be in the 
> query list section of the database.

On Thu, 28 Mar 2002 13:32:59 "Aaron Dennis" wrote:

...
> Does anyone know how to run an Update Query from a Switchboard? 

Make a macro that opens the query, probably you will 
want to shut off messages too. Use "run Macro" in the 
switchboard.

Paul