Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In with Facebook Sign In with Google Sign In with OpenID

Categories

We have migrated to a new platform! Please note that you will need to reset your password to log in (your credentials are still in-tact though). Please contact lee@programmersheaven.com if you have questions.
Welcome to the new platform of Programmer's Heaven! We apologize for the inconvenience caused, if you visited us from a broken link of the previous version. The main reason to move to a new platform is to provide more effective and collaborative experience to you all. Please feel free to experience the new platform and use its exciting features. Contact us for any issue that you need to get clarified. We are more than happy to help you.

trying to search an access db, no luck

jtmuzixjtmuzix Posts: 15Member
I'm using Visual Basic.NET 2003 professional. I am having problems doing a search on an Access database. No matter what I try it's always returning false. I can fill the dataset with an entire table but have had no luck filling it with a specific 'recordset' or return set. I've tried using commandselect.commandtext = "SELECT * FROM [scannerlog] WHERE [Department = & "'cbdep.selecteditem & '" I've tried a lot of different (syntax)variations thinking maybe I am syntactically incorrect. I've also tried a dataview and the .filterrow or .rowfilter function. It doesn't work either. It returns false as well, UNLESS I put in the string department; then it returns true. It's not the specific word 'department' I want to compare, it's THE specific department(i.e. shipping, recieving, HR). If it finds 1 match or 100 matches it SHOULD display all the data in the table relative to the matches it finds. Any code ideas on HOW to search an access database and fill the dataset respectivley would be greatly apperaited.
Thanks,
Jason Tutwiler

Comments

  • Geoff-SGeoff-S Posts: 82Member
    : I'm using Visual Basic.NET 2003 professional. I am having problems doing a search on an Access database. No matter what I try it's always returning false. I can fill the dataset with an entire table but have had no luck filling it with a specific 'recordset' or return set. I've tried using commandselect.commandtext = "SELECT * FROM [scannerlog] WHERE [Department = & "'cbdep.selecteditem & '" I've tried a lot of different (syntax)variations thinking maybe I am syntactically incorrect. I've also tried a dataview and the .filterrow or .rowfilter function. It doesn't work either. It returns false as well, UNLESS I put in the string department; then it returns true. It's not the specific word 'department' I want to compare, it's THE specific department(i.e. shipping, recieving, HR). If it finds 1 match or 100 matches it SHOULD display all the data in the table relative to the matches it finds. Any code ideas on HOW to search an access database and fill the dataset respectivley would be greatly apperaited.
    : Thanks,
    : Jason Tutwiler
    :
    :
    Hi JT
    I put the response to this in your post in the "Access databases and VB" forum.
    :-)
Sign In or Register to comment.