If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Access Calendar
I am trying to create a calendar in access similar to the one used in Outlook. I want it to pull the information from the database for scheduling of the crews. Is this possible? if not is there anyway to creat any type of calendar from the database? If this can be done without using code great if I have to use code then I will try it. I am not thta good with programming languages. Thanks for the help.
|
#2
|
|||
|
|||
Access Calendar
Hi,
Using the calendar control in Access Access provides a calendar control that you can place on a form (form: An Access database object on which you place controls for taking actions or for entering, displaying, and editing data in fields.), report (report: An Access database object that prints information that is formatted and organized according to your specifications. Examples of reports are sales summaries, phone lists, and mailing labels.), or data access page (data access page: A Web page designed for viewing and working with data from the Internet or an intranet. Its data is typically stored in an Access database.). You can use the control to display or enter a specific date. The following illustration shows a form that uses the calendar control to display and accept a new employee's hire date. As you can see, a calendar control looks different from regular Access controls, such as a text box or a combo box. A calendar control is an ActiveX control (ActiveX control: A control, such as a check box or button that offers options to users or runs macros or scripts that automate a task. You can write macros for the control in Microsoft Visual Basic for Applications or scripts in Microsoft Script Editor.), and has a custom behavior that you can manipulate by setting its properties. In the form illustrated above, you can specify a date by selecting a month and year in the combo boxes at the top of the control, and then clicking the box corresponding to the day portion of the date. When you click outside the calendar, the Hire Date text box is updated with the date you specified. Adding a calendar control to a form, report, or data access page Open a form, report, or data access page in Design view (Design view: A window that shows the design of these database objects: tables, queries, forms, reports, macros, and data access pages. In Design view, you can create new database objects and modify the design of existing ones.). Click the More Controls tool in the toolbox (toolbox: A set of tools that is available in Design view to add controls to a form, report, or data access page. The toolset available in page Design view is different from the toolset available in form and report Design view.), and then click Calendar Control 11.0 in the list. Security Use caution when you are adding ActiveX controls to your Web page. ActiveX controls may be designed in such a way that their use could pose a security risk. We recommend that you use controls from trusted sources only. On the form, report, or data access page, click where you want to place the control. You can move or resize the control the same way you do other controls. You can change the appearance and other attributes in the control's property sheet. To display the property sheet, select the control and press F4. For help on a specific property, click the property, and press F1. Some key properties are Name, ControlSource, Value, Day, Month, FirstDay, and so on. The calendar control includes a set of reference topics that describe each of the properties, methods, and events of the control. The reference also includes several examples. To display the reference topics, click the Day property on the Other tab, press F1, and then click Help Topics on the toolbar. Using the calendar control to display and accept the values in a date/time field The Value property of the calendar control stores the date that is currently displayed in the calendar. This is the property that you set after getting a user specifies a new value. Note If you want to get or change a portion of the selected date, such as the day, month, or year, use the Day, Month, and Year properties of the calendar control. However, you can bypass these properties if you are using the calendar control to display and accept values for a date/time field in a table. In this case, you can simply set the ControlSource property of the calendar control to the field's name, and the calendar control will act like any other bound control: It will display the contents of the field for each record, and will automatically update the field when the user changes the selected date in the calendar. Displaying the values in a date/time field using a calendar As an example, you may want the calendar control on the Employees form to show the hire date of each employee as you navigate through the records. To do this, bind the calendar control to the HireDate field. When the user enters a hire date for a new employee by using the calendar control, Access will update the HireDate field in the Employees table. In Design view, select the calendar control and press F4 to display its property sheet. On the Data tab, set the ControlSource property to the name of the date/time field. If you want the calendar control and a text box control to display the contents of a field, make sure that the ControlSource property of both controls is set to the name of the underlying field. The user can then view and enter the date with either of the controls— the values in the controls and the underlying field will automatically be updated when the user leaves the record. Note Though you do not need to set or get the Value property when a calendar control is bound to a field, the property is internally kept up to date. If you are writing Visual Basic for Applications (VBA) code to manipulate a bound calendar control, you can set or get the Value property to update or read the field value of the current record. The Day, Month, and Year properties are also automatically updated. Manipulating the calendar control programmatically Often, an unbound calendar control requires you to write code to manipulate it. For example, you may want to use calendars on a form to accept a date range from the user. The date range is then used to limit the results of a query. In this case, the default values do not come from an underlying table, and the dates entered by the user are not stored in the database. For more examples and help on how to write VBA code for the calendar control, see the Calendar Control Reference Help topics. To display the reference topics, in the calendar control's property sheet, click the Day property, and press F1. Then click Help Topics on the toolbar. If you want to add clock functionality to a form that will allow users to enter time values by using a clock control instead of typing in a text box, see the topic Add clock control functionality to a form in Access. For Further Information: http://office.microsoft.com/assistan...011210601033&C TT=1&Origin=EC790000701033&QueryID=0uh5EmWyS0&Quer y=createing+a+calendar+in+ access+2003&Scope=TC%2cHP%2cHA%2cRC%2cFX%2cES%2cEP %2cDC%2cXT Thank You... Raghu... This posting is provided "AS IS" with no warranties, and confers no rights. |
#3
|
|||
|
|||
Access Calendar
"lost" wrote:
I am trying to create a calendar in access similar to the one used in Outlook. I want it to pull the information from the database for scheduling of the crews. Is this possible? if not is there anyway to creat any type of calendar from the database? If this can be done without using code great if I have to use code then I will try it. I am not thta good with programming languages. See the Calendar Tips page at my website http://www.granite.ab.ca/access/calendars.htm There could, likely will, be lots of version problems when you go to distribute the MSCal.OCX.. One alternative is MonthCalendar is a completely API generated Month Calendar derived directly from the Common Control DLL. There are links to several downloadable calendar forms at my website. As these are forms you can also do anything with them you want. You can also use the calendar form which comes in the Access insert your version here Developers Handbook by Litwin/Getz/Gilbert, publisher Sybex www.developershandbook.com. These books are well worth spending money. Every time I open one I save the price of the book. Tony -- Tony Toews, Microsoft Access MVP Please respond only in the newsgroups so that others can read the entire thread of messages. Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
AfterUpdate event of Calendar Control in Access 2000 not firing as expected? | Gary | Using Forms | 3 | July 2nd, 2004 07:53 PM |
Access 2003 | RK | General Discussion | 12 | June 14th, 2004 10:16 AM |
Calendar Web App w/ Access | Justin M. Keyes | Using Forms | 2 | June 3rd, 2004 10:40 PM |
Access or Share one OutLook calendar on Home Wireless Lan | Jim Wood | Calendar | 2 | May 8th, 2004 09:48 PM |
Calendar Control crashes Access 97 | George Avery | New Users | 0 | May 7th, 2004 10:33 AM |