Hale, Jim
Jim.Hale at FleetPride.com
Mon Oct 31 15:51:15 CST 2005
These guys have VBA code that does what you want. As I recall it was about $299. http://www.datasphere.net/ "Looking for our Designer Series Access Components? To purchase products from our Designer Series of Access components, please call (360) 687-7347 or e-mail designer at datasphere.net " -----Original Message----- From: Boyd, Mark Thomas (US - Philadelphia) [mailto:mboyd at deloitte.com] Sent: Monday, October 31, 2005 3:02 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Calendar Control Thanks Bryan. I don't have ADH2K, and can't find anyting online that will allow me to do what I need. After much thought, I think I'd like to use a report to display the calendar of records. I can only find one resource from Google Groups (http://www.invisibleinc.com/divFiles.cfm?divDivID=4), but this link is no longer valid. Mark Boyd Senior Consultant Enterprise Risk Services Deloitte & Touche LLP Tel: +1 215 405 5576 mboyd at deloitte.com www.deloitte.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Bryan Carbonnell Sent: Monday, October 31, 2005 1:52 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Calendar Control On 31/10/05, Boyd, Mark Thomas (US - Philadelphia) <mboyd at deloitte.com> wrote: > I'm looking for an Outlook-style calendar control (month view) that will > work within Access. > I have a table with 2 fields, [WorkDate] and [WorkDesc]. > I need the calendar to display all [WorkDesc] data where the [WorkDate] > corresponds to the calendar date. For example, if the [WorkDate] is > today, the [WorkDesc] should appear on the calendar within today's date. > If tomorrow's date has records in the table, these records should appear > under tomorrow's date in the calendar. > > Is there a tool out there that will do this?? If you have the ADH2K there is a drop-in calendar form. It can be used as a standalone form or as a sub-form. I have used it as both in the same project and it works great. -- Bryan Carbonnell - carbonnb at gmail.com Life's journey is not to arrive at the grave safely in a well preserved body, but rather to skid in sideways, totally worn out, shouting "What a great ride!" -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com This message (including any attachments) contains confidential information intended for a specific individual and purpose, and is protected by law. If you are not the intended recipient, you should delete this message. Any disclosure, copying, or distribution of this message, or the taking of any action based on it, is strictly prohibited. [v.E.1] -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com *********************************************************************** The information transmitted is intended solely for the individual or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you have received this email in error please contact the sender and delete the material from any computer. As a recipient of this email, you are responsible for screening its contents and the contents of any attachments for the presence of viruses. No liability is accepted for any damages caused by any virus transmitted by this email.