Microsoft Access Help
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
User Name:
Password:
Remember me
Go Back   ASP Free Forums > Database > Microsoft Access Help
Reload this Page

Calendars

Discuss Calendars in the Microsoft Access Help forum on ASP Free.
Calendars Microsoft Access forum discussing questions and answers for the Access database. MS Access is used to handle small to medium database needs.

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
« Previous Thread | Next Thread »  
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread ASP Free Forums Sponsor:
  #1  
Old May 9th, 2008, 12:03 PM
Jaykappy Jaykappy is offline
Contributing User
ASP Free Novice (500 - 999 posts)
  
Join Date: Feb 2005
Posts: 853 Jaykappy User rank is Sergeant Major (2000 - 5000 Reputation Level)Jaykappy User rank is Sergeant Major (2000 - 5000 Reputation Level)Jaykappy User rank is Sergeant Major (2000 - 5000 Reputation Level)Jaykappy User rank is Sergeant Major (2000 - 5000 Reputation Level)Jaykappy User rank is Sergeant Major (2000 - 5000 Reputation Level)Jaykappy User rank is Sergeant Major (2000 - 5000 Reputation Level) 
Time spent in forums: 6 Days 1 h 31 m 30 sec
Reputation Power: 25
Calendars
I have added A calendar control to my forms...they are working fine....."Calendar Control 11.0"

BUT....I know here it comes...

Everytime I open the calendar it seems to revert back to the date that I created it...

I went into the Calendar Object Properties and tried to change the Value but it keeps going back...

What I want is everytime I open the calendar I want to to default to the current data..

Any thoughts?

THanks
Reply With Quote
  #2  
Old May 9th, 2008, 12:09 PM
Jaykappy Jaykappy is offline
Contributing User
ASP Free Novice (500 - 999 posts)
  
Join Date: Feb 2005
Posts: 853 Jaykappy User rank is Sergeant Major (2000 - 5000 Reputation Level)Jaykappy User rank is Sergeant Major (2000 - 5000 Reputation Level)Jaykappy User rank is Sergeant Major (2000 - 5000 Reputation Level)Jaykappy User rank is Sergeant Major (2000 - 5000 Reputation Level)Jaykappy User rank is Sergeant Major (2000 - 5000 Reputation Level)Jaykappy User rank is Sergeant Major (2000 - 5000 Reputation Level) 
Time spent in forums: 6 Days 1 h 31 m 30 sec
Reputation Power: 25
Think I fixed it...

Added this line to set the calendar to the current date....

Calendar2.Value = Now()

I think this makes sense...

Code:
Private Sub Combo0_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single)
    Set varDate = Combo0
    
    Calendar2.Value = Now()
    
    Calendar2.Visible = True
    Calendar2.SetFocus
    If Not IsNull(Combo0) Then
        Calendar2.Value = varDate.Value
    Else
        Calendar2.Value = Date
    End If
End Sub
Last edited by Jaykappy : May 9th, 2008 at 12:11 PM.
Reply With Quote
  #3  
Old May 9th, 2008, 12:11 PM
Jaykappy Jaykappy is offline
Contributing User
ASP Free Novice (500 - 999 posts)
  
Join Date: Feb 2005
Posts: 853 Jaykappy User rank is Sergeant Major (2000 - 5000 Reputation Level)Jaykappy User rank is Sergeant Major (2000 - 5000 Reputation Level)Jaykappy User rank is Sergeant Major (2000 - 5000 Reputation Level)Jaykappy User rank is Sergeant Major (2000 - 5000 Reputation Level)Jaykappy User rank is Sergeant Major (2000 - 5000 Reputation Level)Jaykappy User rank is Sergeant Major (2000 - 5000 Reputation Level) 
Time spent in forums: 6 Days 1 h 31 m 30 sec
Reputation Power: 25
This the other part


AT THE TOP

Code:
Option Compare Database
' Variable for the NoticeDate Calendar
    Dim varDate As ComboBox



ON THE CALENDAR CLICK EVENT

Code:
Private Sub Calendar2_Click()
    varDate.Value = Calendar2.Value
    varDate.SetFocus
    Calendar2.Visible = False
    ' CLear the variable so the next drop down can use it...
    Set varDate = Nothing
End Sub
Reply With Quote
  #4  
Old May 9th, 2008, 12:19 PM
AOG123's Avatar
AOG123 AOG123 is offline
Registered Hero
ASP Free Novice (500 - 999 posts)
  
