Solved non-english in vba ?

[TipsyWolf]

hey guys, im literally at final stage to run my db at work network, but the folder which my db is gonna be placed has non-english directory letters and looks like vba doesn't like it much


is there a way to fix it ?
i need russian letters.

 

[TipsyWolf]

 

[TipsyWolf]

is it about WIN region settings for non-unicode programs ?

 

[Gasman]

I doubt it. We has a discussion on another site. You can see languages within controls, but not in VBA.
You could try concatenating a control value that holds the path and see if that works.
Can you store that in a configuration table? I would expect so , if everything else is in another language.

Edit: However that is not within quotes anyway?

 

[TipsyWolf]

You could try concatenating a control value that holds the path and see if that works.

okay, so i will store this path in a new table "Tlink" with one field "link" and one record and this path link will be in this record.
how i would code in vba that it needs to look for link in Tlink at filed "link" ?

 

[TipsyWolf]

like instead of "C:\Images\" in VBA
"look for text in [Tlink][link]"

or if i have a textbox named txtlink
"look for text in txtlink"

 

[TipsyWolf]

ou could try concatenating a control value that holds the path

could u please give me an example of it ?

 

[Gasman]

"Q\clipboard\" & Me.MyPath & "\" & Me.Myfile & ".db"

Most of what you show there was not going to work even if it was in English?

 

[TipsyWolf]

"Q\clipboard\" & Me.MyPath & "\" & Me.Myfile & ".db"

Most of what you show there was not going to work even if it was in English?

in english like C\images\ it works perfectly fine on my loptop.

but non-english link is a pain in my ass right now

 

[TipsyWolf]

not sure what i did, but it magically worked for me
lol

 

[Gasman]

No, I mean you just have a path in that code with no context?

 

[TipsyWolf]

No, I mean you just have a path in that code with no context?

oh, no , it was just an example, i moved that link just to check before "replace all"

 

[sonic8]

is it about WIN region settings for non-unicode programs ?

Yes, it is.
But I would *not* recommend to change this setting because the users using your application may not be able or willing to change this accordingly.
Instead use the approach recommended by @Gasman and store these paths in a table and load them at runtime. You can use the DLookup function to do that.