Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
Password Reminder
Register
Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old October 28th, 2003, 11:42 AM
Authorized User
 
Join Date: Jun 2003
Location: Birmingham, N/a, USA.
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?
Reply With Quote
  #2 (permalink)  
Old October 28th, 2003, 11:50 AM
sal sal is offline
Friend of Wrox
 
Join Date: Oct 2003
Location: Clarksville, TN, USA.
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
Reply With Quote
  #3 (permalink)  
Old October 28th, 2003, 12:09 PM
Authorized User
 
Join Date: Jun 2003
Location: Birmingham, N/a, USA.
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
Reply With Quote
  #4 (permalink)  
Old October 28th, 2003, 12:37 PM
sal sal is offline
Friend of Wrox
 
Join Date: Oct 2003
Location: Clarksville, TN, USA.
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
Reply With Quote
  #5 (permalink)  
Old October 28th, 2003, 02:32 PM
Authorized User
 
Join Date: Jun 2003
Location: Birmingham, N/a, USA.
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
Reply With Quote
  #6 (permalink)  
Old October 28th, 2003, 02:50 PM
Authorized User
 
Join Date: Jun 2003
Location: Birmingham, N/a, USA.
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
Reply With Quote
  #7 (permalink)  
Old October 28th, 2003, 05:47 PM
sal sal is offline
Friend of Wrox
 
Join Date: Oct 2003
Location: Clarksville, TN, USA.
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
Reply With Quote
  #8 (permalink)  
Old October 29th, 2003, 10:59 AM
Authorized User
 
Join Date: Jun 2003
Location: Birmingham, N/a, USA.
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.
Reply With Quote
  #9 (permalink)  
Old October 29th, 2003, 11:42 AM
sal sal is offline
Friend of Wrox
 
Join Date: Oct 2003
Location: Clarksville, TN, USA.
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
Reply With Quote
  #10 (permalink)  
Old October 29th, 2003, 12:13 PM
Authorized User
 
Join Date: Jun 2003
Location: Birmingham, N/a, USA.
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
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


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



All times are GMT -4. The time now is 12:15 AM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.