Solved

Calendar works on first entry, but not when user enters another task

Posted on 2011-09-09
4
253 Views
Last Modified: 2012-05-12
I am using Steven Lebans Calendar function adn it works perfectly for the first entry.  This is on an unbound form but the problem is if the user wants to enter more than one task, one the second task, when they hit the calendar text box, an error message of Run-Time 13, Type Mistach comes up.  How can I re-use the form witout having to close and reopen when there is more than one entry to be made?
0
Comment
Question by:ssmith94015
  • 3
4 Comments
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 36514367
The Lebans calendar is just that, a Calendar.

So when you say "Task" you must provide context for this.

Remember we know nothing about your applications, so it is difficult to make any suggestions.

Can you post a sample db, or at the very least, the code involved?

Sample database notes:
1. Back up your database(s).
2. Combine the front and back ends into one database file.
3. Remove any startup options, unless they are relevant to the issue.
4. Remove any records unless they are relevant to the issue.
5. Delete any objects that do not relate directly to the issue.
6. Remove any references to any "linked" files (files outside of the database, Images, OLE Files, ...etc)
7. Remove any references to any third party Active-x Controls (unless they are relevant to the issue)
8. Remove, obfuscate, encrypt, or otherwise disguise, any sensitive data.
9. Compile the code. (From the VBA code window, click: Debug-->Compile)
10. Run the compact/Repair utility.
11. Remove any Passwords and/or security.
12. If a form is involved in the issue, set the Modal and Popup properties to: No
    (Again, unless these properties are associated with the issue)
13. Post the explicit steps to replicate the issue.
14. Test the database before posting.

In other words, ...post a database that we can easily open and immediately see and/or troubleshoot the issue.
And if applicable, also include a clear graphical representation of the *Exact* results you are expecting, based on the sample data.


JeffCoachman

0
 

Author Comment

by:ssmith94015
ID: 36516473
Will have to do this on Monday when I get to work.  Wat a task is, say a developer is given a project to create an Access 2003 database that tracks documents.  Tasks are what the developer will need to do to gather user information, needs, requirements, etc.  So, tasks could be meet with end users, create data map, prototype code - three tasks related to one project and each task could have different due dates.  I would like the developer to be able to put these three separate tasks in without having to close the Task Entry form and reopen to enter the next task.  Right now, after the task is saved, there is code to reset all fields to empty text strings so I think it has something to do with properly re-setting the text control the calendar is attached to, it needs to be reinitlalized and I am not sure how to do it.  So, sample db on Monday!
0
 

Accepted Solution

by:
ssmith94015 earned 0 total points
ID: 36920450
Jeff, Ifinally figured out what was going on.  I simply needed to re-initiliaze the calendar when the user needs another task.  I placed the code in a closing module that, if the user adds another task, it acts like it is closing, but does not close and recreats the calendar, works perfectly.
0
 

Author Closing Comment

by:ssmith94015
ID: 36941266
Simply needed to tell the system to re-iniitalize the calendar class.
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Computers reporting Windows patches applied 14 79
MS accesss using VBA to change a default value 5 30
Change AD password via MS Access DB 2 20
Run Time Error 3071 26 39
Whether you've completed a degree in computer sciences or you're a self-taught programmer, writing your first lines of code in the real world is always a challenge. Here are some of the most common pitfalls for new programmers.
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
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.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

920 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

15 Experts available now in Live!

Get 1:1 Help Now