Naming an exported file

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
 
R

Randy Harris

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",
 
P

PC Datasheet

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...
 
R

Robin Chapple

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Grouping Names in Mail Merge 0
Re-title multiple MS Project .mpp files at once 0
Combining three files when middle file has sections with endnotes 2
Adding data to MS Access from csv file 0
VBA to Find Key Words in Word doc then Extract Content to Excel.xlsm file 3
Naming an exported report 14
Outlook Desktop (latest) stopped syncing IMAP accpounts from selfowned Mail server. 0
VBA code to export checkboxes to new .docx 3

Top