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:
Ajax Application Generator Generate database and reporting .NET Web apps in minutes. Quickly create visually stunning, feature-rich apps that are easy to customize and ready to deploy. Download Now!
  #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: 649 Jaykappy User rank is Sergeant (500 - 2000 Reputation Level)Jaykappy User rank is Sergeant (500 - 2000 Reputation Level)Jaykappy User rank is Sergeant (500 - 2000 Reputation Level)Jaykappy User rank is Sergeant (500 - 2000 Reputation Level)Jaykappy User rank is Sergeant (500 - 2000 Reputation Level) 
Time spent in forums: 4 Days 20 h 54 m 11 sec
Reputation Power: 22
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: 649 Jaykappy User rank is Sergeant (500 - 2000 Reputation Level)Jaykappy User rank is Sergeant (500 - 2000 Reputation Level)Jaykappy User rank is Sergeant (500 - 2000 Reputation Level)Jaykappy User rank is Sergeant (500 - 2000 Reputation Level)Jaykappy User rank is Sergeant (500 - 2000 Reputation Level) 
Time spent in forums: 4 Days 20 h 54 m 11 sec
Reputation Power: 22
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: 649 Jaykappy User rank is Sergeant (500 - 2000 Reputation Level)Jaykappy User rank is Sergeant (500 - 2000 Reputation Level)Jaykappy User rank is Sergeant (500 - 2000 Reputation Level)Jaykappy User rank is Sergeant (500 - 2000 Reputation Level)Jaykappy User rank is Sergeant (500 - 2000 Reputation Level) 
Time spent in forums: 4 Days 20 h 54 m 11 sec
Reputation Power: 22
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: 883 AOG123 User rank is General (90000 - 100000 Reputation Level)AOG123 User rank is General (90000 - 100000 Reputation Level)AOG123 User rank is General (90000 - 100000 Reputation Level)AOG123 User rank is General (90000 - 100000 Reputation Level)AOG123 User rank is General (90000 - 100000 Reputation Level)AOG123 User rank is General (90000 - 100000 Reputation Level)AOG123 User rank is General (90000 - 100000 Reputation Level)AOG123 User rank is General (90000 - 100000 Reputation Level)AOG123 User rank is General (90000 - 100000 Reputation Level)AOG123 User rank is General (90000 - 100000 Reputation Level)AOG123 User rank is General (90000 - 100000 Reputation Level)AOG123 User rank is General (90000 - 100000 Reputation Level)AOG123 User rank is General (90000 - 100000 Reputation Level)AOG123 User rank is General (90000 - 100000 Reputation Level)AOG123 User rank is General (90000 - 100000 Reputation Level)AOG123 User rank is General (90000 - 100000 Reputation Level) 
Time spent in forums: 3 Weeks 2 Days 10 h 44 m 58 sec
Reputation Power: 995
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
Dark Sonic Apprentice :D
Click here for more information
 
