Action queries that can be run by casual users

[annemu]

Hi all,
I wanted to run a make-table query that can be run by users on a regular basis (at end of month) that will allow users to enter the name of the query themselves (i.e. month name). How can I do this from a user interface, without giving them access to the tables and queries?
Any help gratefully accepted.
I am a very basic user of VB.
Cheers,
Anne

 

[namliam]

You cannot do this in a 'default' query, only if you have dynamic code that can do this.

Buy WHY for heavens sake would you want to have month tables?? Why not simply use queries?? Much prefered to not store random tables more so if they would be there for the user to (ab)use

 

[Galaxiom]

Making a table is not about producing something resembling a report on a grid paper. It should not be thought about even as a spreadsheet even though a table looks like one. Tables store data and often appear relatively incoherant because rather than being designed for viewing they are configured for easy access to information. The data for a query can be spread out over several tables.

Your new monthly report data should be as records appended to groups of tables designed to hold any number of future reports. You create queries that are displayed in forms and reports. Other queries add records to the tables from controls in the form.