A2002, XP and file names

[FoFa]

I am trying to create a file name via transfertext as PAY.5703.20030101.20031024.UPD, but first it gives me a read only error, so I changed the .UPD to .TXT and that works, but I am still going to need the .UPD. I think I saw something on that, but what I have not seen is it changes the periods to #. So the file comes out PAY#5703#20030101#20031024.TXT. I can rename the file to the proper name, but I don't think I can reliably get the users to do this before they send these files off. We have a set file naming convetion setup by the vendor. Any ideas on how to get Access to just get it right in the first place?

 

[namliam]

there should only be 1 point in a file name....

Regards

 

[sparx]

Simply try using VBA code to get the proper file name to help, if you are not sure how to do this, I will gladly help...

 

[FoFa]

namliam The file name is required by the vendor, I have no choice in the name.

sparx I am using in VBA DoCmd.Transfertext. I am supplying the drive:\path\filename in a variable with the Drive:\path chosen by the user (file name is set by the vendor). So is it the transfertext function that is changing the .'s to #'s, or something else? I could write a looping routine to manually handle the file creation, but didn't want to if transfertext would do it. Any other ideas?

 

[FoFa]

Anyone?