Search results

Hi everyone. I type Hebrew letters in vba and get gibeerish on form label. Here is the vba code: 'Show results on labaels Me.lblKoteret1.Caption = "יש" Me.lblKamutChidushim.Caption = SoferReshumot Me.lblKoteret2.Caption = "חידושים לפסוק " & Me.cmbPasuk and this is what I get on...

theDBguy I want to thank you too your answer is exactly the problem I had, but I was stupid not to understand it. :unsure::unsure:

O.K ... I found the problem ... from what bastanu asked ... I changed the bound to 2 and it is ok now. Thanks to evryone that tried to help

But I do have 2 columns as in the picture when the first one is hidden

here it is: strSqlPerek = "SELECT tblPasuk.ParashaId, tblPasuk.PasukNum FROM tblPasuk WHERE (tblPasuk.ParashaId=" & Form_frmPsukim.cmbParasha.Value & ") AND " & " (tblPasuk.PerekNum='" & Form_frmPsukim.cmbPerek & "') " Me.cmbPasuk.RowSource = strSqlPerek Me.cmbPasuk.Requery...

It has one hidden column (the id) ... here is the vba code: strSqlPerek = "SELECT tblPasuk.ParashaId, tblPasuk.PasukNum FROM tblPasuk WHERE (tblPasuk.ParashaId=" & Form_frmPsukim.cmbParasha.Value & ") AND " & " (tblPasuk.PerekNum='" & Form_frmPsukim.cmbPerek & "') " Me.cmbPasuk.RowSource...

Yes

Only 1

It doesn't have a control source becuase it based on vba code

I have a form (Hebrew) with few comboboxes all of them working good except one that not letting me selecting a value and I can't understand the problem Here are 2 screen shuts the first one is where I want to select and the second one is after I selected 1. 2. It give me just the first one...

I'm really impress from you .... You saved me so much time ... I was really depress from it ... It works really good ... here is a screnn sot ==>

Wow ..... you are really expert ... I spent days and night to solve it ... and there are so many like me with the same problem ... unbelievable!!!! I did see the link you gave me but I didn't really understand it. I wil update you soon after I will change the code in my file. Thank you so much

I attched a sample text file that has a hebrew line and then link lilne and an image line. I hope I'm not too much bothering and really appriciate your effort to help me.

I will explain myself better. The text file is in utf-8. The language in the text is Hebrew. When I open the text I can read the Hebrew with no problem. When I open the text file with vba reading line by line the text is gibberish. This is my problem and I don't know how to solve it.

Saving the text file with Plain Acii give me ???????? .... it must be with utf-8

Yes

Hi After I finished my project that has 2 files (splitted) .... how do I deploy it to customers with no chance to make chenges and to be able to install it in any computer (even if they don't have Access ... runtime)?

Hi everyone Reading an Hebrew text file cause gibberish when saving to table. I attached screen shot and the vba code ==> Public Function KraPirsomotMeKovetzMekomi() Dim objFSO As Object Dim objTextStream As Object Dim strTextLine As String Dim strInputFileName As String 'On Error GoTo...

Hi My name is Ami from Israel. Happy to join the forum. I'm a vb.net programmer and Ms Access too. Good to be here