Join Date: Oct 2006
Posts: 974 AOG123 User rank is General 5th Grade (Above 100000 Reputation Level)AOG123 User rank is General 5th Grade (Above 100000 Reputation Level)AOG123 User rank is General 5th Grade (Above 100000 Reputation Level)AOG123 User rank is General 5th Grade (Above 100000 Reputation Level)AOG123 User rank is General 5th Grade (Above 100000 Reputation Level)AOG123 User rank is General 5th Grade (Above 100000 Reputation Level)AOG123 User rank is General 5th Grade (Above 100000 Reputation Level)AOG123 User rank is General 5th Grade (Above 100000 Reputation Level)AOG123 User rank is General 5th Grade (Above 100000 Reputation Level)AOG123 User rank is General 5th Grade (Above 100000 Reputation Level)AOG123 User rank is General 5th Grade (Above 100000 Reputation Level)AOG123 User rank is General 5th Grade (Above 100000 Reputation Level)AOG123 User rank is General 5th Grade (Above 100000 Reputation Level)AOG123 User rank is General 5th Grade (Above 100000 Reputation Level)AOG123 User rank is General 5th Grade (Above 100000 Reputation Level)AOG123 User rank is General 5th Grade (Above 100000 Reputation Level) 
Time spent in forums: 3 Weeks 4 Days 23 h 28 m 34 sec
Reputation Power: 1325
Hi,..

Can i suggest you look at the custom calendar control i posted here,



http://www.developerbarn.com/micros...ar-control.html
Comments on this post
Jaykappy agrees!
Reply With Quote
  #5  
Old May 9th, 2008, 12:22 PM
sbenj69's Avatar
sbenj69 sbenj69 is offline
Redneck 'puter fell'r
ASP Free Intermediate (1500 - 1999 posts)
  
Join Date: Feb 2007
Location: Redneck part of Illinois
Posts: 1,722 sbenj69 User rank is General 7th Grade (Above 100000 Reputation Level)sbenj69 User rank is General 7th Grade (Above 100000 Reputation Level)sbenj69 User rank is General 7th Grade (Above 100000 Reputation Level)sbenj69 User rank is General 7th Grade (Above 100000 Reputation Level)sbenj69 User rank is General 7th Grade (Above 100000 Reputation Level)sbenj69 User rank is General 7th Grade (Above 100000 Reputation Level)sbenj69 User rank is General 7th Grade (Above 100000 Reputation Level)sbenj69 User rank is General 7th Grade (Above 100000 Reputation Level)sbenj69 User rank is General 7th Grade (Above 100000 Reputation Level)sbenj69 User rank is General 7th Grade (Above 100000 Reputation Level)sbenj69 User rank is General 7th Grade (Above 100000 Reputation Level)sbenj69 User rank is General 7th Grade (Above 100000 Reputation Level)sbenj69 User rank is General 7th Grade (Above 100000 Reputation Level)sbenj69 User rank is General 7th Grade (Above 100000 Reputation Level)sbenj69 User rank is General 7th Grade (Above 100000 Reputation Level)sbenj69 User rank is General 7th Grade (Above 100000 Reputation Level)  Folding Points: 305646 Folding Title: Super Ultimate Folder - Level 1Folding Points: 305646 Folding Title: Super Ultimate Folder - Level 1Folding Points: 305646 Folding Title: Super Ultimate Folder - Level 1Folding Points: 305646 Folding Title: Super Ultimate Folder - Level 1Folding Points: 305646 Folding Title: Super Ultimate Folder - Level 1Folding Points: 305646 Folding Title: Super Ultimate Folder - Level 1
Time spent in forums: 3 Weeks 1 Day 13 h 17 m 38 sec
Reputation Power: 1460
I like this one much better

>>CLICK HERE<<
Comments on this post
Jaykappy agrees: Very helpful
__________________
Did I help you? If so gimme rep by clicking on the scales at the top right corner of this post

Madness does not always howl. Sometimes, it is the quiet voice at the end of the day saying, "Hey, is there room in your head for one more?"
Reply With Quote
  #6  
Old May 9th, 2008, 12:31 PM
Jaykappy Jaykappy is offline
Contributing User
ASP Free Novice (500 - 999 posts)
  
