Y
yaya
Is there a way to set\change the Format Property of a filed in table by SQL
statement?
statement?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
Allen Browne
No. The Format property of a Field in a TableDef can only be set using DAO
code.
code.
Y
yaya
Hi Allen,
First thank you.
I asked you befor few days about the Me.refresh and you answer me
("me.dierty" ...) and it;s solved the problem. BUT i have another quation
with this subject:
I have a form base on this big table i talked about (20k records).
from this form i call a vba function that change (by "db.execute" sql
statement) one of the fields in the current record that shown in this form.
to reflect the changes i use: forms![frm1].refresh and as i said it is very
very slow.
I can't use here ".dirty" because the changes made by the function and not
by the form.
Do you have another way to reflect the changes only to this specific record
in the form?
and again, you realy helped me so thanks.
First thank you.
I asked you befor few days about the Me.refresh and you answer me
("me.dierty" ...) and it;s solved the problem. BUT i have another quation
with this subject:
I have a form base on this big table i talked about (20k records).
from this form i call a vba function that change (by "db.execute" sql
statement) one of the fields in the current record that shown in this form.
to reflect the changes i use: forms![frm1].refresh and as i said it is very
very slow.
I can't use here ".dirty" because the changes made by the function and not
by the form.
Do you have another way to reflect the changes only to this specific record
in the form?
and again, you realy helped me so thanks.
A
Allen Browne
Answered under your original post.