text box issue

[SalimShahzad]

DEAR GURUS, CAN ANY ONE CHECK THIS CODE WHEN I RUN ON UNBOUND TEXT BOX
IT WORKS 100%, BUT IF I USED ANY BOUND TEXTBOX IT WORKS SOME TIME AND
SOME TIME NOT????

AND IN THE TABLE IT IS SET AS DATE,

CAN ANY ONE PASS COMMENTS ON THIS..I KNOW THIS IS SMALL PROBLEM
SOMETHING MISSING OR SYNTAX MISSING...I AM CONVERTING FROM GREGORIAN
DATE TO HIJRI AND VICE CERSA

=============== =============== =========
Private Sub Dt_Dob_ar_After Update()

Calendar = vbCalHijri
Dt_Dob_en.Value = Dt_Dob_ar.Value
End Sub
=============== =============== =========

[pietlinden]

SalimShahzad wrote:

DEAR GURUS, CAN ANY ONE CHECK THIS CODE WHEN I RUN ON UNBOUND TEXT BOX IT WORKS 100%, BUT IF I USED ANY BOUND TEXTBOX IT WORKS SOME TIME AND
SOME TIME NOT????

AND IN THE TABLE IT IS SET AS DATE,

CAN ANY ONE PASS COMMENTS ON THIS..I KNOW THIS IS SMALL PROBLEM
SOMETHING MISSING OR SYNTAX MISSING...I AM CONVERTING FROM GREGORIAN
DATE TO HIJRI AND VICE CERSA

=============== =============== =========
Private Sub Dt_Dob_ar_After Update()

Calendar = vbCalHijri
Dt_Dob_en.Value = Dt_Dob_ar.Value
End Sub
=============== =============== =========

Umm... for starters, how about not shouting? Did you try it without
using .Value, since that's the default property anyway? Hmm...
comments? How about doing a little experimenting.. .. in other words,
it's called independent learning. (Well, next time, don't ask for
comments!)

[SalimShahzad]

dear sir,

i respect ur suggetions and avoid to pass comments, there must be some
misunderstandin g...

anyway u r nt aware what i am suffering, as system handle 1 calendar in
one time...now the access is behaving abnormal when i am converting
dates from gregorian to hijri works 100%

when i convert from hijri to gregorian is still fails....

if u can help us is okay otherwise plz don't hurt this way, after all
whatever I leanr from u gurus, groups and books and my own practical
experience

rgds,
shahzad
pi********@hotm ail.com wrote:

SalimShahzad wrote:

DEAR GURUS, CAN ANY ONE CHECK THIS CODE WHEN I RUN ON UNBOUND TEXT

BOX

IT WORKS 100%, BUT IF I USED ANY BOUND TEXTBOX IT WORKS SOME TIME AND SOME TIME NOT????

AND IN THE TABLE IT IS SET AS DATE,

CAN ANY ONE PASS COMMENTS ON THIS..I KNOW THIS IS SMALL PROBLEM
SOMETHING MISSING OR SYNTAX MISSING...I AM CONVERTING FROM GREGORIAN DATE TO HIJRI AND VICE CERSA

=============== =============== =========
Private Sub Dt_Dob_ar_After Update()

Calendar = vbCalHijri
Dt_Dob_en.Value = Dt_Dob_ar.Value
End Sub
=============== =============== =========

Umm... for starters, how about not shouting? Did you try it without
using .Value, since that's the default property anyway? Hmm...
comments? How about doing a little experimenting.. .. in other words,
it's called independent learning. (Well, next time, don't ask for
comments!)

[Salad]

SalimShahzad wrote:

DEAR GURUS, CAN ANY ONE CHECK THIS CODE WHEN I RUN ON UNBOUND TEXT BOX
IT WORKS 100%, BUT IF I USED ANY BOUND TEXTBOX IT WORKS SOME TIME AND
SOME TIME NOT????

AND IN THE TABLE IT IS SET AS DATE,

CAN ANY ONE PASS COMMENTS ON THIS..I KNOW THIS IS SMALL PROBLEM
SOMETHING MISSING OR SYNTAX MISSING...I AM CONVERTING FROM GREGORIAN
DATE TO HIJRI AND VICE CERSA

=============== =============== =========
Private Sub Dt_Dob_ar_After Update()

Calendar = vbCalHijri
Dt_Dob_en.Value = Dt_Dob_ar.Value
End Sub
=============== =============== =========

Maybe add the line
Calendar = vbCalGreg
after you assign the value to Dt_Dob_en?

/