Access 2000 Macro

[Ray1127]

I have a Query that will be run monthly to create a table called tblmbrcount. I would like to set a macro that will run upon completion of the Query that will rename the tblmbrcount based on the month run. (If run for April 2010) the new name will be tblmbrcount_apr_2010 .... I created a macro that will run the query and I wanted to add a line to the macro to run the rename but it requires that the new name be in the macro. The query that creates the table uses 2 dtpicker objects in a form for the date range I'd like to use the start date from that form to append to the name or at worst have the macro prompt the user for the correct name. Is this possible in Access 2000?

 

[PHV]

I'd use VBA instead of macro ...

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886