Recent content by swpps

Thanks the both of you. I used only 'FSO.MoveFile FolderPath & "\" & OldName, FolderPath & "\" & NewName' from MajP's post and it works. The Greek letters are kept.

Thanks, much appreciated. I've run your example, and true, the ψ is in the file name. But I'm still not there. What I do is not create (and name) a new file (as in your example), but rename an existing audio file with the Name ... As ... statement. VBA: Name <oldname>&".mp3" As...

In my case it doesn't. I use the value rst.Designation as part of the name I give to an audio file (with my comments about the observation of this double star with my telescope). Apart from that ? is not accepted as part of a file name, I need the original ψ.

Thanks. But I'm not Greek so I keep my current settings.... Maybe I have to be more clear. Let's stick to that ψ Ori. This is what the table says: Id Designation 523 ψ Ori Then VBA: Set rst = CurrentDb.OpenRecordset("SELECT Designation FROM [tbl Stars] where ID=523") The value of...

In MS Access have a table with attribute values (in my case star designations such as ψ Ori) that can contain all Greek letters. In VBA I query the table with a recordset, but the Greek letters are changed into their Latin counterparts or into a question mark. The problem is that I need the...

That did the trick! Thanks! Is there a system in this forum to upvote or accept a useful answer? Or just give you a like?

Good afternoon, just registered at this forum and I have a question already! I have a table in SQL Server that I try to edit from within MS Access. This is not possible. I get the message: "[Microsoft][SQL Server Native Client 11.0]Parameter information is missing from a user-defined type...