Using Access 03....
I created a form with a calender on it [frmCalender].
I placed a command button on my parent form, next to the date field [request_date]
How do I link whatever date I click on (in the calender) to appear in the [request_date] field?
Using Access 03....
I know this seems noobish. But I've never used the calender before now. So while I know how to make one...
I created a form with a calender on it [frmCalender].
I placed a command button on my parent form, next to the date field [request_date] to open the [frmCalender]
How do I link whatever date I click on (in the calender) to appear in the [request_date] field?
hi can anyone help, im trying to insert a calender to an access database but i cant assingh it to a command button, when i go to form view it is larger than life insted of an icon can anyone please help.
View 2 Replies View RelatedI am using the calender control 11.0. By this calender I can only set the date year, month and day. I can not set the clock time:Hours, minutes and seconds. Is there a calender that enables me to set the date in the format:dd-mm-yyyy HH:MM:SS, means day,month,year Hour:Minutes:Seconds.
Grateful
I am not a professional programer but would like to do a simple database for my group to track research progress. Is that possible to "pick up a date from drop down calendar" then the date will input to the cell (save in table) in a form, instead of typing it in? I saw that in lots of web sites, but can not figure it out how to do it in Access. Tried "Canendar Contol" and "LANDesk Data control" in the toolbox.
Thank in advance
PK
Access 2007
In a table I have 2 fields:
D1 , Date/Time , DefaultValue: Date()
D2 , Date/Time , DefaultValue: Date()+1
In a form (bounded to this table) I have, of course, 2 controls bounded to this fields:
txtD1 and txtD2
If the user change the value in txtD1 (using the Date picker) I like to change the DefaultValue for txtD1 to the new date and the DefaultValue for txtD2 to the new date + 1 day. Something like this:
Code:
Private Sub txtD1_AfterUpdate()
Me.txtD1.DefaultValue = Me.txtD1
Me.txtD2.DefaultValue = Me.txtD1 + 1 day
End Sub
I tried whatever crossed my mind... with the same "result" : #Name?
My Regional settings:
Short date format: dd.MM.yyyy
Date separator: Dot
Simple: 05.12.2013
I'm trying to pull a date from a table into a text box on a form tab control using DLookup and I just can't figure out what is wrong with my DLookup expression:
=DLookUp("DateOrdered","tDateOrdered","PrNumber=" & [PrNumber]) ----- (DateOrdered is short date, PrNumber is text, db is split Access 2013)
Whats missing in this expression? I've tried every criteria variant I could find but to no avail.
I have table that I had to add a new field to which we update with a form. I tried to add a control for the new field but the field does not show up in the list for the control source. I am trying to add a list box to the form with a blank and 5 options.
I have attached screen shots of the table design and the form. The table has the field in datasheet view and I have manually entered a few entries in it but it still will not show in the control source for the form control. The top section of the form is where we enter and select the data for the new records. The bottom section (circled in red) autofills the matching record, from separate tables, for updating with the new entries.
I have added form controls for modified fields in the past so I am confused about why this is happening.
I was looking through some of the stuff access has to offer when I came across the calender control. I really like its set up and what I would like to do is create a switchboard to link to the calender then have the user click on the correct date. I need the date clicked to create a table based on the date. I click 2/5/5 the table is labeled 2/5/5. If possable, after the date is clicked I need a form to open for inputing numbers and i want those numbers going into the table based on the clicked date. This possable?
Thanks
Chris :rolleyes:
Hi all
in the attachment there is two pictures for a form with interesting calendar to chose DOB
any one know how to do something like it
Thx
Hi, i am fairly new here, but i am building a database to hold bookings,
therefore i need a calender which wen dates are selected will display that days bookings,
If anyone has any ideas! can you please let me know ASAP!
Thanks
Tom
the calender form Input_2000.zip is quite useful. how can i modify its frmInputBox to have two text fields to enter numbers only?
After entering numbers in the text fields, the two numbers will be shown inside frmCalender box. perhaps can enter the numbers directly into the calender instead of using the frm InputBox.
anyone can help me to modify the Input_2000.zip into something like this: qp.jpg (see attachment)
Hi,
Im new to the Forum.
Ive been learning Access on my own and I have this calender that I am not sure how to get up and running.
Basically I have my switchboard with an area for buttons on one side and a calender on the right. The calender is built into a Tab section where I am wanting to be able to tab back and forth between a calender that shows daily work orders or jobs etc, and a form that lets me look at jobs individually.
Its prolly alot easier to understand if you see it so I will just attach the file.
My problem is I dont know how to code out the calender so that I am able to click on a day and enter either text or code depending on what I want to be displayed.
**EDIT**
Sorry,
Im using Office 02.
THats prolly need to know info :)
Thx in advance for any help you can give,
Meat
Hi,
Im new to the Forum.
Ive been learning Access on my own and I have this calender that I am not sure how to get up and running.
Basically I have my switchboard with an area for buttons on one side and a calender on the right. The calender is built into a Tab section where I am wanting to be able to tab back and forth between a calender that shows daily work orders or jobs etc, and a form that lets me look at jobs individually.
My problem is I dont know how to code out the calender so that I am able to click on a day and enter either text or code depending on what I want to be displayed.
Im using Office 02.
THats prolly need to know info
Thx in advance for any help you can give,
Meat
I`m using a calender to pick a start date and end date shown in two combo boxes. I can store this value in a table with fields StartDate and EndDate I want the user to be able to pick the dates and show query records between these dates I thought i could use something like - Between"StartDate","tblDate" And" EndDate","tblDate" but it brings a syntax error anyone help ?
View 1 Replies View RelatedHi
I have a form pop up calendar that returns the date in a date field on a form. This was a free popup and is activated by a double click which issues the command popupcalendar(screen.ActiveControl). I select the date from the calendar form and this date does update the correct filed with the date value I selected. What I have been trying to do is also display the day of the week which I can get using the vb weekday function. This all works well if I put the code in the on exit event of my date field and then use tab or any other way to exit the field. However I would like to be able to automate the process so that when I returne from the popup calendar the day field is updated at the same time. I have tried all the event options of my date field but do not get any changes to my day field. If a field is updated using VB does this disabe these events. Any help wpould be great.
I was wondering if anyone has seen a easy way to use a calender to select records rather than having to type in a "between such and such a date".
Because what i have now is a qry that pulls data from a table between two dates. And i would like to make it more GUI rather than typing to prevent user imput error if you understand what i mean.
I tried searching but didnt know what to search for.
Thanks for anyone that has any input!
Regards,
Jon
my departments seems to want to add some sort of notification feature to our database. It's supposed to notify the department when a certain date is approaching.
How do you even begin to think about adding this feature into Access? I don't know where to start. I'm no Access guru. :confused:
Hello guys
Here i am again with another problem. I have date field in my table (MyDate) and used that in form. I downloaded PopupCalendar file, which, i saw here in this discussion forum.
i had implemented all properties of 'Text3' of "Frm Trial" form in popupCalendar.mdb. Now when i run 'zsformCalender' form, i am getting message
Compile Error:
Can't fine project or library
and the error is highlighting - intDayToday = DatePart("d", Date)
please help me howto resolve this problem
Thanks :)
Im Making a Room Booking System for Our Meeting room,
there is only one room, so its easy to use the Calender(MSCAL.Calendar.7)value to pull a query for whats happening on anyone day, this also allows to add new entries,
my problem is Ive writting it in MSA2003,
and my main user is in 2000, when she opens the form with the calender on it the fonts are all reset to 1.5 in size,
and this is not useable,
has anyone seen this before or had something similar,
I thought Id just use VBA to reset the font sizes in the Form_open routine, but I cannot get VB to Access those properties of the calender,
so Im a little Stumped.
I'm using access 2007 and have some date fields in my forms, i'd like to be able to blank out weekends and public holidays from the calender/date selector in these fields so theres no way those dates can be selected. Is this possible? Thanks.
View 1 Replies View RelatedI am building an Access database for a client. It is an employee staffing database. With that being said they would like the ability to automatically populate the "T2PPCD" date field based on what is entered into the "Report Date" field. (Same table)
The date is the Monday after 180 days from the report date.
I already know how to get it to auto fill 180 days from the "Report Date" but I'm not sure how to tell it to give me the Monday after 180 days.
I'm trying to get my "IncidentDate" field to autopopulate two other date fields to a few days from the "IncidentDate". The other two date fields are "ContainDueDate" and "RootDueDate". I'm trying to accomplish this on my "Test CAP Form"
I tried using the following in the BeforeUpdate of "ContainDueDate" and received a complier error: expected =
Code : DateAdd(d,2,[IncidentDate])
so I removed the parenthesis and nothing happened
Code : DateAdd d,2,[IncidentDate]
I even tried redoing it in the AfterUpdate of "IncidentDate" and nothing happened either
Code : DateAdd d,2,[ContainDueDate]
I'm not sure if I'm even using the right function to get what I want.
Hey,
I'm trying to get the calendar control 10 to default to today's date when the form is loaded. I searched on it and came up with instructions to place the "Calendarcontrolname.Today" on the form load event, but its not working out. It saves the date that the control was added.
Can anyone shed some light?
Thanks!
I've inherited a database into which the user (not me) is entering essentially the same Date data twice: field 1 contains 6/19/2014 and for field 2 they enter June-14 (the month and year from field 1).
I suspect there should be a way to derive and then reformat the display of field 2 based on the contents of field 1, such that the user only has to enter the first. Is this true? If so, how?
(I know there really is no need for the 2nd field, but existing reports and queries are built around it -- so for right now, I'm just trying to eliminate the duplicate data entry)...
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!