Click here to Skip to main content
15,911,785 members
Home / Discussions / Visual Basic
   

Visual Basic

 
Questionvb.net Pin
sgi.manish20-Jul-07 9:38
sgi.manish20-Jul-07 9:38 
AnswerRe: vb.net Pin
Dave Kreskowiak20-Jul-07 10:01
mveDave Kreskowiak20-Jul-07 10:01 
GeneralRe: vb.net Pin
leckey20-Jul-07 10:08
leckey20-Jul-07 10:08 
AnswerPlease read the forum guidelines Pin
leckey20-Jul-07 10:06
leckey20-Jul-07 10:06 
GeneralRe: Please read the forum guidelines Pin
Paul Conrad20-Jul-07 10:28
professionalPaul Conrad20-Jul-07 10:28 
GeneralRe: Please read the forum guidelines Pin
leckey20-Jul-07 10:42
leckey20-Jul-07 10:42 
GeneralRe: Please read the forum guidelines Pin
Paul Conrad20-Jul-07 10:46
professionalPaul Conrad20-Jul-07 10:46 
QuestionVisual Basic -Data access ,Data missing Pin
Rajesh Rajan Pankapattu20-Jul-07 9:09
Rajesh Rajan Pankapattu20-Jul-07 9:09 
The folowing is a Table and it's data of an MS Access Database

Table: EXPENSES

EDATE(Date) ETYPE(String) AMOUNT(Currency)
---------------------------------------------
01/01/07 Electricty 1000
21/01/07 Phone 1500
24/01/07 Repair 2000
05/02/07 Electricty 1000
23/02/07 Phone 1500
---------------------------------------------
Controls used on the VB form are...
-------------------------------------
Data Control named Data1
DBGrid named db1, It's Data source set to Data1
DatePickers named DTPicker1 and DTPicker2
Command Button named CmdExp

Running the code
----------------

DatePicker1 set to 01/01/07 and DatePicker2 set to 21/03/07

Following is the code executed when CmdExp is Clicked...
--------------------------------------------------------------
Private Sub CmdExp_Click()
Dim rs_exp As Recordset
Set rs_exp = db.OpenRecordset("select * from EXPENSES where EDATE >= " & DTPicker1.Value & " and EDATE <=" & DTPicker2.Value & " ")
Set Data1.Recordset = rs_exp
End Sub

The OutPut is
-------------
01/01/07 Electricty 1000
21/01/07 Phone 1500
05/02/07 Electricty 1000

Why does the two records with date 24/01/07 and 23/02/07 is not displayed even though they are between the two date ranges ?
AnswerRe: Visual Basic -Data access ,Data missing Pin
ciacia20-Jul-07 9:28
ciacia20-Jul-07 9:28 
AnswerRe: Visual Basic -Data access ,Data missing Pin
cutequencher21-Jul-07 6:43
cutequencher21-Jul-07 6:43 
QuestionVB .NET - is it really worth it? Pin
GuyThiebaut20-Jul-07 6:47
professionalGuyThiebaut20-Jul-07 6:47 
AnswerRe: VB .NET - is it really worth it? Pin
Dave Kreskowiak20-Jul-07 7:11
mveDave Kreskowiak20-Jul-07 7:11 
GeneralRe: VB .NET - is it really worth it? Pin
GuyThiebaut20-Jul-07 7:39
professionalGuyThiebaut20-Jul-07 7:39 
GeneralRe: VB .NET - is it really worth it? Pin
Paul Conrad20-Jul-07 8:26
professionalPaul Conrad20-Jul-07 8:26 
GeneralRe: VB .NET - is it really worth it? Pin
Kevin McFarlane20-Jul-07 9:13
Kevin McFarlane20-Jul-07 9:13 
AnswerRe: VB .NET - is it really worth it? Pin
Christian Graus20-Jul-07 19:27
protectorChristian Graus20-Jul-07 19:27 
GeneralRe: VB .NET - is it really worth it? Pin
Dave Kreskowiak21-Jul-07 1:53
mveDave Kreskowiak21-Jul-07 1:53 
Questionhot-key behavior -- override?? Pin
nlarson1120-Jul-07 6:04
nlarson1120-Jul-07 6:04 
AnswerRe: hot-key behavior -- override?? Pin
Dave Kreskowiak20-Jul-07 7:04
mveDave Kreskowiak20-Jul-07 7:04 
GeneralRe: hot-key behavior -- override?? Pin
nlarson1120-Jul-07 8:01
nlarson1120-Jul-07 8:01 
QuestionDataGridView - Why doesn't this work? Pin
penguin500020-Jul-07 5:41
penguin500020-Jul-07 5:41 
AnswerRe: DataGridView - Why doesn't this work? Pin
GuyThiebaut20-Jul-07 6:52
professionalGuyThiebaut20-Jul-07 6:52 
GeneralRe: DataGridView - Why doesn't this work? Pin
penguin500023-Jul-07 4:41
penguin500023-Jul-07 4:41 
QuestionAccessing Database Pin
Toyeyen20-Jul-07 5:15
Toyeyen20-Jul-07 5:15 
AnswerRe: Accessing Database Pin
Paul Conrad29-Jul-07 6:13
professionalPaul Conrad29-Jul-07 6:13 

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.