Date and Time Picker on Continuous Forms

Posted on 2005-05-08
Last Modified: 2008-02-20
I am using the date and time picker throughout my program and it works fine everywhere except on my continuous forms.   I have the form's recordsource set to a query that gets the date from the date and time picker. The form and code works fine as long as the query finds matching records.  If no matching records are found, and I attempt to change the date, I receive the following message.

Run -time error '2771':
The bound or unbound object frame you tried to edit doesn't contain an OLE object

Then it stops working altogether. I can get the form working with a textbox formatted to shortdate and have the user type it in, but since I'm using the control everywhere else, I'd really like to get it working on this form as well. I've searched the ee knowledgebase and saw others with this problem, but the solutions are not working for me. I'd really appreciate any help anyone could give. Thanks!
Question by:Mavislee
    LVL 46

    Accepted Solution

    I used to use the date & time picker & found too many problems with it ,like the one your having.
    Check out ,it uses the date & time picker dll & so far I haven't found any bugs.

    Good Luck!

    LVL 74

    Assisted Solution

    by:Jeffrey Coachman

    I case you do not get the answer you need, check out this link:

    It is a Non-Active-x Date picker that you can make yourself. It is a lot smaller than the one that comes with Access.

    Follow the steps on the page to create it, or just download the sample database!

    Good luck!
    LVL 27

    Assisted Solution

    You cannot use an activex control (Date and Time Picker is an ActiveX control) in a Continuous Forms, Access will not allow you to.
    an option will be to have this activex control on the Form Header and a command button OR textbox pointing to it in the Continuous Forms, to take the data from it.

    LVL 38

    Assisted Solution

    by:Jim P.
    I ran into this a while back.

    Create two regular unbound text boxes set to be a date/time format. Set the visible = false.
    When the user populates from the control have them populate the text boxes. Then run your query against the values in the text boxes.

    Author Comment

    I just want to thank everyone for taking the time to reply to my question. I tried both JJafferr and Jimpen's solutions and even went as far as putting the calendar on a separate pop-up, transferring the date to a text box on the continuous form, and having the query get the date from the textbox, but it still didn't work. I don't understand what the problem is, but it's just not working. I wound up using a regular textbox formatted to medium date, which works fine. Although, I don't have the time to implement Boag2000 and tbsgadi's solutions on this project, I appreciate these links as they both seem to be viable solutions for future projects. I won't bother with this control anymore. Thanks again for all your help and ideas!

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    In the previous article, Using a Critera Form to Filter Records (, the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
    I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
    Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
    Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …

    760 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

    12 Experts available now in Live!

    Get 1:1 Help Now