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 RepliesI 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 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 RelatedHi,
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
Hi
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 :)
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?
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 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
Any way to have a form with Dates as column headers to update a table where the dates are stored in rows???
The table set up is like this:
tblOpHdr
DiaryID (PK) - OpDate (Date)
tblOpDetail
DiaryID (FK) - CostCode - MachineNumber - MachineHours - etc
I'm just wondering if there's any way I can do this with a datasheet or a crosstab type setup?
It's Access 2010.
I have built a query to calculate the expiry dates of training courses but I am trying to input a criteria so that only dates within 90 days of todays date show. I am using Date()<90 but it doesn't return the correct information. What the criteria should be for this?
View 1 Replies View RelatedI 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.....
I have a report that once clicked a form comes up to choose the dates one would like to filter by. It has a Start Date and End Date. After the user picks the Start Date and End Date the report will be shown for those dates. The record source for this report is a query
I wanted to use this same date picker form for another report. I included the same expression into my query but I keep getting an error.
Field: Expr2: [LogDate] Between [forms]![frmWhatDatesWorkLog].[txtRecvStart] And [forms]![frmWhatDatesWorkLog].[txtRecvEnd] Or [forms]![frmWhatDatesWorkLog].[txtRecvStart] Is Null Or [forms]![frmWhatDatesWorkLog].[txtRecvEnd] Is Null
Criteria: True
When I tried that I get the following error: "The Microsoft Jet database engine does not recognize '[forms]![frmWhatDatesWorkLog].[txtRecvStart]' as a valid field name or expression.
I don't know why I get this because I use the exact same thing in the other query and it works perfectly fine.
Any suggestions?
Hi All
This is pretty urgent so your help would be greatly appreciated! I need to do a query where i can find companies who were telemarketed between the dates of 01/01/2006 and 31/02/2006. When i type this in the criteria box however, it fails to do anything. PLEASE HELP!!!
Many thanks
I am trying to create a query in Access to select records from a table depending on the value in a Date field.
I need the query to select records which have dates between or equal to 01/09/last_year and 31/07/this_year.
Can anyone advise how I can do this?
Thanks in advance if you can help.
Gary
Hi all...
I have two queries feeding into one query that gives me a desired result. However I need it to do this..
Right now is show everything that has an incident On 07/04/2006 ( #07/04/2006# ) and before.. that part works.... What I would like it to show is if it has a hit for any 07/04/YEAR..... so if there is an incident for 07/04/2005 and an incident for 07/03/2004 show me...
Right now all of my dates look like this in the criteria section of the queries:
(one query looks for same locations on 7/4/2006, one query looks for that same location on or before 7/4/2006 and the last one tells me if there are any matchs)
q1= #7/4/2006#
q2= <=#7/4/2006#
q3= <=#7/4/2006#
How do I show for any year??
R~
Hi there,
I'm making a database for a small library collection. I want to make a query for all overdue books, so if the Date which the book is due has passed, it will come up in the query. What do I put beneath the 'Date due' field?
So If 1 day has passed that date, it will be overdue.
Thanks for any help.