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 PostHi,
I have done it the past by having a query in Access that returns the wanted records. Then call that query from VB and display/access the records.
Hope this helps
Denis
Jump to Postuse ms access query and than use it any where... simple..
Jump to Postin ms access design your query in design view add your table into the query window and than double click on the fields which you may need for the query like fees of the student and in the criteria row just write the condition < 2000 under the fees column …
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,
…
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.