shvo131159
asked on
question ms-access hebrew field names and hebrew table names
Dears,
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("ba ns") ‘ 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?
Rgds,
David
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("ba
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?
Rgds,
David
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
...Can you post a screenshot of *exactly* what is displayed in Design view of the table, and datasheet view?
Try highlighting the field names in design view of the table and pasting into the VBA as Sudonim suggested.