Tabbed Form And Calendar Control
Apr 13, 2005
I have been using a calendar control on a subform and have now split the data into a tabbed form with 4 subforms. The calendar is now entering the date selected into the first record of each subform instead of just the one on the subform that has the focus.
Do I need to add the calendar control to each subform now or is there a way to reference the correct form in my current code?
Private Sub Calendar_Click()
' Enters the selected date into the DateCompleted field
Forms![Training]![ElectiveTrainingSub].Form.[Date].Value = Me.Calendar.Value
Forms![Training]![CorpReqSubform].Form.[Date].Value = Me.Calendar.Value
Forms![Training]![XOGReqSub].Form.[Date].Value = Me.Calendar.Value
Forms![Training]![Recommended Training].Form.[Date].Value = Me.Calendar.Value
I have tried If Me!TabCtl159 = Me.Page160 (first tab) Then
'enter date into that record
with no luck
Any ideas would be appreciated as always!
Thanks,
Toni
View Replies
ADVERTISEMENT
Mar 29, 2013
I'm creating a tabbed form in Access 2007, and in the first 3 tabs, when I dragged the field controls onto the form, they stretched to the width of the form and all stacked nicely underneath each other.
Now on the next tab they are coming out as much smaller. I don't want to stretch them to fit as I want them a uniform size and I just want to find how to get that setting back! I've been messing with the anchoring buttons to what seems like no avail!
View 2 Replies
View Related
Jun 3, 2005
Any help will be most appreciated!!
1) I have a Main form with a tabbed form that has two subforms attached to it. How do I move the focus from the last field on the first subform to the first field on the 2nd subform without using the tabs at the top of control.
2) Subform #2 is a dependent form of subform #1. Since I can have many products associated with the customer form, I have added an add new record command button using the wizards. The button does not take me to the first field on the 2nd subform it just sort of blinks.
Thanks in advance
~VanEpps
View 2 Replies
View Related
Oct 19, 2006
I am trying to limit the number of records displaying in a subform [amendedLoans] by selecting only those records that have the same ClientID as the mainform [Customers] and the same loan number as the subforms parent form [ClientAccounts loan changes].[loanno].
I have no difficulty selecting records just using the clientid but as soon as I add the reference to the subform [loanno] field I get no selection of records. I suspect there is an error in the where clause for
[Amended Loans].Loan)=[Forms]![customers]![ClientAccounts loan changes].[Form]![LoanNo]) .
I have built the clause using the expression builder and have had many attempts all ending up with the same result. I'm now at a loss as to where to go from here....
View 7 Replies
View Related
Jul 4, 2014
I have a form with a tabbed control on it. The tabbed control has 4 tabs that each have a report on them. When I select a company name on the main form, I requery these 4 reports to show data related to that company.
For some strange reason, 2 of my reports requery with no problem, and 2 of them give me a message that the report can't be found. Here is the code:
Code:
Private Sub cboCompanyName_AfterUpdate()
On Error GoTo cboCompanyName_AfterUpdate_Err
' DoCmd.SearchForRecord , "", acFirst, "[CompanyID] = " & str(Nz(Screen.ActiveControl, 0))
' After selecting a company, requery the subreports to display the appropriate data
' These 2 work
Forms!frmCompanyHistory!RptCompany_Projects_Brief.Requery
Forms!frmCompanyHistory!RptEmployeesSpecificCompany.Requery
'These 2 Fail
Forms!frmCompanyHistory!SubRptCompany_Payback.Requery
Forms!frmCompanyHistory!SubRptCompany_Revenue.Requery
'Other things I've tried
'Forms!frmCompanyHistory!TabCtl66!SubRptCompany_Payback.Requery
'Me.TabCtl66!SubRptCompany_Revenue.Requery
As a side note, if I chose the company, say "ok" to the error, and then go run the queries that these reports are based on, I get the correct records. Also, if I chose the company and run the 2 failing reports standalone, they work fine, so I know the problem isn't the reports or the queries themselves.
I have also checked and rechecked for any spelling mistakes and have found none. I should mention that the error message is "Programs cannot find the field 'SubrptCompany_Payback' referred to in your expression".
View 8 Replies
View Related
Aug 26, 2006
I am using Access 2003. I have a form with two text fields that I have configured as "Short Date". I set up Calendar Control as a new popup form (frm_Calendar) and set up the date fields to popup the Calendar on double click. I have 2 problems.
1. The calendar does not want to default to today's date. I tried entering "=Date()" into the "Value" field of Calendar Control, but it removes that code after I click off of it. So how can I get Calendar Control to default to today's date?
2. When I double click on a calendar date, I want that date to be posted into the date field. How do I get it to do that? I looked at all the properties, but did not see a way to tell the date field to accept the calendar entry.
Thanks for your help.
Jim
View 6 Replies
View Related
Feb 18, 2005
I want to use the calendar control on a form, but cannot find a way to 'minimise' it when it is not needed. I feel sure that there is a way to do this. Can anyone help?
View 8 Replies
View Related
May 10, 2005
I am creating an employee scheduling application to use for ambulances. In one form, I am trying to list those scheduled to the various shifts by date so that we can edit an individual day.
I firstly, want to open the form with the today's date and the employees accordingly. I am using the following code in the form_Current(), the form_GotFocus(), form_load(), and form_Open(Cancel as Integer) subs.
ctlCalendar.Value = Date
I cannot get it to display to today's date.
I am then wanting to pass the date to the query which selects the employees that are working each duty position. When the form opens it opens the oldest record, not today's. I think that there's a problem with the WHERE portion of my SQL statement.
When a user selects a date on the Calendar Control, I want to re-run the query and display the employee's scheduled to work on the selected date.
Any ideas?
View 5 Replies
View Related
May 26, 2006
I have a form with calendar control 11.0 placed on it.
When the form opens, the calendar is invisible.
When the cursor enters a field called ClassDate the calendar (calClassCalendar) becomes visible.
When the user clicks a date on the calendar control I want that date to appear in in the ClassDate field.
I would have expected the Calendar Control to have an OnClick Event Property that would have allowed something like
ClassDate.value=calClassCalendar.val
To my complete dismay there is NO OnClick event on the Calendar Control.
How to I get the Calendar Control's date to display in the ClassDate field?
Thanks for the help.
Rick
View 4 Replies
View Related
Jul 25, 2006
Hi,
I have a form that has 2 Calendar Controls that is used to select a Start Date and an End Date. I then have some code that will enter all the dates inbetween into the database.
One thing I would like to have on the form, is when the users selects a date from each calendar. The date is displayed in a text box under it. Just to have a visual double check to make sure they selected the right month/day/year before they hit the submit button.
Anyone know what code I would need to put in my form to make it do this?
Thanks
Chris.
View 2 Replies
View Related
Mar 2, 2005
Please can someone advise me how I can link the date which I select in the calendar control to a date field in the form. I want to use the calendar instead of a combo box.
It's probably simple....but then so am I!
Help appreciated
Richard
View 11 Replies
View Related
Jun 17, 2005
I would like the calendar control to default to the current month and year (if there is no date in the control source). I don't want to set it to the current date.
I've tried:
Month([CalendarOut].Value) = Month(Date)
but that doesn't seem to work.
Any suggestions?
Thanks!
View 2 Replies
View Related
Aug 25, 2005
Hi
I'm recently added the CalendarControl 9.0 into some combo boxes in order to quickly input dates - however only the dates are then added, not the day of the week. The day of the week would be really useful if it was visible as the form is outputted to a HTML page for our intranet for other staff to see.
My (relevant) code at the moment is as follows:
-------------------------------------------------
Option Compare Database
Option Explicit
Dim cboOriginator As ComboBox
Private Sub cboStartDate_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single)
Set cboOriginator = cboStartDate
ocxCalendar.Visible = True
ocxCalendar.SetFocus
If Not IsNull(cboOriginator) Then
ocxCalendar.Value = cboOriginator.Value
Else
ocxCalendar.Value = Date
End If
End Sub
Private Sub cboEndDate_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single)
Set cboOriginator = cboEndDate
ocxCalendar.Visible = True
ocxCalendar.SetFocus
If Not IsNull(cboOriginator) Then
ocxCalendar.Value = cboOriginator.Value
Else
ocxCalendar.Value = Date
End If
End Sub
Private Sub Form_Load()
ocxCalendar.Visible = False
End Sub
Private Sub ocxCalendar_Click()
cboOriginator.Value = ocxCalendar.Value
cboOriginator.SetFocus
ocxCalendar.Visible = False
Set cboOriginator = Nothing
End Sub
-------------------------------------------
Any help and ideas much appreciated!
View 13 Replies
View Related
Apr 9, 2008
Hi,
I'm using the Microsoft Calendar Control 11 to populate a date field on a form. The date field has a format of "Medium". When I use the control, I select todays date and what gets populated is 30/12/1899. But...if I immediately go back to the Calendar control and select todays date, then the proper value gets added.
This happens for every NEW record I create. What is happening??
View 1 Replies
View Related
Jul 7, 2005
problem at info
HI ???
,,ALL,,
adjusting example sub date
Accessory Calendar Control Mimic
thanks
View 1 Replies
View Related
Feb 24, 2006
I have attached a condensed copy of my form/sub-form that has calendar controls on it for the RecvdDt and the Compliance date. I have it set up the say way as I have on other databases and it will not close/populate once opened. I have reset the events on it multiple times and I just can't get it to go.
Can anyone please take a quick look and help me determine why it is not working on this form yet works on others that I have.
Thanks.
View 5 Replies
View Related
Mar 10, 2006
Hi
I am trying miserably to help a student use the Calendar Control to Open and Go to a specific record
I want to click on a specific date in the calendar in a form eg 09/03/06 and then open the "Bookings" form and go to the record with the field "Date" with the value 09/03/06
I can open the form lol
Can anyone help??
Thanks
Sara
View 2 Replies
View Related
Jun 6, 2006
I am trying to use an unbound subform based on a query to display only records for a specific date. The query works fine on its own, but the subform returns a blank.
I am using the Calendar control on the same form for the user to select the date they wish to view. This in turn inserts the selected date from the calendar into a textbox on the main form and the query that the subform is based on reads this and opens the corresponding records.
Problem, its not working.
Thank you in advance if you can help me throw some light on this one.
View 1 Replies
View Related
Aug 7, 2006
I can't figure out how to further explain what i needed to do. I hope the attached file could solve my issue.
Thanks for your time!
Sheila
View 2 Replies
View Related
Oct 25, 2004
I want to be able to click on the date in a calendar control and the jobs scheduled for that day appear on the screen. Is this possible and how would I go about this. I created a query to pull the information I need and I attached that query to a form, I then placed the calendar control the form but I am unable to get the control to pull the data.
View 1 Replies
View Related
Mar 9, 2006
Hi All. I have a query that is based on 1 table. I am using a form with a calendar control for the users to select the date range. In my table the date format is mm/dd/yyyy. My calendar control is pulling the date format mm/dd/yyyy I need my query to only look at the mm/dd part of the field. In my criteria field inc_date I have Between [Forms]![frm_LookUpEnquiry]![txtSelectDate] And [Forms]![frm_LookUpEnquiry]![txtDate2] I have tried the datepart but Im not sure I am doing it right. Basicly Im not sure how to parse out the date to only look at the mm/dd. Or would this be better done in a SQL query Any Idea's for this would be very appreciated. Im kinda in a bind on this one and its the last thing I have to do to finish this database.
Thanks for all you assitance in advance
View 1 Replies
View Related
Aug 23, 2007
Hi All,
I'm in the process of creating a database that allows users to enter details into a form which includes a date range as start and end dates.
I have used the inbuilt Calendar Control 10.0 control to allow users to select the date. It is linked to two combo boxes [cmbStartDate] and [cmbEndDate] using the following code (this code is repeated for each combo box):
Code:
Private Sub cmbStartDate_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single)
Set cmbOriginator = cmbStartDate
ocxCalendar.Visible = True
ocxCalendar.SetFocus
If Not IsNull(cmbStartDate) Then
ocxCalendar.Value = cmbStartDate.Value
Else
ocxCalendar.Value = Date
End If
End Sub
And..
Private Sub ocxCalendar_Click()
''Update the ComboBox with the value entered into the ComboBox
''Put the value back into the relevant ComboBox
cmbOriginator.Value = ocxCalendar.Value
''Hide the calendar
cmbOriginator.SetFocus
ocxCalendar.Visible = False
''Clear the variable
Set cmbOriginator = Nothing
End Sub
This all seems to work fine- however, when I try to write the selected dates to a table or use them in a query they are not recognised (the form obviously needs to be open whilst the query runs), but if I manually type dates into these combo boxes these dates are picked up fine.
This is beginning to drive me mad so any help would be greatly appreciated.
Mark
View 7 Replies
View Related
May 31, 2006
Hi there,
I have used Calendar controls before but this is a new one on me?!
When i click on the Calendar, what i am doing is inserting the date clicked into a textbox on another form.
The Calendar is set to todays date the system date is also correct and although i click on 31/05/06, what is being inserted is 31/05/20 ?????
Any ideas, because i dont?
Thanks in advance
View 5 Replies
View Related
May 14, 2013
I want the calendar to show the date in the field [Next Payment Due] - whenever this value changes, the calendar date should change accordingly.
I want the calendar to be assigned to a text box (txtCalDate), so this would also contain the date of [Next Payment Due].
However, If the calendar date is changed (on the calendar), I want txtCalDate to show this date, but [Next Payment Due] to stay as it's original value. Next Payment Due can only change the value, but not be changed itself.
So I presume VBA would be needed to say when [Next Payment Due] is changed, make calendar this date. And then to simply assign the calendar to txtCalDate so if calendar is changed, this will change with the new date.
View 3 Replies
View Related
Feb 26, 2014
On the form I need to give the user the option to select a 'from date' and 'to date' and for this I have put in 2 calender controls which have the same control source(same table column). The problem I am facing is when I select a date from one calendar, the other calendar control automatically populates with the same date and vice versa.
I need to have a functionality where 2 different date can be selected and then when the Search button is clicked, then data within the date ranges should be displayed.
what changes I need to make to acomplish this ? find a screenshot of the form attached.
View 5 Replies
View Related
Jul 27, 2013
a couple of months ago i found a celndar control replacement that Microsoft kindly provided. i have made a few mods that allow me to change the day/week etc. i would now like to tell it to open on a certain date. the reason is that on each of my client records i have 'Future Appointments'. i would like to be able to select a future appointment and click a button that then opens a form that includes the calendar and go to the date of the future appointment. the calendar controls the diary. whatever date the calendar is on the diary matches. so to change to the date of the appointment i need to change the calendar date.
i tried the obvious first.
[Forms]![frmDiaryMultiView]![frmCalendar].Value=#01/01/2012#
that didnt work as the calendar does not seem to recognise it.
i am totally lost with this as i dont even understand most of the code that is behind the calendar, so i dont know what i am looking for to use to open it on a given date.
View 1 Replies
View Related
