Wrox Programmer Forums
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old October 28th, 2003, 11:42 AM
Authorized User
 
Join Date: Jun 2003
Posts: 78
Thanks: 0
Thanked 0 Times in 0 Posts
Default Calender Controls


I have a question in reguard to an Access Database '2002', calender. I have several pieces of items in my department which are reserved on a note pad, and now I would like to have then done on a calender in Access where everyone can see the reservations without looking for the note book which has been lost a couple of times. We have department (X3) Laptops, LCD Projector, etc; so what I would like to do is have form which has the Calendar on it, and then when a date is clicked another form shows the hours in the day 12am to 12pm. Then the user can highlight the hours they want and type in what they have reserved. Thus other users can see what has been checked out, where it is being used and for how long.

Is this possible?
 
Old October 28th, 2003, 11:50 AM
sal sal is offline
Friend of Wrox
 
Join Date: Oct 2003
Posts: 702
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Use Microsoft Outlook for this task.

In Outlool you can make the Laptop a resource and schedule it just as you would schedule another person. When users create a new schedule for the resource, they will be able to see if it is available or not.

This can be done in Access, but I do not see the reason.

Do you have Outlook?



Sal
 
Old October 28th, 2003, 12:09 PM
Authorized User
 
Join Date: Jun 2003
Posts: 78
Thanks: 0
Thanked 0 Times in 0 Posts
Default

We do have outlook, but since it is used company wide, and another department did the what you suggested. Everyone in the company is able to view the equipment, and we would really like to keep the information in-house..

At first we wanted to do the work on(Frontpage 2000) HTML page but we needed an active server. So we now want to do it on Access, but have similiar functionality as 'Outlook'.

Thank you
 
Old October 28th, 2003, 12:37 PM
sal sal is offline
Friend of Wrox
 
Join Date: Oct 2003
Posts: 702
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Access will not show you your dates as a calendar. It can be done, but it takes a lot of coding and an expert coder to get this done.

All you will be able to do in Access without coding is to enter the dated and times on tables and somehow guess your way around. Outlook will show you if the dates/times overlap. Access will not.



Sal
 
Old October 28th, 2003, 02:32 PM
Authorized User
 
Join Date: Jun 2003
Posts: 78
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Do you have the code to enable the dates to be clicked and open a new form? I am having problems with that code......

Thank you
 
Old October 28th, 2003, 02:50 PM
Authorized User
 
Join Date: Jun 2003
Posts: 78
Thanks: 0
Thanked 0 Times in 0 Posts
Default

the calendar is of per the calender properties:

Class: MSCAL.Calender.7
OLE Class: Calender
 
Old October 28th, 2003, 05:47 PM
sal sal is offline
Friend of Wrox
 
Join Date: Oct 2003
Posts: 702
Thanks: 0
Thanked 0 Times in 0 Posts
Default

That calendar control only works as a date picker control. You can not set it to show multiple valued on it's dates.

You can call the value of the calendar

Me.Calendar0.Value

Is that what you are refering to?



Sal
 
Old October 29th, 2003, 10:59 AM
Authorized User
 
Join Date: Jun 2003
Posts: 78
Thanks: 0
Thanked 0 Times in 0 Posts
Default

:)

Actually, what I wanted to have the functionality to toggle between the calendar and anthoer form. So if I double clicked a date(Square in a month), I could open another form. So that I can view another form, with the calender in the back drop......

Hope you understand in what direction I am moving in here. I would like to take the date of the 'Square' I just double clicked and place it on the form I just opened.
 
Old October 29th, 2003, 11:42 AM
sal sal is offline
Friend of Wrox
 
Join Date: Oct 2003
Posts: 702
Thanks: 0
Thanked 0 Times in 0 Posts
Default

OK,
I have done this before.

________ ______
________| |______|
TextBox Button

The textbox is by default locked, the button opens a form that contains the Calendar control. When you select a value from the calendar control you set the textbox to the calendar value. The textbox can be bound to the table/field.

You can then create two additional textboxes for the Begin time and end time. on the same form.

There is not much code.

try this on the close event of the form containing the calendar

Private Sub Form_Close()
Forms![Form1].SetFocus
Forms![Form1]![Date].SetFocus
Forms![Form1]![Date].Text = Me.Calendar1.Value
End Sub






Sal
 
Old October 29th, 2003, 12:13 PM
Authorized User
 
Join Date: Jun 2003
Posts: 78
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Sorry you lost me!!

__________
1 |2 |
____|_____|

ok those are the 1st and 2nd buttons on the calender, how do I get the first to show on a textbox which I have on the same form. Only when I click on one of the dates?

_______
1stOct |
_______| Textbox1 on same form





Similar Threads
Thread Thread Starter Forum Replies Last Post
disply calender sharadavani6 Servlets 2 November 5th, 2007 06:14 AM
calender event chandrasekhar ASP.NET 2.0 Professional 1 April 16th, 2006 11:32 PM
calender crmpicco Classic ASP Basics 2 March 23rd, 2005 01:21 PM
MSCAL. Calender.7 Markyd Access 1 January 23rd, 2005 04:21 AM
Calender gmoney060 Classic ASP Basics 4 August 23rd, 2004 12:10 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.