Join Date: Feb 2007
Location: Redneck part of Illinois
Posts: 1,454 sbenj69 User rank is General 2nd Grade (Above 100000 Reputation Level)sbenj69 User rank is General 2nd Grade (Above 100000 Reputation Level)sbenj69 User rank is General 2nd Grade (Above 100000 Reputation Level)sbenj69 User rank is General 2nd Grade (Above 100000 Reputation Level)sbenj69 User rank is General 2nd Grade (Above 100000 Reputation Level)sbenj69 User rank is General 2nd Grade (Above 100000 Reputation Level)sbenj69 User rank is General 2nd Grade (Above 100000 Reputation Level)sbenj69 User rank is General 2nd Grade (Above 100000 Reputation Level)sbenj69 User rank is General 2nd Grade (Above 100000 Reputation Level)sbenj69 User rank is General 2nd Grade (Above 100000 Reputation Level)sbenj69 User rank is General 2nd Grade (Above 100000 Reputation Level)sbenj69 User rank is General 2nd Grade (Above 100000 Reputation Level)sbenj69 User rank is General 2nd Grade (Above 100000 Reputation Level)sbenj69 User rank is General 2nd Grade (Above 100000 Reputation Level)sbenj69 User rank is General 2nd Grade (Above 100000 Reputation Level)sbenj69 User rank is General 2nd Grade (Above 100000 Reputation Level)  Folding Points: 189478 Folding Title: Super Ultimate Folder - Level 1Folding Points: 189478 Folding Title: Super Ultimate Folder - Level 1Folding Points: 189478 Folding Title: Super Ultimate Folder - Level 1Folding Points: 189478 Folding Title: Super Ultimate Folder - Level 1Folding Points: 189478 Folding Title: Super Ultimate Folder - Level 1Folding Points: 189478 Folding Title: Super Ultimate Folder - Level 1
Time spent in forums: 2 Weeks 5 Days 13 h 40 m 28 sec
Reputation Power: 1091
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 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: 649 Jaykappy User rank is Sergeant (500 - 2000 Reputation Level)Jaykappy User rank is Sergeant (500 - 2000 Reputation Level)Jaykappy User rank is Sergeant (500 - 2000 Reputation Level)Jaykappy User rank is Sergeant (500 - 2000 Reputation Level)Jaykappy User rank is Sergeant (500 - 2000 Reputation Level) 
Time spent in forums: 4 Days 20 h 54 m 11 sec
Reputation Power: 22
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: 649 Jaykappy User rank is Sergeant (500 - 2000 Reputation Level)Jaykappy User rank is Sergeant (500 - 2000 Reputation Level)Jaykappy User rank is Sergeant (500 - 2000 Reputation Level)Jaykappy User rank is Sergeant (500 - 2000 Reputation Level)Jaykappy User rank is Sergeant (500 - 2000 Reputation Level) 
Time spent in forums: 4 Days 20 h 54 m 11 sec
Reputation Power: 22
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: 649 Jaykappy User rank is Sergeant (500 - 2000 Reputation Level)Jaykappy User rank is Sergeant (500 - 2000 Reputation Level)Jaykappy User rank is Sergeant (500 - 2000 Reputation Level)Jaykappy User rank is Sergeant (500 - 2000 Reputation Level)Jaykappy User rank is Sergeant (500 - 2000 Reputation Level) 
Time spent in forums: 4 Days 20 h 54 m 11 sec
Reputation Power: 22
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: 649 Jaykappy User rank is Sergeant (500 - 2000 Reputation Level)Jaykappy User rank is Sergeant (500 - 2000 Reputation Level)Jaykappy User rank is Sergeant (500 - 2000 Reputation Level)Jaykappy User rank is Sergeant (500 - 2000 Reputation Level)Jaykappy User rank is Sergeant (500 - 2000 Reputation Level) 
Time spent in forums: 4 Days 20 h 54 m 11 sec
Reputation Power: 22
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: 649 Jaykappy User rank is Sergeant (500 - 2000 Reputation Level)Jaykappy User rank is Sergeant (500 - 2000 Reputation Level)Jaykappy User rank is Sergeant (500 - 2000 Reputation Level)Jaykappy User rank is Sergeant (500 - 2000 Reputation Level)Jaykappy User rank is Sergeant (500 - 2000 Reputation Level) 
Time spent in forums: 4 Days 20 h 54 m 11 sec
Reputation Power: 22
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
Dark Sonic Apprentice :D
Click here for more information
 
Join Date: Feb 2007
Location: Redneck part of Illinois
Posts: 1,454 sbenj69 User rank is General 2nd Grade (Above 100000 Reputation Level)sbenj69 User rank is General 2nd Grade (Above 100000 Reputation Level)sbenj69 User rank is General 2nd Grade (Above 100000 Reputation Level)sbenj69 User rank is General 2nd Grade (Above 100000 Reputation Level)sbenj69 User rank is General 2nd Grade (Above 100000 Reputation Level)sbenj69 User rank is General 2nd Grade (Above 100000 Reputation Level)sbenj69 User rank is General 2nd Grade (Above 100000 Reputation Level)sbenj69 User rank is General 2nd Grade (Above 100000 Reputation Level)sbenj69 User rank is General 2nd Grade (Above 100000 Reputation Level)sbenj69 User rank is General 2nd Grade (Above 100000 Reputation Level)sbenj69 User rank is General 2nd Grade (Above 100000 Reputation Level)sbenj69 User rank is General 2nd Grade (Above 100000 Reputation Level)sbenj69 User rank is General 2nd Grade (Above 100000 Reputation Level)sbenj69 User rank is General 2nd Grade (Above 100000 Reputation Level)sbenj69 User rank is General 2nd Grade (Above 100000 Reputation Level)sbenj69 User rank is General 2nd Grade (Above 100000 Reputation Level)  Folding Points: 189478 Folding Title: Super Ultimate Folder - Level 1Folding Points: 189478 Folding Title: Super Ultimate Folder - Level 1Folding Points: 189478 Folding Title: Super Ultimate Folder - Level 1Folding Points: 189478 Folding Title: Super Ultimate Folder - Level 1Folding Points: 189478 Folding Title: Super Ultimate Folder - Level 1Folding Points: 189478 Folding Title: Super Ultimate Folder - Level 1
Time spent in forums: 2 Weeks 5 Days 13 h 40 m 28 sec
Reputation Power: 1091
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: 649 Jaykappy User rank is Sergeant (500 - 2000 Reputation Level)Jaykappy User rank is Sergeant (500 - 2000 Reputation Level)Jaykappy User rank is Sergeant (500 - 2000 Reputation Level)Jaykappy User rank is Sergeant (500 - 2000 Reputation Level)Jaykappy User rank is Sergeant (500 - 2000 Reputation Level) 
Time spent in forums: 4 Days 20 h 54 m 11 sec
Reputation Power: 22
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


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