Naming an exported file

  • Thread starter Thread starter Robin Chapple
  • Start date Start date
R

Robin Chapple

I asked for help with incorporating my [ID] field into an exported
file.

This is part of the code.

"D:\###\" & Me![ID] & "IndividualReport.RTF",

It gives me the separate files that I need.

Now I would prefer that the ID number were at the end of the file name
rather than at the beginning so that the files are sorted together.

I have tried several rearrangements withour success.

How should I rewrite that code??

Thanks,

Robin Chapple
 
Robin Chapple said:
I asked for help with incorporating my [ID] field into an exported
file.

This is part of the code.

"D:\###\" & Me![ID] & "IndividualReport.RTF",
Click to expand...


"D:\###\" & "IndividualReport" & Me![ID] & ".RTF",
 
Only as a point of interest ----

You don't need the square brackets around ID. You only need to use square
brackets when the name of the object contains one or more spaces.


--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com


Randy Harris said:
Robin Chapple said:
I asked for help with incorporating my [ID] field into an exported
file.

This is part of the code.

"D:\###\" & Me![ID] & "IndividualReport.RTF",
Click to expand...


"D:\###\" & "IndividualReport" & Me![ID] & ".RTF",

It gives me the separate files that I need.

Now I would prefer that the ID number were at the end of the file name
rather than at the beginning so that the files are sorted together.

I have tried several rearrangements withour success.

How should I rewrite that code??

Thanks,

Robin Chapple
Click to expand...
Click to expand...
 
Thanks, all is well. I did not handle the extension properly.

Robin Chapple said:
I asked for help with incorporating my [ID] field into an exported
file.

This is part of the code.

"D:\###\" & Me![ID] & "IndividualReport.RTF",
Click to expand...


"D:\###\" & "IndividualReport" & Me![ID] & ".RTF",

It gives me the separate files that I need.

Now I would prefer that the ID number were at the end of the file name
rather than at the beginning so that the files are sorted together.

I have tried several rearrangements withour success.

How should I rewrite that code??

Thanks,

Robin Chapple
Click to expand...
Click to expand...
 
Back
Top