Setting the File Name

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

I have a query which pulls data from a table using date fields on a
switchboard(StartDate & EndDate). This data list is then exported to Excel
using a Macro. I would like the name of the file to include the start and
end dates entered in the switchboard/used by the query. Is this possible?

Many thanks

Kerry
 
Excellent, thanx. It was the formatting causing the Error.

Have set it to

="G:\Admin Database\NameBadges Btwn " & Format([Forms]![Frm Main
SB]![StartDateEntry],"ddmmyy") & " and " & Format([Forms]![Frm Main
SB]![EndDateEntry],"ddmmyy") & ".xls"

it works perfectly, thanx

Kerry


Steve Schapel said:
Kerry,

Yes. Something like this?...
=[StartDate] & [EndDate] & ".xls"

--
Steve Schapel, Microsoft Access MVP

Kerry said:
Hi

I have a query which pulls data from a table using date fields on a
switchboard(StartDate & EndDate). This data list is then exported to Excel
using a Macro. I would like the name of the file to include the start and
end dates entered in the switchboard/used by the query. Is this possible?

Many thanks

Kerry
Click to expand...
Click to expand...
 
Back
Top