Click here to Skip to main content
15,899,679 members
Home / Discussions / Visual Basic
   

Visual Basic

 
AnswerRe: How to monitor drive activity in vb 2008 Pin
Dave Kreskowiak6-Jan-10 14:49
mveDave Kreskowiak6-Jan-10 14:49 
AnswerRe: How to monitor drive activity in vb 2008 Pin
Andy_L_J6-Jan-10 15:06
Andy_L_J6-Jan-10 15:06 
AnswerRe: How to monitor drive activity in vb 2008 Pin
Dimitri Witkowski6-Jan-10 22:26
Dimitri Witkowski6-Jan-10 22:26 
AnswerRe: How to monitor drive activity in vb 2008 Pin
RevEd7-Jan-10 15:53
RevEd7-Jan-10 15:53 
QuestionOffice version Problem in Outlook Add-in Pin
dcdhingra6-Jan-10 5:02
dcdhingra6-Jan-10 5:02 
QuestionDate manipulation and SQL.... Pin
Johnkokk5-Jan-10 23:15
Johnkokk5-Jan-10 23:15 
AnswerRe: Date manipulation and SQL.... Pin
Luc Pattyn6-Jan-10 2:14
sitebuilderLuc Pattyn6-Jan-10 2:14 
AnswerRe: Date manipulation and SQL.... Pin
loyal ginger6-Jan-10 4:34
loyal ginger6-Jan-10 4:34 
You can reformat the date to use ANSI format so they can be compared correctly. For example, use a query similar to this:

SELECT *
FROM Table
Where  format(fyear,"0000")+'/'+format(fmonth,"00")+'/'+format(fday,"00")>='2009/06/05'
and  format(fyear,"0000")+'/'+format(fmonth,"00")+'/'+format(fday,"00")<='2009/11/23';


Note that the begin and end date have to also be formatted to use ANSI format: "YYYY/MM/DD".

It's not pretty but because you don't have control over your table structure, this may be the solution to your problem.

Happy programming!
GeneralRe: Date manipulation and SQL.... Pin
Johnkokk6-Jan-10 20:54
Johnkokk6-Jan-10 20:54 
QuestionHow to open existing file in VB6 Pin
JC.KaNNaN5-Jan-10 22:59
JC.KaNNaN5-Jan-10 22:59 
AnswerRe: How to open existing file in VB6 Pin
Eddy Vluggen6-Jan-10 1:30
professionalEddy Vluggen6-Jan-10 1:30 
QuestionStackOverflowException [SOLVED] [modified] Pin
#realJSOP5-Jan-10 8:44
professional#realJSOP5-Jan-10 8:44 
AnswerRe: StackOverflowException Pin
MikeMarq5-Jan-10 9:14
MikeMarq5-Jan-10 9:14 
GeneralRe: StackOverflowException Pin
#realJSOP5-Jan-10 9:31
professional#realJSOP5-Jan-10 9:31 
QuestionHot to set Color as Red when Combo Style is set as other than DropDownList [modified] Pin
janaswamy uday5-Jan-10 6:44
janaswamy uday5-Jan-10 6:44 
AnswerRe: Hot to set Color as Red when Combo Style is set as other than DropDownList [modified] Pin
TheComputerMan6-Jan-10 15:33
TheComputerMan6-Jan-10 15:33 
QuestionProblem with UDPClient Receive function Pin
xairoy5-Jan-10 3:08
xairoy5-Jan-10 3:08 
AnswerRe: Problem with UDPClient Receive function Pin
DaveAuld5-Jan-10 4:40
professionalDaveAuld5-Jan-10 4:40 
GeneralRe: Problem with UDPClient Receive function Pin
xairoy5-Jan-10 20:46
xairoy5-Jan-10 20:46 
QuestionHow to open openoffice document in vb 6.0 Pin
JC.KaNNaN5-Jan-10 2:28
JC.KaNNaN5-Jan-10 2:28 
AnswerRe: How to open openoffice document in vb 6.0 Pin
Dave Kreskowiak5-Jan-10 3:53
mveDave Kreskowiak5-Jan-10 3:53 
AnswerRe: How to open openoffice document in vb 6.0 Pin
Eddy Vluggen5-Jan-10 7:22
professionalEddy Vluggen5-Jan-10 7:22 
AnswerRe: How to open openoffice document in vb 6.0 Pin
JC.KaNNaN5-Jan-10 20:58
JC.KaNNaN5-Jan-10 20:58 
GeneralRe: How to open openoffice document in vb 6.0 Pin
Ashfield5-Jan-10 21:49
Ashfield5-Jan-10 21:49 
AnswerRe: How to open openoffice document in vb 6.0 Pin
David Skelly5-Jan-10 22:15
David Skelly5-Jan-10 22:15 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.