[MS_AccessPros] filename changes when imported into msaccess

 

Friends  I have  encountered a strange phenomenon.

I select a filename using the filedialog. it is an Mp3 file with a Spanish title:

12 - La Estaciyn Del Mar - La Chica De Goa.mp3" is what it shows like in the  windows filesystem.

Then I put it into a string variable, and when I try to work with that ( I want to move the file)

it appears that the string variable  contains this: 

 12 - La Estaci?n Del Mar - La Chica De Goa.mp3" 

 

Apparently the 'y'  character is some special Spanish character that is not well recorded in the VBA variable.

How can I work with this? 

 if I do a check if the fileexists with the new name, the result is false.

how can move/ rename the file if I can't get the real name?

Does it have to do with codepages or charactersets?

Can I transform it in some way?

BTW  I received the file from a person wit a Spanish  windows version.

I h pe someone can help me out, I do not know the clue.

Oh by the way I use win10 and msaccess 2010

Thanks,

 Onno Knol

  

__._,_.___

---

Posted by: onno.knol@pbl.nl

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (1)

---

Have you tried the highest rated email app?

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

---

Visit Your Group

• New Members 1

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___