Select Range Of Dates With Calendar
Mar 19, 2006
I have a form and table which I use to collect some reservation information. I then have a subform/table which I use to enter the actual dates of for that reservation. This subform/table has only three fields. The foreign key field that links it to the main form/table, the date(s) entered and the subform/table autonumber primary key.
What I would like to do is use an ActiveX type of calendar as the subform and be able to select a range of dates. If someone is making a reservation for 8 days, I want to be able to select that range of days on the calendar and have create/enter all 8 of those records in the subform/table.
I would much prefer this as opposed to simply collecting a single IN date and a single OUT date.
Anybody have any ideas?
View Replies
ADVERTISEMENT
Mar 30, 2006
I am trying to build a form that accepts either a single date for start and stop dates whilst allowing a range of dates to be selected for operations that cover several days.
I am using the Access 2003 calendar which is fine for selecting a single date but how do I select several dates (4-7 Mar for example) ?
Thanks in advance
Oscar
View 2 Replies
View Related
Mar 17, 2008
I have a client that wants to enter a range of dates in a query of when they will call that person back. Then they want to be able to type in a range of dates and have a make table query show them all the people that fall in between these two dates....is this even possible???
Ex.
Joe March 3 to March 8
Mary March 4 to March 9
John March 5 to March 10
So if they type into the query March 3 to March 6 all three people should show up because one of the dates specified lies within the parameters they are asking for.....man I am out of ideas
Anyone.....
View 5 Replies
View Related
Apr 9, 2015
I have a table of records, which has within it two date fields (effectively, a 'start' and 'end' date for that particular record)
I now need to create a query to perform a calculation for each date between the 'start' date and the 'end' date
So the first step (as I see it anyway) is to try to create a query which will give me each date between the two reference dates, in the hope that I can then JOIN that onto another query to perform the necessary calculation for each of the returned dates.
Is there a way to do this?
So basically, if for a particular record, the 'start' date is 01-Apr-2015 and the 'end' date is 09-Apr-2015, can I produce a dataset of 9 records as follows :01-Apr-2015
02-Apr-2015
03-Apr-2015
04-Apr-2015
05-Apr-2015
06-Apr-2015
07-Apr-2015
08-Apr-2015
09-Apr-2015
(The *obvious* solution would be to create a separate table of dates, from which I could just SELECT DISTINCT <Date> Between #04/01/2015# And #04/09/2015# - but that seems like a dreadful waste of space, if that table is only required to generate the above? And it would have to cover all possible options; so it would either have to be massive, and contain every possible date - ever! - or maintained, adding new dates as necessary when they are required. Seems horribly inefficient!)
Is it possible to just select each date between the two reference dates? Or can you only query something which exists somewhere in a table?
View 4 Replies
View Related
Dec 28, 2005
I am totally new to Access and this is my first database.
I have a database for volunteers in which one table is basically a calendar. In this table I have fields for the month, day of the week (i.e Monday) and day of the month (i.e 21st). There is also a filed called "Special days"
Sometimes I may want to produce a report that selects only certain days such as Saturday, Sunday and other days marked as "special days". Another time I may also want to produce a report that selects other days.
At the moment I have a "test filed" in which I place a 1 for those days i want to select then I choose all those with a 1. This is obviously a very poor construction.
Can anyone offer me a more advanced method?
View 1 Replies
View Related
Dec 6, 2005
(I did serach for past topics, & found one, but the solution pointed to a link that doesn't work; sorry...)
I have a database (well, a half-database at the moment) which is used to book a hall. I want to add a calendar to the bookings form, so users can see what they're doing more easily.
This would only be useful, however, if I could grey-out days that have already been filled.
So is there any way I can do this?
(why do my topics here always have a http://www.access-programmers.co.uk/forums/images/icons/icon5.gif as the icon...?)
View 14 Replies
View Related
Nov 3, 2014
I have created a query that prompts the user for a start and an end date and proceeds with showing the data between those dates.
I was wondering if there was anyway that instead of the user typing in the dates, a calendar could pop up and they could pick the start and end dates instead?
If that isn't possible is there anything else that's simpler that I can do? Maybe like a list box for month, date, and year?
View 3 Replies
View Related
Sep 16, 2004
Before I waste a ton of time trying to do something that just isn't possible, can one of you tell me if the following is possible?
I have a database that I am using for appointments.
Is it possible to have a calendar control on a form that shows all of a person's appointments that occur during the month? For example, Joe has 3 appointments in april. Can I make the calendar show me all three dates (the appointment dates being depressed on the control) that he has appointments on? If so, can you tell me how? I can make it do one date, by making the row source the date scheduled field from the table.
Should I have seven different fields in one record for the appointments that could occur all seven days of the week?
KellyJo
View 2 Replies
View Related
Mar 24, 2006
As part of a larger issue, I am trying to figure out how to have an Access 2000 select query produce all dates in a date range into one field on the query. Assume at this point there are no tables in the query.
If 01/01/06 (mm/dd/yy) and 02/01/06 is used, then it'd list all the dates between those two, inclusive.
Is this even possible?
Thanks for looking.
View 3 Replies
View Related
Jun 21, 2006
I have a form bound to a table that has a bunch of dates in it. What I want to do, is to be able to have pop-up calendars on the form next to each date field, where the user can select dates from the calendar, then have those dates display on the form, and last but not least, update the date fields in the table.
At the moment, the form I'm working with let's me pick dates from little pop-ups and display the dates, but when I exit the form and then come back into it, the dates are gone! In other words, I'm missing something in the process between the dates displaying onthe form and the dates getting into my table.
If anyone has an idea as to what I might be doing wrong, I wouldappreciate your ideas and suggestions.
Thanks in advance. I don't know where I'd be without this forum!
View 11 Replies
View Related
Aug 28, 2012
Are there no arrays in Access? I am looking for a way to put sequential dates onto a calendar. An array would work fine, with an offset for Weekday(FirstDayOfMonth).
View 1 Replies
View Related
Feb 28, 2008
I need to attribute a value to records between a certain range, example
All records that the field "Date" is between 01/04/2007 and 31/03/2008 I need to return a value in a field named "Group" 2008 in my table.
Example:
12/02/2003 = 2003
15/03/2003 = 2003
15/04/2003 = 2004
20/08/2003 = 2004
17/12/2003 = 2004
20/02/2004 = 2004
01/04/2004 = 2005
View 5 Replies
View Related
Apr 4, 2012
Is there a way to ONLY allow users to select a date starting today or in the future using the DatePicker? I want to disable any past dates on the calendar popup.
View 2 Replies
View Related
Apr 11, 2013
My goal is that the user can choose start date and end date use the calendar implement in the userform, and then the VBA will automatically select the data range from access and updated into the defined worksheet in Excel. I managed to connect to access, just don't know how to implement the selection with the two date(the start date and end date).
Code:
Const strDb As String = "C:Documents and SettingsYuCMy DocumentsDatabase1.accdb"
Dim rs As ADODB.Recordset
Dim cn As ADODB.Connection
Dim strdate As String
Dim endate As String
[code]....
View 2 Replies
View Related
Oct 10, 2005
My dates are stored as numbers (long integers), because they need to be in the form YYYYMMDD, and I couldn't figure out how to enter them and keep them in that format as Date/Time.
Anyhow, I have a form with a textbox and a button. When the user enters in a date range, I need totals to show up for only dates that are in-between and/or equal to the date(s) typed in the textbox.
For example when the user types in 20050904-20051004, and pushes the button, a display of totals will be displayed for only those dates and those in-between. If the user leaves the textbox blank, and pushes the button, I want totals from all dates to be shown.
As you may know from my previous question, I am a relative newbie to Access. Suggestions about how to do this maybe even how to derive and present the totals, and especially specific code will be very helpful and VERY much appreciated.
View 6 Replies
View Related
Jul 12, 2005
I need to print out a report from a start to end date. But theres a catch i also need to print those items from previous months that are not yet resolved. I have a checkbox that tells me if the record has been resolved or not. Is there a way that I can put both the conditions into my query, one for the dates of transactions and the other being all outstanding items no matter what the date.
View 2 Replies
View Related
Nov 19, 2007
Is it possib;e to create a query that would all the dates withn a range of Date1 and Date ?
Ex if I have
Filed Date1 Date2
x 1/1/07 1/3/07
c 1/6/7 1/8/7
for query to show
Field Date
x 1/1/7
x 1/2/7
x 1/3/7
c 1/6/7
c 1/7/7
c 1/8/7
View 1 Replies
View Related
Jun 20, 2014
I want to create a form that ask the user for a start date and an end date. Then when the click OK it will append a record to a table for each date and each date in between based on the increment. For example the start date is 6/20/2014 and the end date is 6/27/2014 and the increment will be 1 day. I want to add records to my table for:
6/20/2014
6/21/2014
6/22/2014
6/23/2014
6/24/2014
6/25/2014
6/26/2014
6/27/2014
I have the form setup to to prompt for the start and end dates. It's the VBA coding to do the dateadd function in a loop
View 3 Replies
View Related
Sep 1, 2005
Is there a statement that will allow me to select a range of records in the
middle of a selection of records? e.g. Rather than TOP 10, can I get like
records 10-20, or 50-65 etc?
Prodigy.
View 5 Replies
View Related
Aug 28, 2007
hi, how do I select my data where the date is beyond the date range specified? For instance, I wan to select all the rows except the rows that are between 3/22/2005 to 10/17/2005. Is it possible to select the query? I tried the condition 'where date < #3/22/2005# and date > #10/17/2005#', but it return no rows at all. Does anyone knows how to do smth lidat??
View 14 Replies
View Related
Mar 2, 2008
I have a table with a numeric primary key field. Is it possible to create a select statement which returns a list of the records with the same whole number??
E.g
144.2
144.4
144.5
144.7
144.8
144.9
I need this as the Rowsource for a combo-box. Are there wildcards that I could use??
View 7 Replies
View Related
May 26, 2005
I am tring to add a number of years to a dob. I'm doing this by adding my
date+years*365.26 I get a string of numbers. I then convert the number in
the next column to actual date again. I'm getting the correct date. I've tried unsuccesfully to use the dateadd function.Now I want my criteria on that column to allow me to return only date in a given to from period of my choosing. I want to determine the date range each time I run the query.
An example would be:
DOB age date I need to follow up
5/15/1935 + 75 = 5/15/2005
Then I request dates between 4/1/05 and 5/30/05 and this date is returned.
I've tried the between_and functions but nothing is returned. I'm guessing it's because the column is still a calculation and not a true date.
I've tried: Adding a column to my query to convert the number string back to
date format (criteria failed to return a result). Adding a second column
that ='s my converted number to date column (criteria failed to return a
result)
And I've tried the make table query and then run another query from the new table. I can't seemto make this happen. I think it's not recognizing my data as a date because it isn't returning any data.
Is ther an easier way to: Add a number of years to a date and have it return
a date and not the number string?
If not is there a better way to convert the string to a date?
Is there a way to get my criteria to recognize the date and return date
between my begin and end dates?
Thanks
View 14 Replies
View Related
Apr 18, 2007
4/11/2007 1:01:28 AM
4/12/2007 2:02:52 AM
4/13/2007 4:21:30 AM
4/14/2007 2:22:21 AM
4/15/2007 3:34:53 AM
4/16/2007 4:02:37 AM
4/17/2007 5:03:15 AM
4/18/2007 7:17:34 AM
I need some helps
I have a table with date + time, how can I query so that it retrieve a 7 days range from today and go back ti 7 days
i though this should work (it works if the the table has date only no time)
Between Date() And DateAdd("d",-7,Date())
thanks
View 2 Replies
View Related
Oct 9, 2013
I have a query and I want to make a certain range of dates for the query to run. For example: from 10/6 to 10/7. What would be a parameter for this range of date? Should I put it on a query?
View 11 Replies
View Related
Dec 12, 2007
Hi all, I need to extract in a query a recent range of records, these records should be all before a certain date and all the following future records example:
if today date is 12/12/2007 I need to extract all records that are dated from the 1st of november and all the records that come after the 12/12/2007.
In the criteria I have set "Date()" what else should I be adding to get the range mentioned above?
Thanks
View 5 Replies
View Related
Jun 7, 2013
I am using Between Me.Firstdate and Me.Lastdate in a query. I thought that it would include both Firstdate and Lastdate in the range. But it appears that it does not. Is there a way to include Firstdate and Lastdate in the range of dates?
View 13 Replies
View Related
