Re: [MS_AccessPros] filename changes when imported into msaccess

 

hi Onno,

at the top of the module to process foreign characters, instead of
Option Compare Database

choose:
Option Compare Binary

if using InStr or StrComp, use vbBinaryCompare for the optional 'compare' argument

InStr([start, ]string1, string2[, compare])
StrComp(string1, string2[, compare])

there are other functions can specify these comparison constants too

for storing, however, my experience it that you can't do it with regular string variables ... but fields can store it, and so can probably controls

respectfully,
crystal

On 12/1/2016 3:20 PM, onno.knol@pbl.nl [MS_Access_Professionals] wrote:

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: crystal 8 <strive4peace2008@yahoo.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (2)

---

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

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___