Solved

Calendar Control not working when in a Tab Control

Posted on 2004-08-22
8
259 Views
Last Modified: 2012-05-05
For some reason, my Calendar control doesn't work when contained within a tab control. I have date fields within Tab Pages that when clicked, should call a Calendar control to select a date and enter it in the text field. However, this doesn't work. Can one of you Experts please help? Many kind thanks in advanced!
0
Comment
Question by:John Account
  • 5
  • 2
8 Comments
 
LVL 8

Expert Comment

by:dkmj17
ID: 11865373
Please explain a little more if you could... is the calendar control on a second form?  If so, is the problem that the form won't open?  If the calendar control is on the main form, is it made visible?  If so, is it behind the tab control and therefore, while visible, still not viewable?

Mike
0
 

Author Comment

by:John Account
ID: 11865460
Okay, Mike, thanks. Here's more explanation: There are 5 Calendar controls on the same form: 3 are contained within a page of its Tab Control, and the other 2 are on the form, outside the tab control. The two that are not in the tab control work like they're supposed to, but not the three within the tab control. Moreover, before adding the tab control to the form, all 3 Calendar controls worked just fine. I've increased the points to 350. Many kind thanks in advanced. Below is the source code:

Private Sub Calendar1_Click()
txtUserChg = SignedInUser
txtDateP2PEntered = Now()
txtPTPDATE = Calendar1.Value
txtCheckNum.SetFocus
Calendar1.Visible = False
End Sub

Private Sub Calendar2_Click()
txtDATE = Calendar2.Value
Me.txtTime.SetFocus
Calendar2.Visible = False
End Sub

Private Sub Calendar3_Click()
txtDaterec1 = Calendar3.Value
Me.txtAmount1.SetFocus
Calendar3.Visible = False
End Sub

Private Sub Calendar4_Click()
txtDATEVER = Calendar4.Value
txtTAPE.SetFocus
Calendar4.Visible = False
End Sub

Private Sub Calendar5_Click()
  Me.txtSentCD = Calendar5.Value & " - " & Format(Now(), "hh:mm:ss")
  Me.txtAmount1.SetFocus
  Me.Calendar5.Visible = False
End Sub
0
 

Author Comment

by:John Account
ID: 11865478
Also, it's not behind the tab control, nor any other controls, therein, so that's not an issue. It is invisible, initially, by made visible once clicked, as the code, in previous submission, illustrates.
0
 
LVL 27

Accepted Solution

by:
jjafferr earned 350 total points
ID: 11865699
Hi Jhon,

Why don't you try to put the full path to the Tab (Tab Name) when calling the calendar control, for example:

txtPTPDATE = Calendar1.Value

should be

txtPTPDATE = Forms![YourMainForm].Form![Page41].Calendar1.Value

Where Page41 is the Tab Name

jaffer
0
Complete Microsoft Windows PC® & Mac Backup

Backup and recovery solutions to protect all your PCs & Mac– on-premises or in remote locations. Acronis backs up entire PC or Mac with patented reliable disk imaging technology and you will be able to restore workstations to a new, dissimilar hardware in minutes.

 

Author Comment

by:John Account
ID: 11865785
I get the following error, when I try that, Jaffer:
Run-time error '438': Object doesn't support this property or method.
txtPTPDATE = Forms![Collections Admin].Form![PgSales-Verified].Calendar1.Value
0
 

Author Comment

by:John Account
ID: 11865837
Hey, Jaffer--I'll be damned...apparently it's suddenly working. I don't know what was wrong, maybe a typo in my code or something, but all is well now. Thanks!
0
 
LVL 27

Expert Comment

by:jjafferr
ID: 11865935
I guess its my lucky day with you, answering 3 questions of yours.

thanks for the points and the grade

jaffer
0
 

Author Comment

by:John Account
ID: 11866306
You're most welcome, Jaffer--Thank you! And, hopefully, you will answer more questions from me in the future...as I have many questions and you, apparently, have many answers. You know Access very well. I haven't touched it in about a year--and, even then, didn't know the answers to any of these questions you've been so kind enough to answer for me.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
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…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

948 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

23 Experts available now in Live!

Get 1:1 Help Now