Solved

DTPicker losing Control Source

Posted on 2002-05-09
3
540 Views
Last Modified: 2007-12-19
I have an Access 97 app which uses the MS DTPicker control for updating a Date/Time field.  The DTPicker control is bound to a field named EffectiveDate.  The database resides on an admittedly inadequate server and is used daily by 6 users.

Occasionally (maybe once every couple of months but recently much more frequently) the DTPicker control loses its Control Source property value.  It is suddenly no longer bound to the EffectiveDate field.  <eerie music plays in background>

Any ideas?  I will gladly provide additional info upon request.
0
Comment
Question by:lmerrell
  • 2
3 Comments
 
LVL 1

Accepted Solution

by:
dougp23 earned 100 total points
Comment Utility
Well, if you just want a bandaid, write a little script that fires off say every 30 minutes or so.  The script would simply tell the control what its control source is.  (I did this once with a combox box.  Required a form to be open, as I tied it to the form's timer control, but you can use TIME to evaluate how many seconds have passed, and after , say 5000 seconds, tell the control what its control source is again.)  You wouldn't get an error, even if it already had the right control source and you told it the same thing again.  
0
 
LVL 7

Author Comment

by:lmerrell
Comment Utility
That could be of some temporary help, doug.  Although, I would probably put the Control Source update in the Current event of the form which would guarantee its update more often.  But, I would really like to figure out what is causing this behavior in the first place.

I will post you an additional question with points for your bandaid solution later.  I'll post a link to the Q here.
0
 
LVL 7

Author Comment

by:lmerrell
Comment Utility
Well, I haven't had any other input and the updating of the Control Source in the Current event appears to be working quite well so the points are yours Doug.

Thanks for the input!

Guido
0

Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

Suggested Solutions

When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now