Microsoft Access Development
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
User Name:
Password:
Remember me
 
Go Back   Dev Articles Community ForumsDatabasesMicrosoft Access Development

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Display Modes
 
Unread Dev Articles Community Forums Sponsor:
  #1  
Old June 14th, 2006, 10:30 PM
Useless Useless is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: May 2006
Posts: 9 Useless User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 1 h 45 m 21 sec
Reputation Power: 0
Date problem with specific dates

Hi all,
I am having a bit of a problem with a specific set of dates. I have a form that uses multiple combo boxes (4) to filter down to a unique record, with the final combo box being a date field. Also on the form is a subform that displays the list of records as they are being filtered. As each combo box is selected the list grows smaller. The problem I am having is that when selecting the date combo box, if the date is either 10/12/yy (dd/mm/yyyy format) or 12/10/yy the record disappears. It appears to only be these two day/month combinations and the year doesnt matter. If it has that combination of day and month the record disappears off the list.
Any ideas as to why this is happening. The AfterUpdate event of the date combo box uses these lines to populate the subform, which is basically identical to what is used for the other combo boxes.
.
.
strSQLSF = strSQLSF & " cbm.Sample_Date = #" & cboSampleDate & "#"

Me!SelectItemSubForm.LinkChildFields = ""
Me!SelectItemSubForm.LinkMasterFields = ""

Me!SelectItemSubForm.LinkChildFields = "Item1;Item2;Item3;Sample_Date"
Me!SelectItemSubForm.LinkMasterFields = "Item1;Item2;Item3;Sample_Date"
Me.RecordSource = strSQLSF
Me.Requery

Thanks for any help you may be able to give

Reply With Quote
  #2  
Old June 15th, 2006, 07:02 PM
Clarafication Clarafication is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Jan 2006
Posts: 23 Clarafication User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 9 h 5 m 10 sec
Reputation Power: 0
I was having some crazy things happening with some dates. I ended up having to define everything as a Short Date. Also, one of the fields was being populated on default as Now() but the format of the field was Short Date. That threw it all off because the actual long date and time was what was being stored. I changed the default to Format(Now(), "Short Date"). I would suggest triple checking everything to make sure it is stored as a Short Date and that it is defined that way.

Reply With Quote
  #3  
Old June 16th, 2006, 12:35 AM
Useless Useless is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: May 2006
Posts: 9 Useless User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 1 h 45 m 21 sec
Reputation Power: 0
Further complications

Hi,
It is really strange. There is only one table in the dB and the date is manually entered and has the short date input mask on. I have since noticed another strange event occurring. Where I previously thought the event was restricted to those with 10 and 12 in the day and month, I have noticed that it happens to a few others where the day and month are separated by 2, ie 05/07, 11/13, 02/04... I am really confused by this now.

Reply With Quote
  #4  
Old June 23rd, 2006, 03:59 AM
Useless Useless is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: May 2006
Posts: 9 Useless User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 1 h 45 m 21 sec
Reputation Power: 0
I ended up changing the field to a text field with a dd/mm/yy input mask and when I need to validate it I have a variable and use IsDate and then CDate(txtDate) to check it and perform validation.

Unfortunately couldnt determine the cause of the problem

Reply With Quote
Reply

Viewing: Dev Articles Community ForumsDatabasesMicrosoft Access Development > Date problem with specific dates


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
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 | 
  
 





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