DatePicker - Disable Any Past Dates On Calendar Popup
Apr 4, 2012Is 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 RepliesIs 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 Replies(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...?)
I cant figure this out...
i have a query that reports sales by week.. now on the date field in the query i have the following
<=[forms]![frmReportParameters]![DTPicker1] And >=DateAdd("d",-7,[forms]![frmReportParameters]![DTPicker1])
whick picks the date off a calendar on a form. Now this works 70% of the times. The issue is that "-7" because if i dont have sales every day of the week then it reports from the wrong week.
example;
if the week ends on friday and i run the report if i had sales every day that it reports sat-fri But if i had a day with no sales it will go one day further back so it reports fri-fri... the first friday belonging to the previous week??
anyone can tell me how to correct this?
thanks
I am looking at a DB I created a year or so ago... Trying to redo and correct a few problems. BUT.... I've used a popup calendar on this one... pops up from the dropdown on a text box. First, when I try to pick a date... an error happens and it closes the DB... prompts to make a backup and reopens the DB.... My problem is I CAN NOT get rid of this calendar!!! I put it in design view... delete the code... Still when I try to click on the little calendar... The same error happens. Has anyone ran into this before???I used the popup calendar from here... http://www.fontstuff.com/access/acctut09.htm
View 4 Replies View RelatedI'm told (via the non-helpful help system packaged with MsAccess) that the way to 'turn off' the helpful confirmation message related to an action query is under tools>Options>Edit/Find tab, and then uncheck the appropriate boxes.
I've done this. In fact, right now I have all three boxes unchecked which relate to confirmation messages (record changes, document changes, and action queries) - and I'm still having that same popup message every time I run the query, or have a report pull the query for me.
this wouldn't be more than just a hassle, except that one of the end users for this system isn't the most computer-savvy person in the whole world. In fact, I desperately need to "steve-proof" this system! I have this nightmare of being woken up at midnight because of this little glitch. any ideas how to disable that popup confirmation message for good??
I'm *finally* getting around to getting rid of the ActiveX calendar control in my application. After doing battle with references on other users' systems, the ocx references have finally lost the plot and don't work.
I've downloaded Allen's popup calendar but have a problem since the app uses text boxes, and I need to add the selected date into a table with date fields. Also, instead of clicking an icon (where his instructions say to put "=CalendarFor(SaleDate],...", in my previous code I just call the calendar form from the on click event when the user clicks the date field.
I've tried modifying Allen's code to no avail, and I'm afraid of really cocking things up in all my forms, tables, reports, etc. if I change all may table's date fields to text.
Could someone help me modify the code from text fields to dates? Alternatively, is there any other calendar popup out there that would suit? (I've looked at all of them in the links but haven't found anything.)
Thank you,
Christine
hi.. i have attached a simple db.. 1 table.. 2 fields..
jobdate and jobday
open the form and double click on the jobdate.. it opens a calendar.. when you choose a date it puts it into the jobdate field..
i have created a simple drop down underneath the jobdate with the days of the week..
is there a way to tweak the calendar module so it also chooses the job day.. because the days are clearly displayed along with the number dates.. so it must be possible..
here is the db in 2000 and 97 format..
thanks in advance.. i think this will benefit many users using this calendar
Is there a way to have a pop-up calendar with only a certain day of the week showing - such as all the Fridays only in the month?
View 5 Replies View RelatedIs it possible to have a pop-up from a textbox that has a calendar picker.
i.e. if you have a textbox formatted as a date field that has a calendar picker, that pops up every time you click in the box.
I would like a pop up to appear next to the date picker to say please ensure you do not select dates that fall on a public holiday!
I once saw a video online of a Memo field showing the times in which changes had been made to it.
I believe the instructor pressed a few keys when his mouse hovered over the Memo field and a pop-up with dates came up. I do not believe he used VBA.
I have a table linked to a form where I am able to change the values of my "Comments" field in my Source Table. I want to be able to see when changes were made (ie, new comments were added to my "Comments" field).
I created a pop-up that appears when i open my report so that I can automatically sort through the report by date. However, the report will only allow me to choose one date and i need to be able to choose multiple dates. This pop-up is connected to a list box which has the multi select turned on. How can choose multiple dates through my pop-up?
View 1 Replies View RelatedI 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?
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?
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?
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
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
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!
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 RelatedI have been looking for a way to sync a table holding reservation dates to MS outlook calendar automatically when dates are inserted in the table.
View 2 Replies View RelatedHi,
While searching for a free datepicker activex control I found the following control. It also allows null value. I found it quite useful and it's free
http://spazioinwind.libero.it/vbprogzone/activex/downloads/cal2.zip
regards
edit: copy the shortcut on a new browser otherwise it gives an error
Access 2007 - Win7
I have two textboxes in my form bounded respectively to check-in and check-out dates of my Hotel_Bookings table
When a user enters the check-in date, I'd like the date-picker of the check-out date to display the same month of the check-in date instead of the current month.
I know that the built-in date picker cannot be manipulated. I cannot work on check-out default value because it will not be updated on the current record.
The only way that I've found until now is to set the check out value to check in + [some days] but I do not like it because it could generate data entry mistakes
How can I solve? If there is no way to get the job done with the built-in date picker, what kind of ActiveX control could I use instead? And where to find it?
I have a form in which the user inputs crane inspection results (a series of check boxes). When the user clicks the save button, I would like to run a query (I guess a query is how to do this) that searches records for the past seven days (less weekends and holidays) and alerts the user to days that inspection results were not entered for that particular crane (cboCrane.Value) and that particular shift (cboShift.Value) via a message box.
How do I get it to only look at records for the past 7 days (less weekends and holidays)?
Any help will be greatly appreciated.
I have a query that returns a set of records which details stock items that are older than a date given in a form. However i need to limit the results to the number of items held in stock
i.e say i want to look at stock over 1 year old, i get a list of all the stockids, and the date added.
Say there is a stock level of 3 for a particular stockid the results should be limited to the first 3 records that are over 1 year old. Rather than the whole list of dates I get now.
Any help or direction with searching terms would be appreciated
thanks:confused:
I have a query that I need to always pull data from the newest past 3 months, so if this query were ran today it would take from months 2,3,4 (Feb, Mar, Apr). Any clue on how to do this?
View 14 Replies View RelatedI trying to create a query that just returns all of the records in my database for the past year. I've tried to somehow do it using the date() function but haven't had much luck yet.
Any help is most appreciated.
I have a combobox where users can select classes. In the AfterUpdate event for that combobox I have the following code:
Me.ClassCode = DLookup("[ClassCode]", "Classes", "[ClassID] = " & Me.ClassID.Column(0))
I want to populate the Class Code field based on the class they select. The code works fine except that the Class Code field does not update until after I tab past it. There is a field in between Classes and Class Code so I have to tab 3 times before the textbox populates. I expected the textbox to populate immediately after I selected the class. I also tried putting the code in the On Click event of the combobox but that didn't work either.
If I just keep clicking on different classes I'd like the class code to change each time without having to tab to another field. Is that possible? What am I doing wrong?
Rod