R
Randy
Access 2000. I would like to create a form that would: Enter an office
number through a combobox, such as "764". Next enter a beginning date in a
textbox, then enter an ending date in the next texbox. Click on a cmd
button to run a macro that exports a query to an excel file. I know how to
do this. What I would like is to click the cmd button and have the excel
file automatically named such as: 764_1-1-07to1-7-07 Which includes
the office number in the beginning and the beginning and ending dates. Can
this be done? Thanks in advance, Randy.
number through a combobox, such as "764". Next enter a beginning date in a
textbox, then enter an ending date in the next texbox. Click on a cmd
button to run a macro that exports a query to an excel file. I know how to
do this. What I would like is to click the cmd button and have the excel
file automatically named such as: 764_1-1-07to1-7-07 Which includes
the office number in the beginning and the beginning and ending dates. Can
this be done? Thanks in advance, Randy.