Join Date: Feb 2005
Posts: 853 Jaykappy User rank is Sergeant Major (2000 - 5000 Reputation Level)Jaykappy User rank is Sergeant Major (2000 - 5000 Reputation Level)Jaykappy User rank is Sergeant Major (2000 - 5000 Reputation Level)Jaykappy User rank is Sergeant Major (2000 - 5000 Reputation Level)Jaykappy User rank is Sergeant Major (2000 - 5000 Reputation Level)Jaykappy User rank is Sergeant Major (2000 - 5000 Reputation Level) 
Time spent in forums: 6 Days 1 h 31 m 30 sec
Reputation Power: 25
Sure you can suggest....
I just got that from snid bits....

I am goin to look at yours...I am sure its better than the code I pasted...I have been trying to find a way to avoid the calendar controls myself....

Now I have one...

THANKS ...have a great weekend....think I am going to go golf 9 holes before the rain hits....
Reply With Quote
  #7  
Old May 9th, 2008, 12:36 PM
Jaykappy Jaykappy is offline
Contributing User
ASP Free Novice (500 - 999 posts)
  
Join Date: Feb 2005
Posts: 853 Jaykappy User rank is Sergeant Major (2000 - 5000 Reputation Level)Jaykappy User rank is Sergeant Major (2000 - 5000 Reputation Level)Jaykappy User rank is Sergeant Major (2000 - 5000 Reputation Level)Jaykappy User rank is Sergeant Major (2000 - 5000 Reputation Level)Jaykappy User rank is Sergeant Major (2000 - 5000 Reputation Level)Jaykappy User rank is Sergeant Major (2000 - 5000 Reputation Level) 
Time spent in forums: 6 Days 1 h 31 m 30 sec
Reputation Power: 25
Sweet....

No problems with me using the code???

Ill give you props in my code....
Reply With Quote
  #8  
Old May 9th, 2008, 12:47 PM
Jaykappy Jaykappy is offline
Contributing User
ASP Free Novice (500 - 999 posts)
  
Join Date: Feb 2005
Posts: 853 Jaykappy User rank is Sergeant Major (2000 - 5000 Reputation Level)Jaykappy User rank is Sergeant Major (2000 - 5000 Reputation Level)Jaykappy User rank is Sergeant Major (2000 - 5000 Reputation Level)Jaykappy User rank is Sergeant Major (2000 - 5000 Reputation Level)Jaykappy User rank is Sergeant Major (2000 - 5000 Reputation Level)Jaykappy User rank is Sergeant Major (2000 - 5000 Reputation Level) 
Time spent in forums: 6 Days 1 h 31 m 30 sec
Reputation Power: 25
But a heck of a lot more code that I wrote...

But way cooler.....
Reply With Quote
  #9  
Old May 9th, 2008, 12:50 PM
Jaykappy Jaykappy is offline
Contributing User
ASP Free Novice (500 - 999 posts)
  
Join Date: Feb 2005
Posts: 853 Jaykappy User rank is Sergeant Major (2000 - 5000 Reputation Level)Jaykappy User rank is Sergeant Major (2000 - 5000 Reputation Level)Jaykappy User rank is Sergeant Major (2000 - 5000 Reputation Level)Jaykappy User rank is Sergeant Major (2000 - 5000 Reputation Level)Jaykappy User rank is Sergeant Major (2000 - 5000 Reputation Level)Jaykappy User rank is Sergeant Major (2000 - 5000 Reputation Level) 
Time spent in forums: 6 Days 1 h 31 m 30 sec
Reputation Power: 25
Is there a way to copy that form from that database to my database?

moving all the code etc.....

feeling lazy....but grateful
Reply With Quote
  #10  
Old May 9th, 2008, 12:52 PM
Jaykappy Jaykappy is offline
Contributing User
ASP Free Novice (500 - 999 posts)
  
Join Date: Feb 2005
Posts: 853 Jaykappy User rank is Sergeant Major (2000 - 5000 Reputation Level)Jaykappy User rank is Sergeant Major (2000 - 5000 Reputation Level)Jaykappy User rank is Sergeant Major (2000 - 5000 Reputation Level)Jaykappy User rank is Sergeant Major (2000 - 5000 Reputation Level)Jaykappy User rank is Sergeant Major (2000 - 5000 Reputation Level)Jaykappy User rank is Sergeant Major (2000 - 5000 Reputation Level) 
Time spent in forums: 6 Days 1 h 31 m 30 sec
Reputation Power: 25
No Kidding ...you can drag and drop??????

wow
Reply With Quote
  #11  
