Controls Flying?

[nico5038]

Then I would now try the Access decompile, or try to change the datepicker's dll/ocx to a (newer) verion.

Personally I never use this (and other .ocx) controls as it's making the running of the databaseon another PC dpending on the installed .dll's (they have a reason to call this the ".dll hell").

I use for datetime picking the control fro www.mvps.org/access and have a sample attached that's a stripped down version. As it's "all Access" the portability of the control is 100%.

Nic;o)

[missinglinq]

Nico's last post made me think about something; you've been calling this a "DatePicker" and we've been assuming that it's an ActiveX control, but is it in fact? I ask because there are custom made datepickers out there that position themselves in relation to the control they're going to populate, and I have heard of problems with them from time to time.

No one has asked, but would it be possible to zip your database up and post it here? This is really one of those times when actually having your hands on the app can make a big difference in troubleshooting it.

Linq ;0)>

[FishVal]

Hello, yaara.

Do you have a method to reproduce the fault?
If so (and even if you don't), then it may be a good idea to attach sanitized copy of db to the thread.

P.S. Are you sure your DTPickers are bound to the same background as TextBoxes are?

P.P.S. Also, please post library of DTPicker control - name, version, dll/ocx.

[NeoPa]

I'm just leaving for home so am in a bit of a rush, but there was a call to arms from our revered leader so I will just pop in to suggest something you can try to help you discover what may be causing this anomaly. It is only really effective if it is due to your code, but the debugger (specifically Watch Pane - See Debugging in VBA for more details) has a facility to watch a value, and interrupt execution of the code when that changes for any reason.

I suggest you set up your database with this Watch set and see where the code stops.

Let me know how you get on with this.

[missinglinq]

Only 6:35 PM and already you're heading for home and hearth? I take it France's 35 hour work week hasn't made its way over the Channel yet!

;0)>

[yaaara]

The control indeed is the Microsoft Date and Time Picker control ver 6.0. It is the default DTPicker that I found in the Access Forms Toolbox List so I used it..

Zipping the database and posting here won't be possible as the database I'm referring to is a different .mdb file and my front end is in a different .mdb file. So If I post my front end, it won't work, and posting the DB would be difficult as it is approx 250+ MB... So not much luck there I guess..

Please let me know if anyone comes across with known issues with this DTPicker control...

Nico's last post made me think about something; you've been calling this a "DatePicker" and we've been assuming that it's an ActiveX control, but is it in fact? I ask because there are custom made datepickers out there that position themselves in relation to the control they're going to populate, and I have heard of problems with them from time to time.

No one has asked, but would it be possible to zip your database up and post it here? This is really one of those times when actually having your hands on the app can make a big difference in troubleshooting it.

Linq ;0)>

[yaaara]

As far as I know, the DTPickers are bound to the same Tab Control as the Text Boxes, but I'm not sure.. may be they're not? How can I check and make sure that they are? Also, I'd say that even if they are not (let's assume), then ideally they should not change their positions on their own... and that too at random times? That seems wierd, isn't it? But still, if bounding the controls to the Tab Control helps, I'd like to check it out... So pls let me know how to check it and how to make sure that all controls are bound to the same Tab Control...

Thanks :-)

Hello, yaara.

Do you have a method to reproduce the fault?
If so (and even if you don't), then it may be a good idea to attach sanitized copy of db to the thread.

P.S. Are you sure your DTPickers are bound to the same background as TextBoxes are?

P.P.S. Also, please post library of DTPicker control - name, version, dll/ocx.

[NeoPa]

Only 6:35 PM and already you're heading for home and hearth? I take it France's 35 hour work week hasn't made its way over the Channel yet!

;0)>

7 hour working day - That would be nice :D

[Stewart Ross]

A big thank you to all my forum colleagues for responding so timeously and helpfully here - you've really helped focus this thread in to what may well be the nub of the problem - interactions of the datepicker controls in some way.

Ever been told you're a great team to work with? I learn a lot from you all even now.

Geesh, gotta go or I'll get even more slushy...

Cheers guys

-Stew

[sam12]

Hi yaara
I was having the same problem with datepicker
I finally gave up and used a new form "calendar" to do this

Here is the link to see how it works

http://rapidshare.com/files/143939578/calendar.rar.html

It has two modules
one is for calendar and other is to change the cursor type when u go on the calendar icon
If u wana use this, Import these 2 modules and one form calendar in ur db
and u have the coding how to call it

[NeoPa]

Sam,

I tried your link and, whether the pop-up would have directed me to a download I don't know, but with pop-ups blocked I was only able to see the sign-up page of that site which is not a valid link (which I have removed).

Please, if you have helpful software to share, consider posting it in the thread. Attachments are also available if the size is not too great.

Administrator.

[yaaara]

So apparantly, this is a problem with Datepicker?

[NeoPa]

Only you would know at this stage Yaaara. Have you tried the debugging (Watch Window) technique I suggested (post #19)?

[yaaara]

Sorry but not sure how to setup the watch window for this Neo :-(

Pls assist...

[NeoPa]

On one condition :- You stop including quotes of the previous post unless they are relevant. Generally not when your post follows on immediately afterwards. It's only really necessary to indicate a break in flow of the thread, or to draw particular attention to an item as you respond to it.

Anyway - on to the instructions.

1. Find a value that will change when the item moves. This can be .Top or .Left of the item that moves.
2. Using Alt-V+H, open the Watch Pane.
3. Right click within it to add a new watch expression.
4. Enter the full object address of the .Top or .Left item you're trying to monitor into Expression.
5. In Procedure & Module select all.
6. In Watch Type select Break When value Changes

Run the code until the item moves. At this point the code should break leaving you where (or at least near) the point where something strange is happening.

Have fun :)