Hi everyone,
I dont know if anyone could help me on this one.
I would like to write some VB to update a field in a table. My table is like this.
table name : DepDates
Field names: ID, sDate, and sDateF
I have a report and the dates comes out as follows: Saturday, April 10th, 2012.
I was recently ask to bring out the report, but bilingual (French and English).
So, I created the field "sDateF" and thought if I could convert the "sDate" and update "sDateF" it would be simple.
I have a function that translate "Saturday" to "samedi" and same for weekdays called "sGetFrench". That works great if I do it on a form and edit a text field.
Anyways, how would I go about this and update all entries in my table using VB?
Many thanks,
LucS
I dont know if anyone could help me on this one.
I would like to write some VB to update a field in a table. My table is like this.
table name : DepDates
Field names: ID, sDate, and sDateF
I have a report and the dates comes out as follows: Saturday, April 10th, 2012.
I was recently ask to bring out the report, but bilingual (French and English).
So, I created the field "sDateF" and thought if I could convert the "sDate" and update "sDateF" it would be simple.
I have a function that translate "Saturday" to "samedi" and same for weekdays called "sGetFrench". That works great if I do it on a form and edit a text field.
Anyways, how would I go about this and update all entries in my table using VB?
Many thanks,
LucS