question ms-access hebrew field names and hebrew table names


I got an ms-access that is table names and field names are all in Hebrew.

How can I refer to Hebrew field name in VBA macro such as:

Private Sub new_ban_Click()

Dim dbswork0 As DAO.Database
Dim rstbans As DAO.Recordset

   Set dbswork0 = CurrentDb
   Set rstbans = dbswork0.OpenRecordset("bans")  ‘ I would like to put here instead of bans hebrew name such as ¿¿¿¿ ¿¿¿¿¿ ¿¿¿ – ¿¿¿¿¿

Rstbans!bank_acc = 12
I would like to put instead something like rstbans!¿¿¿¿ ¿¿¿¿¿  = 12

How can I make the VBA understands me?

Another question I would like in the VBA to set the values of the fields according to the fields that appears in the form how can I do it?

Who is Participating?
Simon BallConnect With a Mentor Commented:
wrap all field and table names in square brackets... it might help.


to open the recordset, i think you have to call a query name, or use sql to say
"select * from [Tablename]"
Jeffrey CoachmanMIS LiasonCommented:
...Can you post a screenshot of *exactly* what is displayed in Design view of the table, and datasheet view?
shvo131159Author Commented:
Jeffrey CoachmanMIS LiasonCommented:
Try highlighting the field names  in design view of the table and pasting into the VBA as Sudonim suggested.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.