Click here to Skip to main content
15,900,258 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: Waiting on process to finish Pin
phraser15-Jul-05 11:50
phraser15-Jul-05 11:50 
GeneralRe: Waiting on process to finish Pin
Dave Kreskowiak15-Jul-05 16:58
mveDave Kreskowiak15-Jul-05 16:58 
GeneralRe: Waiting on process to finish Pin
phraser16-Jul-05 2:28
phraser16-Jul-05 2:28 
GeneralRe: Waiting on process to finish Pin
Dave Kreskowiak16-Jul-05 6:40
mveDave Kreskowiak16-Jul-05 6:40 
GeneralRe: Waiting on process to finish Pin
phraser16-Jul-05 7:58
phraser16-Jul-05 7:58 
GeneralResizing button controls Pin
Member 1325918815-Jul-05 7:21
Member 1325918815-Jul-05 7:21 
GeneralRe: Resizing button controls Pin
bneacetp16-Jul-05 15:34
bneacetp16-Jul-05 15:34 
GeneralBetween Syntax Pin
Capilano15-Jul-05 6:49
Capilano15-Jul-05 6:49 
Hi...

I am used to VBA so bear with me.

I need to identify if a value from a Stored Procedure falls within a parameter using the "between" syntax. For example, show me all of the records that fall between February 1, 2005 and February 28, 2005.

My problem is one of syntax. I know how to have the Stored Procedure filter the records using a parameter. eg:

Me.daCostingRecSearchByVendor.SelectCommand.Parameters("@TravelDate").Value = CDate(Me.dtpCostingStarting.Value).Date

Not a problem... displays the values I want for a Date I have selected using a DateTimePicker on my form. Here is the twist. I have two DateTimePickers on this form and I want to have the parameter (@TravelDate) select values which fall between the them.

How do I adjust the syntax? I have tried various methods including <> or 'GreaterThanOrEqualTo'... nothing has worked for me so far.

Any advice would be helpful.

Thanks in advance...

Pat
GeneralRe: Between Syntax Pin
Rob Graham16-Jul-05 11:57
Rob Graham16-Jul-05 11:57 
GeneralPassing Values to A Dropdown Pin
15-Jul-05 6:48
suss15-Jul-05 6:48 
GeneralDeployment problem Pin
pharao9215-Jul-05 5:24
pharao9215-Jul-05 5:24 
GeneralRe: Deployment problem Pin
Dave Kreskowiak15-Jul-05 5:52
mveDave Kreskowiak15-Jul-05 5:52 
GeneralAligning the Buttons in the form Pin
prathiba_naresh15-Jul-05 4:06
prathiba_naresh15-Jul-05 4:06 
GeneralRe: Aligning the Buttons in the form Pin
Dave Kreskowiak15-Jul-05 5:18
mveDave Kreskowiak15-Jul-05 5:18 
GeneralRe: Aligning the Buttons in the form Pin
Anonymous15-Jul-05 5:46
Anonymous15-Jul-05 5:46 
GeneralRe: Aligning the Buttons in the form Pin
prathiba_naresh15-Jul-05 6:02
prathiba_naresh15-Jul-05 6:02 
Generaloracle on linux Pin
smita_roy14-Jul-05 23:08
smita_roy14-Jul-05 23:08 
GeneralRe: oracle on linux Pin
Dave Kreskowiak15-Jul-05 1:40
mveDave Kreskowiak15-Jul-05 1:40 
Generalhelp on crystal report Pin
fire8514-Jul-05 20:27
fire8514-Jul-05 20:27 
GeneralRe: help on crystal report Pin
Rizwan Bashir14-Jul-05 21:57
Rizwan Bashir14-Jul-05 21:57 
GeneralMultithread Pin
hung_ngole14-Jul-05 18:50
hung_ngole14-Jul-05 18:50 
GeneralRe: Multithread Pin
rwestgraham14-Jul-05 19:50
rwestgraham14-Jul-05 19:50 
GeneralRe: Multithread Pin
hung_ngole15-Jul-05 15:58
hung_ngole15-Jul-05 15:58 
GeneralRe: Multithread Pin
rwestgraham16-Jul-05 23:45
rwestgraham16-Jul-05 23:45 
GeneralAdd records to DB Table usin VB.Net Pin
JERUSHA14-Jul-05 18:30
JERUSHA14-Jul-05 18:30 

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.