943,960 Members | Top Members by Rank

Ad:
Jul 19th, 2008
0

How I find out data from access

Expand Post »
I use data control to link access file by data properties not code. use simple code like move next etc. I use find next to find data. but when i want to find i write the criteria like Name = taher. But i want I write only taher in find text box.
Similar Threads
Reputation Points: 14
Solved Threads: 78
Practically a Posting Shark
abu taher is offline Offline
835 posts
since Jul 2008
Jul 20th, 2008
0

Re: How I find out data from access

so what is your problem ?
Featured Poster
Reputation Points: 665
Solved Threads: 427
Posting Genius
debasisdas is offline Offline
6,406 posts
since Feb 2007
Jul 20th, 2008
0

Re: How I find out data from access

I only write, what i want to find. not critera. but now i write "Fieldname = condition" but i want only condition
Reputation Points: 14
Solved Threads: 78
Practically a Posting Shark
abu taher is offline Offline
835 posts
since Jul 2008
Jul 21st, 2008
0

Re: How I find out data from access

You mean you want to find data where Fieldname = condition ?
And condition is user input?
Reputation Points: 1182
Solved Threads: 392
Posting Sensei
Jx_Man is offline Offline
3,143 posts
since Nov 2007
Jul 21st, 2008
0

Re: How I find out data from access

yes only condition is input. now i write like Name (fieldname) = taher (condition) but i only input taher (condition)
Reputation Points: 14
Solved Threads: 78
Practically a Posting Shark
abu taher is offline Offline
835 posts
since Jul 2008
Jul 21st, 2008
0

Re: How I find out data from access

Hi, First get the input from the user Say (sName) and use Field Names in your coding not as input.

Example
Recordset.Find "Name'=" & sName & "'" Here you only give the condition (sName or txtName.Text that is Input) and Field name is predefined by your coding.
Reputation Points: 44
Solved Threads: 101
Posting Pro
selvaganapathy is offline Offline
547 posts
since Feb 2008
Jul 22nd, 2008
0

Re: How I find out data from access

use variable to get text value in it and then apply your code on that variable
Reputation Points: 10
Solved Threads: 1
Newbie Poster
electrosoul456 is offline Offline
2 posts
since Jul 2008

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in Visual Basic 4 / 5 / 6 Forum Timeline: Working with Files
Next Thread in Visual Basic 4 / 5 / 6 Forum Timeline: loop





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC