Recent content by bmkol

O.K. As I show you on screenshots I can show Hebrew The problem is with VBA Hebrew text. For example, if the user chose something and I want a msgbox saying that: "You chose .... (Hebrew value) ... do you want to save it?" This is something dynamic that I can't have a table for it. I appriciate...

O.K friends ...I found a long code that helped me with the Hebrew dates which is really hard to do ... so is here the link for whoever needs .. http://www.dafaweek.com/HebCal/HebCalVb6.php

In one of the links it did help to show Hebrew (A lot of work for a little word) using CHR function ... here is a code for it: Dim sVariableText As String sVariableText = ChrW(1488) & " " & ChrW(1520) & " " & ChrW(1509) & " (should see Hebrew characters)" each CHR is for 1 letter (can...

As far as the image here ... how did it work in your pc? amazing ... is it from a vba code or you just type it into the Caption property? (When I type to the Caption property I can see it too ... the problem is from the vba code)

Thank you for your reply I used Ariel too ... The problem I have is that based on user's action on the form I create different messages each time ... so I can't really use your suggestion which is very good but not in my case

No. Nothing changed. Same problem.

Thanks for your reply 1. Regional setting does help but not good for users with different regional setting 2. My own message box will not solve it becuase I still need the Hebrew on it 3. Google .... too much to do it I keep looking.

You can bless me with Happy Hanuka ... I'm an Israeli (Jewish)....:LOL::LOL:

I suggest you to add a page with link subjects of the codes you have that will make it easy to find issues that reply to users on your website. I used your search on the website but a webpage with topics will also rank your website better.

I can't show Hebrew string on form and I don't want to change the region language, beause the users will not be all from the same region I rather do it from VBA but I don't know how. Here is a saving record click event that has a msgbox with Hebrew saying that Saves succesfully Private Sub...

Very nice blog. I added it to my favorites

Yes ... exactly.

I solved my problem ... The reason I got blank form was becuase anytime there were no result of the sql statment the form was empty. I'm so stupid sometimes.

I never heard about left or right join. What do you mean? Should I change something on my sql statment?

I'm doing a really simple task and have no idea why I get blank form when I try to open it from another form. Here is the form when I open it not from another form: The record source of this form is: SELECT tblChidush.ChidushId, tblChidush.LoaziDate, tblChidush.HebDate, tblChidush.PasukId...