Old May 9th, 2008, 01:32 PM
sbenj69's Avatar
sbenj69 sbenj69 is offline
Redneck 'puter fell'r
ASP Free Intermediate (1500 - 1999 posts)
  
Join Date: Feb 2007
Location: Redneck part of Illinois
Posts: 1,722 sbenj69 User rank is General 7th Grade (Above 100000 Reputation Level)sbenj69 User rank is General 7th Grade (Above 100000 Reputation Level)sbenj69 User rank is General 7th Grade (Above 100000 Reputation Level)sbenj69 User rank is General 7th Grade (Above 100000 Reputation Level)sbenj69 User rank is General 7th Grade (Above 100000 Reputation Level)sbenj69 User rank is General 7th Grade (Above 100000 Reputation Level)sbenj69 User rank is General 7th Grade (Above 100000 Reputation Level)sbenj69 User rank is General 7th Grade (Above 100000 Reputation Level)sbenj69 User rank is General 7th Grade (Above 100000 Reputation Level)sbenj69 User rank is General 7th Grade (Above 100000 Reputation Level)sbenj69 User rank is General 7th Grade (Above 100000 Reputation Level)sbenj69 User rank is General 7th Grade (Above 100000 Reputation Level)sbenj69 User rank is General 7th Grade (Above 100000 Reputation Level)sbenj69 User rank is General 7th Grade (Above 100000 Reputation Level)sbenj69 User rank is General 7th Grade (Above 100000 Reputation Level)sbenj69 User rank is General 7th Grade (Above 100000 Reputation Level)  Folding Points: 305646 Folding Title: Super Ultimate Folder - Level 1Folding Points: 305646 Folding Title: Super Ultimate Folder - Level 1Folding Points: 305646 Folding Title: Super Ultimate Folder - Level 1Folding Points: 305646 Folding Title: Super Ultimate Folder - Level 1Folding Points: 305646 Folding Title: Super Ultimate Folder - Level 1Folding Points: 305646 Folding Title: Super Ultimate Folder - Level 1
Time spent in forums: 3 Weeks 1 Day 13 h 17 m 38 sec
Reputation Power: 1460
yeah, it's easy...... import the module and form2..... form1 shows how to call the module
Reply With Quote
  #12  
Old May 9th, 2008, 01:48 PM
Jaykappy Jaykappy is offline
Contributing User
ASP Free Novice (500 - 999 posts)
  
Join Date: Feb 2005
Posts: 853 Jaykappy User rank is Sergeant Major (2000 - 5000 Reputation Level)Jaykappy User rank is Sergeant Major (2000 - 5000 Reputation Level)Jaykappy User rank is Sergeant Major (2000 - 5000 Reputation Level)Jaykappy User rank is Sergeant Major (2000 - 5000 Reputation Level)Jaykappy User rank is Sergeant Major (2000 - 5000 Reputation Level)Jaykappy User rank is Sergeant Major (2000 - 5000 Reputation Level) 
Time spent in forums: 6 Days 1 h 31 m 30 sec
Reputation Power: 25
Yea just opened both databases...dragged the form and module into my database.

Had to remove the control on the textbox cause not hitting a tableat this point...all set...

Looks great....thanks...
Reply With Quote
Reply

Viewing: ASP Free Forums > Database > Microsoft Access Help > Calendars

« Previous Thread | Next Thread »

Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Linear Mode Linear Mode
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump



 Free IT White Papers!
 
How to Present Effectively Online
This white paper offers practical and actionable advice on the key steps that any presenter should consider as they plan and execute a Webinar or online meeting.
 
Open Source Security Myths
Open Source Software (OSS) is computer software whose source code is available to the general public with relaxed or non-existent intellectual property restrictions (or arrangement such as the public domain), and is usually developed with the input of many contributors.
 
Power and Cooling Capacity Management for Data Centers
This paper describes the principles for achieving power and cooling capacity management.
 
Scalable, Fault-Tolerant NAS for Oracle - The Next Generation
For several years NAS has been evolving as a storage alternative for Oracle databases, and for good reason: NAS is quite often the simplest, most cost-effective storage approach for Oracle. Learn about the benefits that HP's approach to scalable NAS brings to Oracle environments in this comprehensive white paper.
 
Understanding Web Application Security Challenges
This white paper discusses many common threats and preventive measures for Web application security, and explains what you can do to help protect your organization.
 

Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2009 by Developer Shed. All rights reserved. DS Cluster 2 hosted by Hostway. 
Stay green...Green IT