Popup Calendar, How To Choose The Day Aswell As The Date
Nov 30, 2006
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
View Replies
ADVERTISEMENT
Jul 26, 2013
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 Related
Nov 29, 2006
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 Related
Sep 12, 2005
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
View 14 Replies
View Related
May 5, 2015
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 Related
Mar 4, 2015
Is 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!
View 1 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
Sep 20, 2013
Using access 2010; i have a form that includes a date field. Is there a way to force the user to only choose a month end date? When the user clicks the date from the popup, they may use 9/1/2013 when the mgr. want them to use only 8/31/2013. I am thinking validation field to put a msg but want to be able to force it not the option.
View 2 Replies
View Related
Jul 5, 2005
I am setting up a database for a group of roll on roll off students. It would be really usefull if i recieved somesort of pop up message informing me 2 weeks before any particular student is due for release from the course. I have all their details plus their release date in a table. :confused:
Thanks in advance
View 1 Replies
View Related
Dec 9, 2013
Can a Form/Query warn when a date is approaching; like in a pop up or any other behaviour?
View 7 Replies
View Related
Jul 26, 2015
I have a form (Access 2010) in which i insert contracts; each contract has a start and an expiry date, but instead of dd/mm/yyyy i would like the user to be able to insert just the year, while the day and month are predefined values and they are automatically inserted (i.e. 01/10/yyyy; the year being the only value that changes, and it is manually inserted by the user).
I would like to set a pop up remainder (on form load) x days before the expiry date, but, because too many of them have the same expiry date i am wondering if the reminder can be set on different days, based on another field (i.e. partner location [country]).. i.e. reminder for contracts with Austria to pop up 60 days before expiring, for UK = 67 days and so on.. or even a specific day for each, i.e. for Austria = 01/08/yyyy, for UK 01/09/yyyy).
View 2 Replies
View Related
Aug 14, 2005
Cant figure out why Im having this problem.... Have a form with two calendars on it..... at the start I have this code
Private Sub Form_Load()
Calendar2.Today
Calendar3.Today
End Sub
And then for the text box on the calendar this........
Private Sub Calendar3_Click()
EndDate.Value = Calendar3.Value
EndDate.SetFocus
Calendar3.Visible = False
End Sub
Private Sub EndDate_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single)
Calendar3.Visible = True
Calendar3.SetFocus
If Not IsNull(StartDate) Then
Calendar3.Value = StartDate.Value
Else
Calendar3.Value = False
End If
End Sub
Now for some reason the calendar does not want to default to the current days date!!
Anyone see anything wrong?
Thanks
View 3 Replies
View Related
Feb 3, 2006
I have a form that has a date field. I have a button next to that field that opens another form that I've placed a calendar on. Is there a way to click on a date in the calendar and have it automatically insert the date into the date field on the previous form?
View 12 Replies
View Related
Mar 3, 2005
please help!
I have added a calendar into my site, I have a new table in my access database called: Cal
I want to ADD AN EVENT
The records I have in that table are:
eventID
eventTitle
eventDesc
eventDate
so I designed my ADD NEW EVENT form
my problem is:
what do I put in the form for eventDate (3 select form fields? Day/Month/Year?) it doesn't work??!
View 3 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
Nov 27, 2007
Hi All,
I know there are several examples of calendar date and time pickers about so I thought I would offer mine up for critique.
No modules, very little code, code used is simple and can be called from subforms as well as forms.
I used these forms in an application where the users find filling in date and times in the correct format difficult with limited keyboard skills.
If it can be improved let me know..... :)
Garry
PS I think the contributions Banana has been making to this forum are invaluable.
Keep up the good work.
View 5 Replies
View Related
May 4, 2005
Hi,
I have placed a calender object in Access 2003 on a form of mine and would like it to show the current date. Is there a way to set a default? IF it is code, where does it go?
View 2 Replies
View Related
Aug 7, 2005
I've run into some mysterious problem...
I use some bits from both of these calender examples
http://www.access-programmers.co.uk/forums/showthread.php?t=62606&highlight=calender
I mainly use the double-click version, but I've got two date fields (start and stop date) and use som ideas from the other for that.
When I use it in my form it works almost perfect. The only problem is when I double-click a date in the calender, to get it into the date field, the date won't update in the date field until I click another object in the form.
Why? Any ideas?
/Anttu
View 2 Replies
View Related
Dec 22, 2004
Hi all~
A database front end which was built by somebody else got handed to me to do some updates (as the person who created it is no longer with the company).
The database currently has roughly ~30 reports, about 15 of which are pulled daily, and the rest weekly/monthly. Part of the report criteria selected by the user are beginning and end dates. Currently the dates are input via text boxes on a form, then referenced by the SQL statement which generates the report data.
The users want the text boxes to be changed to either a drop down list or a calendar which they can just click on a date instead of typing it in. I know .NET provides controls for a built in calendar which you can use for date selection, but this database is simply an Access front end, so I cannot use .NET.
Is there an easy way to accomplish this via VBA?
View 1 Replies
View Related
Jun 1, 2013
I want to add a date from viewing the calendar. When I click on the date text box then want to see the calendar and I will choose the date and that date will appear in the text box.
View 7 Replies
View Related
Jan 7, 2015
I would like to put the calendar on my form so when I want to put the date in the calendar pops up. I have access 2013 but I am unable to locate it.
View 2 Replies
View Related
Mar 8, 2007
I have developed an Access database which keeps track of items we have received. What I want to do is enter a date in a field and then by clicking a button that date and the name of the item gets enetered into my Outlook calendar so that it will pop up a reminder on that date.
I have no idea if/how this can be done. Any ideas or examples very much appreciated.
View 2 Replies
View Related
Jul 23, 2013
How can i add date in textbox by simply selecting it from calendar?
View 2 Replies
View Related
Jul 3, 2013
I'm using access 2003 with the calendar control 11, this works fine for entering values control whose control source is a date field.
My problem is that now I'm trying to use the calendar to update the value of a unbound textbox and it will not allow me to enter any value other than the default value of the calendar.
I have to update the unbound textbox as I want to use a button later on to update the date field and include a confirmation message before entering to avoid accidental entering.
View 3 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
Oct 2, 2013
I have a database that has textfields / forms, what I would like to do is to add an option that when the textfield is clicked a calendar will appear and when the user selects the date in the calendar interface, it will insert the date for them.
How can I do this in MS Access?
View 2 Replies
View Related
