Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old January 25th, 2006, 10:05 PM
Friend of Wrox
Join Date: Mar 2004
Posts: 217
Thanks: 0
Thanked 1 Time in 1 Post
Default Date-Time Picker Active-X Error

I added the Date Time Picker control to a form and am getting an error whenever I scroll through records. The message box just reports an error occurred in the Date Time Picker without any number. It occurs when I have no date selected in that particular control, and the check box that is part of the control is not checked. This only occurs when I scroll off of a record that has not value in that control, and it occurs twice. Stepping through does not reveal anything is amiss.

Any ideas of how to fix it? I'm working in A2K.

Old January 27th, 2006, 03:22 PM
Friend of Wrox
Join Date: Nov 2004
Posts: 1,621
Thanks: 1
Thanked 3 Times in 3 Posts

There is a property of the DateTimePicker (the name escapes me... "Allow null?") that will genereate an error on a DateTimePicker pointing to non-existent data.

In design, change this property for the control.

I just went and tried this. I get the error on blank data “Can’t set Value to NULL when CheckBox Property = FALSE.”

In design mode, I right-click the control.
From the context menu, I select DTPicker [u]O</u>bject > Properties
I select the “[u]C</u>heckBox” checkbox

Now I can scroll past a record with a null value for the date. The control shows a date, but the value is greyed out, and the checkbox is unchecked.

It’s a bizarre operation...
Old January 30th, 2006, 08:22 PM
Friend of Wrox
Join Date: Mar 2004
Posts: 217
Thanks: 0
Thanked 1 Time in 1 Post

Thanks Brian,

I can't seem to find the other property you are talking about. Under the data tab, I only get Control Source, OLE Class, Class, Enabled and Locked. I have selected the Check Box already, so there must be another property I'm missing?????


Similar Threads
Thread Thread Starter Forum Replies Last Post
Date and Time Picker snufse ASP.NET 2.0 Basics 1 March 19th, 2008 06:35 AM
Date and time picker anukagni Access 3 June 21st, 2007 12:16 AM
Date Time Picker goraya C# 1 June 4th, 2004 07:01 AM
Microsoft Date and Time Picker - Error mikericc Access VBA 1 December 4th, 2003 04:15 PM
Date time picker GrindBright BOOK: Beginning Access VBA 2 November 18th, 2003 05:01 PM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.