Forms :: Month Calendar On Main Form?
Jun 11, 2013I want to display a month calendar on my db's main form.
View Replies
ADVERTISEMENT
Forms :: Calendar Scrolling Month By Month
Aug 9, 2013Using Access 2010..I have form with a date on it. For this control I have show date picker set to "For dates" and lo and behold I get calendar! I can scroll through this calendar month by month. Great if I just want to go back or forward a month or three. What I'd like to be able to do is scroll through the calendar year by year. Can I do this with the method I'm using at the moment? If not is there a way round it that isn't over complicated?
View 6 Replies View RelatedSet Month Only On Calendar Control
Jun 17, 2005I 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!
Sort By Calendar Month
Dec 5, 2006How do I setup a query so I can sort a report by calendar month?
View 2 Replies View RelatedQueries :: How To Determinate Which Day Of Month To Be In Calendar
Aug 17, 2015I have 31 checkbox to determinate which day of month to be in calendar with
Code : iif([01]=-1;cdate("01/" & [month] & "/2015");cdate("01/01/2001")
In the query to get date field to compare to paid date for that customer...
Now for list unpaid date I have all the customer who has date after today so I think about criteria >date() but I have all customer that have date before today and after today...
I need a new calculated filed with date in calendar checkbox to determinate the oldest date, do you have a better formula then this?
Code:
IIf([31]=-1;cdate("31/"& [month] & "/2015"; _
IIf([30]=-1;cdate("30/"& [month] & "/2015"; _
IIf([29]=-1;cdate("29/"& [month] & "/2015"; _
...........
...........
IIf([01]=-1;cdate("01/"& [month] & "/2015";"")))))))))))))))))))))))
Pull Month/Year/WeekDay From Calendar?
Mar 20, 2006I've looked and looked and am afraid that I didn't find this because it's not possible...
The forms in my db are not the clearest, but one way of simplifying it for the users is to have them click on the calendar icon and then have a few fields automatically populate with the selected date's month, another with the year, and another with the day of the week.
Is this possible? I figured out how to have a field populated with the date, but with all of the specific queries needed, I have to do it this way...
Any thoughts? Also, is it at all possible (this is totally separate) to have an icon on the desktop that brings up a login sheet for which the entry users only see the front end, but the db admins log in and see the back end?
Thanks in advance!!
E
Sort Query Results By Calendar Month
Jun 12, 2013I'm trying to sort my query results by the month value "Data (IMPORT).KP_MM_DS" but I get alphabetical results.
SELECT [Data (IMPORT)].KP_YR_NB, [Data (IMPORT)].KP_MM_DS, Round((Count([Data (IMPORT)].KP_ISSU_ID_NB)/20)) AS CountOfKP_ISSU_ID_NB, [Data (IMPORT)].KP_MM_DS
FROM ([Data (IMPORT)] LEFT JOIN [Facility Lookup] ON [Data (IMPORT)].KP_FAC_NM = [Facility Lookup].[FAC NAME]) LEFT JOIN DEPTLOOKUP ON [Data (IMPORT)].KP_DEPT_ORG_NM = DEPTLOOKUP.[EPM DEPARTMENT NAME]
WHERE ((([Facility Lookup].[REPORTING MCA])<>"XXX") AND (([Data (IMPORT)].KP_SB_RGN_CD)="N"))
GROUP BY [Data (IMPORT)].KP_YR_NB, [Data (IMPORT)].KP_MM_DS, [Data (IMPORT)].KP_MM_DS;
Forms :: Any Way To Have A Form That Looks Like A Calendar
Aug 28, 2014I'm creating a Database where I can track quotes, orders, customers, support/faults and products.Is there any way to have a Form that looks like a calendar.. ie this will link to my orders table and show what orders are due shipping on each day.
View 6 Replies View RelatedDatabase With A Main Menu Form Containing A Button That Loads Main Data Entry Form
Jun 24, 2015I have a database with a Main Menu Form, containing a Button that loads my main data entry form. When the Button is Clicked portions of the data entry form that is loading shows through the Main Form Background (e.g. portions of the navigation bars, and portions of the boarder on the form that is loading.)
View 5 Replies View RelatedForms :: Calendar Form To Count Attendance Of Employee
Aug 5, 2014I am trying to make a database for my employees to count their attendance according to the days of the month and then get their salary. How to create a form that show the days of the month and then i can add the names of the attending employees.
View 4 Replies View RelatedWhy Is Main Form Update Event Triggered When Subform Dirties Main Form?
Dec 1, 2005I have a subform which makes a change to a field on the main form. When focus is returned to the main form, the BeforeUpdate and AfterUpdate events fire. Why? I thought from the form's perspective, the subform is just another control.
BTW, I get the same behavior if I modify the field from within the Exit event of the subform control.
In either case, the main form's Dirty event is NOT triggered.
Forms :: Default Property / Using A Control Of Main Form Without Using Names Of Forms?
Nov 8, 2013In the default property of a subform control I want to use a control of the main form without using names of forms, but using me and parent.
I used in default property of cboVATDetail: =Me.Parent!cboVAT, but it is not accepted. My aim is to use cboVAT of parent as default in cboVATDetail of child.
Forms :: Relating Information Between Main Form And Navigation Forms
Apr 11, 2013New to the navigation form: I need several forms in the navigation form to all relate to the same client ID field. I have this information on the main form but the form with in the navigation form will not pick it up.
I have tried =[Forms]![Frm Client Information Navigation Panel]![ClientID] But just cant get it to pick up that information...
I would like to have something like the master link fields and, child link fields but when I add a form to the navigation form this option in not available.
Reports :: Custom Reports Creating Chart Based On Month Not Calendar Year
Jun 15, 2015I am editing a database that provides the option of creating custom reports, where the user can input a date range of their choice and receive aggregate data for that time frame. Although all of the numbers in the report are correct, I am having trouble with a chart that I inserted into the report.
Specifically, if the date range requested spans 2 calendar years (i.e. April 2014 through January 2015), the data for January 2015 appears at the beginning of the year (so the chart x-axis is for Jan through Dec, and the Jan 2015 data is showing up in Jan (as if it was 2014, not the end of the given range in 2015). When I try with smaller time frames within a calendar year, it adjusts just fine (i.e. shrinking the window so just March-May is displayed on the graph).
How to adjust the axis so that it properly records the data range- so that it would start the axis with April and end in January, for example?
Forms :: Open Blank Form Based On Value In Text Field In Main Form
Jun 6, 2013I have one table containing name of restaurant with its address etc. Then i created another table to list out the restaurant workers names and details. Just as an example,
Table:Restaurant
Restaurant name
Address line 1
Address line 2
Restaurant #
Website
Table:StaffContact
Staff Role
Name
speciality
email
phone
I have the main form that has all the restaurant details only. And i have another form containing the Staff information. Please note the two table have a relation and it works well.
Now to make it user friendly(basically easier for the lazy ones), I dragged the staff contact form on to my main form and displayed it as a datasheet(basically a sub form).
Now, my boss does not want users to add/delete on this sub form(datasheet). So,he wants me to create buttons to open new record of staff for each restaurant(new form)
My issue is with opening a new record to enter a new person to the staff list and give them a role as well in form view.The new form has
So i ran a Macro, with open form with Where condition
Code:
[Staffcontact]![Rest Name]=[Forms]![MainForm]![RestaurantName]
But, it does not work .
Main Form / Sub Forms
Oct 19, 2005I have a command button on a main form which on 'on click' enables a number of fields on the main form that were previously enabled = False to be enabled = True.
The problem is I also have a sub form within the main form where I want to do the same. (A number of fields within the subform are also set to false and I want them to go to True) I can set a seperate button up on the sub form to do the same but I would much prefer the button on the main form did the whole lot.
The problem is I haven't a clue to the VB of how to include fields within the subform as well as the ones on the main form.
For info the main form is called FrmTblMain and the sub form SubFrmProject
The fields on the subform that I wish to set to true are 'First' and 'Second'
Any help will be appreciated.
Forms :: Main Form Which Contains A Sub Form In Data Sheet View
Nov 28, 2013I have a main form (tsTimeSheetMain) which contains a sub form (tsTimeSheetDataNewSub) in data sheet view. When I click off one row onto another row in the sub form, it triggers this code:
Forms!tsTimeSheetMain!ProjectMonSum.Requery
i.e. it tries to requery the ProjectMonSum field (on the main form) which is a dsum calculated field. This works fine and updates the ProjectMonSum field (which dsums values from the same datasource as the subform.
However, this seems to put the cursor back to the top left field in the subform (datasheet view), rather than leave it in the field I click on (in the subform).
Why is this happening and what is a decent workaround this issue? I just want to update the calculated dsum field each time you update values in the subform.
Forms :: Send Data From Pop-up Form To Main Form (sub-sub Form)
Aug 27, 2014On the form: User enters first name, then last name. Upon updating the last name field, I would like another form to pop-up and display all the people with that same first name and last name that the user just entered.
On the pop-up form: All of the matching first names/last names are listed with a button control beside each record that says 'Select'. The user clicks the select button beside the record he/she wants. This pop-up form closes and all of the data from this selected record is now showing on the original form.
So far, I have a query/form that pops up only showing the matching first/last names. I'm having a hard time getting my original form to auto-populate with that record that the user selects on the pop-up.
(Also my main form is actually a sub-sub form - so in my trials I could've been massacring my syntax trying to point to it.)
Forms :: How To Get Main Form With Subform
Sep 27, 2013i have a main form for customers and a subform for sites which is set to locked so its displayed as just a list. I have a button on my main form to add a new site for the current customer displayed..How can i get the Main form '1CustomerDetails' with subform '2SiteList' to automatically refresh one i've clicked the save button on another form.
View 1 Replies View RelatedForms :: Navigation Form - Main Form Buttons
Nov 23, 2013So I have made all the necessary forms to start working with my Access, and now I need a main form, a home where I should put all the buttons to enter each form.I have used the Navigation Control on a New form URL...
A row with buttons appeared, and I complete the property: Navigation Target Name with the target form, but it is giving me some trouble with a searchForm and a Query. Every time I enter this form (using nav control), Query asks for an Input.
Forms :: Picking Up Sub Form Totals From A Main Form?
Mar 22, 2013I have converted an old Access 97 database to Access 2010. Mostly it works fine but I have a major issue with the invoicing forms. It was working in the old database but I cannot get it to work in this version.
I have the usual invoicing option where the lines of the invoice are displayed in a sub form for that customer and line totals calculated. This works fine. I have a sub form total text box in the footer of the sub form which I want to pick up from the main form so that I can add the delivery charge and VAT.
Forms :: Continuous Form Filter By Month Or Age
Feb 9, 2014I have a continuous Form named frmBirthdays that lists People with a [DateOfBirth] field.
In the Form Header I have 2 Unbound Combo Boxes 1- cboMonthFilter which list the 12 Months of the year in Text NOT Number and 2- CboAgeFilter that has a list of Ages 0 -30 (which is all i require) and a Clear Filter Command Button.
I would like to be able to filter the people list by cboMonthFilter for anyone that has a Birthday in any given month.
OR
I would also like to filter the people in the list by their age.
But never both at the same time.
Forms :: On Every 9 Or Monday Of Any Month Form Will Open
Dec 8, 2014I have 10 forms named
FormA - FormB ------ FormJ
I want to choose the formA and from a combo I want to choose a day so when this day come the chosen form will open automatically in the specified date when I open the database...
For example i choose FormA and for the date i choose 9 or monday
So every 9 of any month the form will open or every monday....
Forms :: Subform Does Not Associate With Main Form
Mar 15, 2013I have this form that contains subforms to hold different types of infomation for different clients. At the top of the form it has the case #, first name, last name, and then a tab element in which each of 6 pages (tabs) holds subforms for other information associated with the client.
I have a table that holds only client number and name.Then each of the six subforms operate off of a table, and all the tables are connected through relationships using client number, first name, and last name.
How could I make the subforms autofill their cooresponding tables using the case #, and name fields from the main form without having to repeatedly input the client #, names for each tab/subform?
Forms :: Connecting Main Form To A Subform?
Apr 21, 2015I have a form that shows information on a person (think first name and last name) at the top and contains tab controls that hold subforms each containing a different set of info about that particular person. Ex: for person 1 the main form will display the persons first and last name as well as show the subject tabs. as you click on each tab you should see the information that pertains to that person. I would like to step through each ppeson one at a time using the horizontal record arrows (eventually I will change this process to using forward and back buttons) on the main form with the persons names changing as well as the information in the subforms changing to match the person on the main form. I can step through each separately (main form and each subform) but I cant get the subforms to change information when the main form changes persons. Seems simple enough but I cant get the subform to change when the main form changes. They are not connected. This is for an Access class that I am taking and we use Access 2013.
View 2 Replies View RelatedForms :: Navigating To A Record In Main Form
Aug 10, 2013I have a form and a subform for data entry.It is often the case that not all the data may have been entered and so a user might need to go to recordID 24 in 30 already entered main records.However, he needs to get to that record via a (unique) 1-1 field. How do I create the form so that as well as being able to go to the first, the last, the next, the previous record, I can go to a record of my choice.
View 5 Replies View Related