Hi
I have a problem,
i have designed a database program with vb6 and ms access. and the program is suppose to display specific records using datareport. eg ,display records of student whose fees are> 10000. But i dont know my way out. hope to get help from anybody.thanks in advance.
TOROOOLOLOOLO 0 Newbie Poster
Recommended Answers
Jump to PostRight-Click Command Object (Say Command1)
Edit your Command's SQL Query and
make it :Select * From MyTable Where Fees Between ? And ?
Click on apply
Parameter Tab Is Enabled, Go there..
Set these properties for both Parameters:
DataType = adDoble
HostDataType =Currency
And Apply,
…
Jump to PostHi,
I Guess, you have created the DataReport, based on a COMMAND Object in DataEnvironment, You have to do the above process for that Command Object
Regards
Veena
Jump to PostHi,
What Line you are getting the error..? Post your Code Here..
Regards
Veena
Jump to PostHi toroo...,
What is the SQL Query of the Command Object (On which report is Based)
Say if your Command Object's name is "Command5", then
You need to pre-fix with "rs"
and it becomes rsCommand5Regards
Veena
All 16 Replies
DenisOxon 12 Posting Whiz
4ukh 3 Junior Poster in Training
TOROOOLOLOOLO 0 Newbie Poster
4ukh 3 Junior Poster in Training
QVeen72 104 Posting Shark
TOROOOLOLOOLO 0 Newbie Poster
QVeen72 104 Posting Shark
TOROOOLOLOOLO 0 Newbie Poster
QVeen72 104 Posting Shark
TOROOOLOLOOLO 0 Newbie Poster
TOROOOLOLOOLO 0 Newbie Poster
aktharshaik 16 Posting Whiz
TOROOOLOLOOLO 0 Newbie Poster
aktharshaik 16 Posting Whiz
QVeen72 104 Posting Shark
anandlalroy 0 Newbie Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.