Forms :: Calendar Scrolling Month By Month
Aug 9, 2013
Using 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 Replies
ADVERTISEMENT
Jun 11, 2013
I want to display a month calendar on my db's main form.
View 3 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
Dec 5, 2006
How do I setup a query so I can sort a report by calendar month?
View 2 Replies
View Related
Aug 17, 2015
I 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";"")))))))))))))))))))))))
View 3 Replies
View Related
Mar 20, 2006
I'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
View 5 Replies
View Related
Jun 12, 2013
I'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;
View 4 Replies
View Related
May 5, 2014
I am trying to create a database that will keep track of the orders placed for a given part number by month. Currently, my table houses the part number, and the ordered amount for the past three years by month (there are thirty-five columns for every part). My column headings are ORDER_MAY_2013, etc. I would like to set a query up that will look at the column headings and pull the amounts ordered for each part for the past twelve months. In other words, I have three years of data in my table. In my query, I just want one year. However, I don't want to have to rewrite the query every month so that it will pick up the new data. Is there a way to accomplish this?
Is there a better way to build this database? I thought about just have four columns in my table - PART_NUMBER, ORDER_MONTH, ORDER_YEAR, ORDER_AMOUNT. The only problem there, is that every part (there are about 450 parts) would have to be listed 35+ times. That seemed too redundant to me, so I built the table this way. However, now I am having trouble querying against it.
View 2 Replies
View Related
Mar 19, 2012
I have a MS access table with 12 numerical columns for 12 Months payments for our customer base.
I need to calculate variance of payments month on month and identify set of customers who have made huge payments.
View 10 Replies
View Related
Oct 18, 2005
I have a table full of dates of meetings through out the year...
Example
tMeetingDates
16th August 2005
18th September 2005
19th October 2005
23rd November
-----
i also have a report that i print out each month that has the date of the meeting on it... i currently edit the date manually.
I was wondering if there was a way to automate this facility, so that the report looked to the table of dates and looked for the current Months Date that is stored i the table.
i then want this date to be displayed in the Report.
So in this instance if i am running a report for tomorrows meeting being the 19th October it would display that date in the report....regardless of when i run the report...
Obviously if i run the report on the first of November because the month has changed it would then display the date of the November Meeting...
we only ever have one meeting a month!!!!
Please help
Andy
View 11 Replies
View Related
Oct 13, 2006
HiI have a field that is text which holds the month in form "oct" etc. I need to pass the numerical value of that month to a function so how do I create an expression that will change it (in this instance) to 09.kind regards in advance.peter
View 5 Replies
View Related
Jun 15, 2015
I 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?
View 2 Replies
View Related
May 17, 2005
please help me
i have a date field called open & i need to generate a query to count all entries by month, so far i can get all cases each day, but i'm unable to get the query to count them just based on the month & year..
any ideas please
View 2 Replies
View Related
May 9, 2013
I have a txt box on a form in which I type the month of the year e.g January, February etc. What I am having problems with is in another field I need to convert this month to it's corresponding value e.g. January will be 1, February will be 2 and so on.
View 14 Replies
View Related
Nov 21, 2005
I have a database set up with charts which plot information about support for "quality" purposes.
I have reports that work out the percentages but i would like to be able to take the percentage figure (say on the 1st of each month) and add it to a graph which will then be able to show the figures from the last 12 months so i can see how well the support is performing.
Any help would be greatly appreciated
View 3 Replies
View Related
May 11, 2006
Access 2000
I have an “unbound” form with a list box, a text box, and a combo box. The list box’s Row Source Type is a Query. The query’s criteria come from the textbox and a combo on the form. Once the information is entered into textbox and the combo box a macro is set to run on the combo box’s “On Change” event, which runs a Do Command Refresh Page. This expression [Forms]![Form46]![month] is an example of how I am setting the criteria in the query; which when I put the month “May” in the text box passes that information to the query’s design view “Month column. The combo also works the same way. What I need is to know what type of expression do I use so that I can use “All “ in the text box and combo box.
Thank You
Carbo
View 1 Replies
View Related
Jun 12, 2013
I want to add arrears(balance into next month arrears when i insert new month fees.
INSERT INTO Fees ( [GR No], Class, Tuition, FMonth, TMonth, [year], Transport,arrears)
SELECT [Fee Student].[GR No], [Fee Student].Class, [Fee Student].Tuition*2 AS Tuition, [fee insert].FMonth, [fee insert].TMonth, [fee insert].year, [Fee Student].Transport, Arrears
FROM [fee insert], [Fee Student];
For Example:
May-May: Total fees=10000 Paid=9000 Arrears = 0 Balance=1000
Jun-Jul: Total fees=10000 Paid=8000 Arrears = 1000 Balance=3000
Now want to insert that month and want to insert arrear with total fees.
Aug-Sep: Total fees=10000 Paid= Arrears = 3000 Balance=
Slight changes in that query:
INSERT INTO Fees ( [GR No], Class, Tuition, FMonth, TMonth, [year], Transport, Arrears )
SELECT [Fee Student].[GR No], [Fee Student].Class, [Fee Student].Tuition*2 AS Tuition, [fee insert].FMonth, [fee insert].TMonth, [fee insert].Year, [Fee Student].Transport, (admission+registration+security+annual+id+exam+st ationary+tuition+fees.transport)-paid AS Expr1
FROM [fee insert], Fees INNER JOIN [Fee Student] ON Fees.[GR No] = [Fee Student].[GR No];
View 3 Replies
View Related
May 4, 2015
I'd like the user to be able to search a subform only by month and year. We have lots of reports with different days, but none of them are pertinent to searching.
I don't mind if it looks a little bit messy (such as using the calendar drop down and it discounting the day) but I'd like to have it all in one box, preferably where the user can just select ex. 05/2013 and it would filter the subform, showing only reports from that month.
View 6 Replies
View Related
Mar 3, 2014
I have a table that records a list of dates using the first of the month in short date format (01/01/2011) and I have the following query
Code:
SELECT Format([dateworked],"mmm yyyy") AS Monthyear, Table_dateworked.dateworked
FROM Table_dateworked;
This query is the source for a combo box so it stores the actual date but the formatted date is visible.An additional complication (if it has to be) is that I have two combo boxes and I want to make sure the finish date is later than the start date, so I have a similar query which only returns later dates than the start date.
What I would like to do instead is to remove the combo box and to get the user to type in the month and the year in the "MMM YYYY" format, default the day to the first of the month and make it invisible.How difficult would this be? Would it be easier to enter the date in short format and change the format using the after update event?
View 3 Replies
View Related
May 7, 2013
im doing my ict unit 7 edexcel ict exam atm and as one of the tasks we have been asked to generate the testid. the test id consits the year a underscore and then the number of the month so for example if a test happened this year and this month the test id should be 2013_5. i can get the year and the underscore into the code to generate the testid but im not sure how to get the month to change to a number so for example if i select may from a drop down the code needs to take that and generate it into a number.
View 6 Replies
View Related
Jun 17, 2013
I am trying to develop a form in the light of budgeting, therefore, I am designing a form with all possible options being an accountant I can think (it just a try nothing else)
Now here's the scenario
Fiscal Year
Period
Month
Working days
Period - Month - working (are my heading)
1 - Jan - 22
2 - Feb - 18 and so on
This is what I am trying to learn, if I select period 1 "Jan", application/code fill -out remaining months automatically, e.g. Period 2 "Feb"; Period 3 "Mar" .....
and if I select Period 1 "Mar", then period 2 "Apr", Period 3 "May" ......
Currently, I am using combobox, but problem is, if I selection period 1 = "Jan", then I am unable to restrict period 2 using "JAN" as both combobox are separate.
View 1 Replies
View Related
Feb 9, 2014
I 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.
View 8 Replies
View Related
Jul 31, 2013
How to set first day of the current month as default value to a text box?
I managed to get current day minus 1 month using:
= DateAdd("m";-1;Date())
View 5 Replies
View Related
Aug 12, 2013
I need to create an "autonumber" field in the following format:
FYYMMXX
Where F is a constant, YY is the year, MM is the month, and XX is an incremented number. So for example, the first record in August of 2013 would be "F130801".
I've been checking other threads but haven't been able to follow them to a resolution. I think there is a way to do this within my form...
View 3 Replies
View Related
Dec 8, 2014
I 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....
View 3 Replies
View Related
Aug 4, 2015
I have an appointment database with, of course a Date field.I would like to be able to filter the records to show appointments for a particular month.I want to see what appointments I have for September, for example.Ideally I would like to populate a combo box with month names and filter the form based on the month selected.
View 4 Replies
View Related
