Visual Basic 4 / 5 / 6 RSS Visual Basic 4 / 5 / 6 RSS

Sorting a .mdb database by date?

Please support our Visual Basic 4 / 5 / 6 advertiser: Programming Forums - DaniWeb Sister Site
Reply
1 2

•
•
Join Date: Oct 2008
Posts: 20
Reputation: Entropy1024 is an unknown quantity at this point 
Solved Threads: 0
Entropy1024 Entropy1024 is offline Offline
Newbie Poster

Re: Sorting a .mdb database by date?

 
0
  #11
Oct 22nd, 2008
Ah. OK thank you. I will do that.

Cheers
Reply With Quote Quick reply to this message  
•
•
Join Date: Oct 2008
Posts: 20
Reputation: Entropy1024 is an unknown quantity at this point 
Solved Threads: 0
Entropy1024 Entropy1024 is offline Offline
Newbie Poster

Re: Sorting a .mdb database by date?

 
0
  #12
Oct 22nd, 2008
Great, thank you, That fixed it. Sort of anyway

It initially appears to have done nothing, but if I then close my program and restart it then the records are in date order. Is there some way to force a sort at runtime?

Many thanks for the help.
Reply With Quote Quick reply to this message  
•
•
Join Date: Feb 2007
Posts: 2,099
Reputation: debasisdas will become famous soon enough debasisdas will become famous soon enough 
Solved Threads: 128
debasisdas's Avatar
debasisdas debasisdas is offline Offline
Postaholic

Re: Sorting a .mdb database by date?

 
0
  #13
Oct 22nd, 2008
you need to convert the data in text format to date format and then sort.
Share your Knowledge.
Reply With Quote Quick reply to this message  
•
•
Join Date: Jul 2007
Posts: 300
Reputation: jireh is an unknown quantity at this point 
Solved Threads: 42
jireh's Avatar
jireh jireh is offline Offline
Posting Whiz

Re: Sorting a .mdb database by date?

 
0
  #14
Oct 23rd, 2008
In your code put this query before you bind it in the grid...

Visual Basic 4 / 5 / 6 Syntax (Toggle Plain Text) 
  1. "select * from [tablename] order by datefield asc"
A conclusion is the place where you got tired of thinking.
http://www.martin2k.co.uk/forums/index.php?showforum=4
http://www.a1vbcode.com/a1vbcode/vbforums/Forum3-1.aspx
http://www.developerfusion.co.uk/for...orum&ForumID=4
Reply With Quote Quick reply to this message  
•
•
Join Date: Oct 2008
Posts: 20
Reputation: Entropy1024 is an unknown quantity at this point 
Solved Threads: 0
Entropy1024 Entropy1024 is offline Offline
Newbie Poster

Re: Sorting a .mdb database by date?

 
0
  #15
Oct 26th, 2008
OK great thanks got it to work. The following code worked.

Visual Basic 4 / 5 / 6 Syntax (Toggle Plain Text) 
  1. AdHocData.RecordSource = "select * from AdHocData order by StartDateTime asc"
Reply With Quote Quick reply to this message  
Reply
1 2

Quick Reply to Thread
This thread is more than three months old.
Perhaps start a new thread instead?
•
•
•
•
•
•
•
•
Message:
•
•
•
•



Other Threads in the Visual Basic 4 / 5 / 6 Forum
Thread Tools Search this Thread



* 6 429 2007 access activex add age append application basic beginner birth bmp calculator cd cells.find click client code college column component connection connectionproblemusingvb6usingoledb copy creat ctrl+f data database datareport date delete dissertations dissertationthesis dissertationtopic edit error excel excelmacro file filename form hardware header iamthwee image inboxinvb internetfiledownload keypress label listbox listview liveperson login looping machine microsoft movingranges number objectinsert open oracle password prime program prompt range-objects readfile reading record refresh remotesqlserverdatabase report retrieve save search sendbyte sites sort sql sql2008 sqlserver subroutine table tags textbox time urldownloadtofile vb vb6 vb6.0 vba visual visualbasic visualbasic6 web window windows
About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC