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

Visual Basic

 
AnswerRe: Hide a complete row... Pin
Dave Kreskowiak7-Jan-10 0:30
mveDave Kreskowiak7-Jan-10 0:30 
QuestionHow to monitor drive activity in vb 2008 Pin
RevEd6-Jan-10 14:21
RevEd6-Jan-10 14:21 
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 
I've got an Access Database

For whatever reason, there is a field in there for DATE that is declared as string.
Also there are 3 other fields in there called FDAY,FMONTH,FYEAR that are declared as number and actually get the parsed values from the DATE field.
So if the user enter for DATE 21/12/2009, the FDAY=21, FMONTH=12, FYEAR=2009

Now at some point, the user wants to get all the records from 20/6/2009 - 12/12/2009

Can someone help, on how we can make an SQL query to do that ?
Whatever i have tried does not solve the problem.

It is easy, as long you have the same month and year in the "FROM" and "TO", because you just check the FDAY variable to be within the limits.
For example if we wanted from 5/10/2009 - 23/5/2009, the SQL would be "SELECT * FROM TABLE WHERE FDAY BETWEEN 5 AND 23"

However the things get complicated when you have different month or year.For example if we want the records from 5/6/2009 to 23/11/2009.
Now what ?

Don't ask why the date field is declared as STRING and not DATE, in the first place.
The question is, is it doable with what we have now ?

Thanks.
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 
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 

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.