 |  |  |  |  |  |  |  |
make a datareport with condition
Please support our Visual Basic 4 / 5 / 6 advertiser: Programming Forums - DaniWeb Sister Site
Thread Solved |
•
•
Join Date: Nov 2006
Posts: 848
Reputation: 
Solved Threads: 120
Practically a Posting Shark
Hi,
For Numeric(Long)
adBigInt, Long
For Text :
adVarChar, String
Regards
Veena
For Numeric(Long)
adBigInt, Long
For Text :
adVarChar, String
Regards
Veena
hello abu,
pls try this code if this will work.
("Select * from TableName where IDate <= cDate (' " & CStr(DTPicker1.Value) & " ') and IDate >= cDate(' " & CStr(DTPicker2.Value) & " ')")
or
If DTPicker1.Value <= !IDate And DTPicker2.Value >= !IDate Then
Regards,
denine
pls try this code if this will work.
("Select * from TableName where IDate <= cDate (' " & CStr(DTPicker1.Value) & " ') and IDate >= cDate(' " & CStr(DTPicker2.Value) & " ')")
or
If DTPicker1.Value <= !IDate And DTPicker2.Value >= !IDate Then
Regards,
denine
•
•
Join Date: Jul 2008
Posts: 498
Reputation:
Solved Threads: 25
Posting Pro in Training
Dear veena
I have a problem. I write code in sql like
select * from table1
so all field show. help me what I write for particular field. I write....
select Student name from table1
what I write? some time parametre not show.
I have a problem. I write code in sql like
select * from table1
so all field show. help me what I write for particular field. I write....
select Student name from table1
what I write? some time parametre not show.
•
•
Join Date: Nov 2006
Posts: 848
Reputation:
Solved Threads: 120
Practically a Posting Shark
Hi,
Yes, You can write all the field names from the table...
eg:
Select EmpID,EmpName From EmpMas Where EmpID = ?
Regards
Veena
Yes, You can write all the field names from the table...
eg:
Select EmpID,EmpName From EmpMas Where EmpID = ?
Regards
Veena
•
•
Join Date: Jul 2008
Posts: 498
Reputation:
Solved Threads: 25
Posting Pro in Training
I write like you but no field show but parametre was shown. If i write only this
select * from table1
then show all fields. but when I write your past code it was worked.
select * from table1
then show all fields. but when I write your past code it was worked.
•
•
Join Date: Jul 2008
Posts: 498
Reputation:
Solved Threads: 25
Posting Pro in Training
Please any body help me.
•
•
Join Date: Jul 2008
Posts: 498
Reputation:
Solved Threads: 25
Posting Pro in Training
anybody help me please
•
•
Join Date: Nov 2006
Posts: 848
Reputation:
Solved Threads: 120
Practically a Posting Shark
Hi,
Post your SQL statement here..
Regards
Veena
Post your SQL statement here..
Regards
Veena
•
•
Join Date: Jul 2008
Posts: 498
Reputation:
Solved Threads: 25
Posting Pro in Training
SELECT * FROM incomereport WHERE AccountinfoDate AND IncomeDate BETWEEN ? AND ?
1st I write this code and it work after I write for other
SELECT Student ID, Student Name, Jamat Name, Feeding Charge,
Exam Fee, Roll No, Jamat Fee, Others Fee, AccountinfoDate,
Father 's Name,Category,Contact No,Address,Admission Date From stdreport Where Student ID ?
this code not work.
1st I write this code and it work after I write for other
SELECT Student ID, Student Name, Jamat Name, Feeding Charge,
Exam Fee, Roll No, Jamat Fee, Others Fee, AccountinfoDate,
Father 's Name,Category,Contact No,Address,Admission Date From stdreport Where Student ID ?
this code not work.
 |
Other Threads in the Visual Basic 4 / 5 / 6 Forum
- Previous Thread: Simple Excel Macro (VBA)
- Next Thread: Minimize a form in its own window Like Photoshop
Views: 3477 | Replies: 27
| Thread Tools | Search this Thread |
Latest Visual Basic 4 / 5 / 6 Posts
- Today's Posts
- Unanswered Threads
Related Forum Features
Tag cloud for Visual Basic 4 / 5 / 6
6 429 2007 access activex add age append application basic beginner birth c++ 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 struct subroutine table tags textbox time timer urldownloadtofile vb vb6 vb6.0 vba visual visualbasic visualbasic6 web window windows
