Allen Browne Calendar Question

[channell]

I am using the Allen Browne Calendar, and everything works great when I use
it for unbound text boxes. Does anyone know how I can use it for bound text
boxes?

For Example, if I have "HireDate" as a field, I want the ease of the
Calendar to input that date.

Thank you very much in advance!

 

[channell]

Yeah, I am not sure what is going on either. I haven't changed any code, but
here is the error I am getting:

"The Expression On Click you entered as the event property setting produced
the following error: Type Mismatch."

On Click: =CalendarFor([HIREDATE],"Set Hire Date")

Does this have to do with the date field? I am very stumped...

 

[channell]

Thank You! I was puting in the Control Source, and not the TextBox Name... I
should have known better! Thanks for helping me with that.

-Scott Channell

Is your HireDate field a DateTime field? Try renaming the TextBox control to
txtHireDate. Access is probably trying to go directly to the field and
Allen's code wants you to point to a TextBox control.
Then change the OnClick code to:

Yeah, I am not sure what is going on either. I haven't changed any code, but
here is the error I am getting:

"The Expression On Click you entered as the event property setting produced
the following error: Type Mismatch."

On Click: =CalendarFor([HIREDATE],"Set Hire Date")

Does this have to do with the date field? I am very stumped...

I see nothing in Allen's code that would keep it from working with a bound
TextBox. Are you getting an error? Are you using the CommandButton? What is

[quoted text clipped - 8 lines]

Thank you very much in advance!

--
RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.com