Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    austin, Texas, USA
    Posts
    1,029
    Thanks
    0
    Thanked 0 Times in 0 Posts

    strange error on opening a form (Access2K, Win2KPro)

    here's a weird error I get when opening a form or scrolling thru the data: Can't set Value to NULL when CheckBox property = FALSE.

    ?? There are no checkboxes within miles of this db and all the textboxes are set to allow nulls.

    I did load the db with info from an Excel spreadsheet and am using some lookup fields for populating some dropdowns and am using the MS DateTime Picker on several date controls.

    TIA
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20>

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: strange error on opening a form (Access2K, Win2KPro)

    Do you have some code in the on open or / and in the on current event of the form ?
    Can you attach a stripped version of the db so we can have a look ?
    Francois

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    austin, Texas, USA
    Posts
    1,029
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: strange error on opening a form (Access2K, Win2KPro)

    Actually I just figured it out -- it's because of the ActiveX (MSComCtl2.DTPicker.2) -- there's an option to put a little checkbox in the control: if it's unchecked the date is visible but 'dimmed' meaning (I suppose) there is no date selected in that field. I put the control on the form and the default when doing so is to not display the little checkbox (which makes sense to me as it's not very clear what the little checkbox is supposed to do) -- but anyway if you don't have the checkbox displayed in the DateTime picker then the error message pops up. I'm going to have to see if I will need to reenter the info to make the form work.

    Thanks anyway tho!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •