Link to home
Start Free TrialLog in
Avatar of school1282
school1282

asked on

MS DTPicker control problem on datasheet View

Hello,
I'm using DTPicker control (MS date and time picker control 6.0) in MS Access database.
When I put it along with other controls (combos, textboxes) it does not appear on in the datasheet view - I've got a subform which is supposed to be used by a user while filling out the table.

Is there a way to bind DTPicker to the datasheet entry?

Is the way described in:
https://www.experts-exchange.com/questions/21949724/What's-a-good-alternate-to-Microsoft-Date-and-Time-Picker-Control-dtpicker-on-tabular-datasheets.html
the only way it  can be done?

Thank you
Shabby
Avatar of peter57r
peter57r
Flag of United Kingdom of Great Britain and Northern Ireland image

Hi school1282,
> Is there a way to bind DTPicker to the datasheet entry?

No.

You have to use a pop-up and then code the assignment  of the selected date to the required field.

Pete
Avatar of school1282
school1282

ASKER

Ok let me test the code offered above.
ASKER CERTIFIED SOLUTION
Avatar of tbsgadi
tbsgadi
Flag of Israel image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thank you Gary. I guess I'm on the right way...I just need to know if I can handle an event of clicking day cell on Calendar Control. Any ideas?
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I'm sorry but calendar control in MS Access (v.10.0) has only 5 events to assign: OnUpdated, OnEnter, OnExit, OnGotFocus, OnLostFocus...
Oh sorry I regret, it does have the on_click handler but inside the code.
THANKS jefftwilley !!