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
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?
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!
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 :)
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.
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 ?
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.
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:
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)
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,
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.
I 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.
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.
