User Name Password Register
DaniWeb IT Discussion Community
All
What is DaniWeb IT Discussion Community?
You're currently browsing the Visual Basic 4 / 5 / 6 section within the Software Development category of DaniWeb, a massive community of 426,509 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,105 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our Visual Basic 4 / 5 / 6 advertiser: Programming Forums
Views: 443 | Replies: 6
Reply
Join Date: Jul 2008
Location: Dhaka, Bangladesh
Posts: 83
Reputation: abu taher is an unknown quantity at this point 
Rep Power: 1
Solved Threads: 2
abu taher's Avatar
abu taher abu taher is offline Offline
Junior Poster in Training

How I find out data from access

  #1  
Jul 19th, 2008
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.
AddThis Social Bookmark Button
Reply With Quote  
Join Date: Feb 2007
Location: Bangalore,India
Posts: 1,290
Reputation: debasisdas is on a distinguished road 
Rep Power: 4
Solved Threads: 83
debasisdas's Avatar
debasisdas debasisdas is offline Offline
Nearly a Posting Virtuoso

Re: How I find out data from access

  #2  
Jul 20th, 2008
so what is your problem ?
Share your Knowledge.
Reply With Quote  
Join Date: Jul 2008
Location: Dhaka, Bangladesh
Posts: 83
Reputation: abu taher is an unknown quantity at this point 
Rep Power: 1
Solved Threads: 2
abu taher's Avatar
abu taher abu taher is offline Offline
Junior Poster in Training

Re: How I find out data from access

  #3  
Jul 20th, 2008
I only write, what i want to find. not critera. but now i write "Fieldname = condition" but i want only condition
Reply With Quote  
Join Date: Nov 2007
Location: � Jogja �
Posts: 2,585
Reputation: Jx_Man is a glorious beacon of light Jx_Man is a glorious beacon of light Jx_Man is a glorious beacon of light Jx_Man is a glorious beacon of light Jx_Man is a glorious beacon of light Jx_Man is a glorious beacon of light 
Rep Power: 11
Solved Threads: 235
Jx_Man's Avatar
Jx_Man Jx_Man is offline Offline
Posting Maven

Re: How I find out data from access

  #4  
Jul 20th, 2008
You mean you want to find data where Fieldname = condition ?
And condition is user input?
Never tried = Never Know
So, Please do something before post your thread.
* PM Asking will be ignored *
Reply With Quote  
Join Date: Jul 2008
Location: Dhaka, Bangladesh
Posts: 83
Reputation: abu taher is an unknown quantity at this point 
Rep Power: 1
Solved Threads: 2
abu taher's Avatar
abu taher abu taher is offline Offline
Junior Poster in Training

Re: How I find out data from access

  #5  
Jul 21st, 2008
yes only condition is input. now i write like Name (fieldname) = taher (condition) but i only input taher (condition)
Reply With Quote  
Join Date: Feb 2008
Location: Sivakasi, Tamilnadu, India
Posts: 458
Reputation: selvaganapathy is an unknown quantity at this point 
Rep Power: 1
Solved Threads: 79
selvaganapathy's Avatar
selvaganapathy selvaganapathy is offline Offline
Posting Pro in Training

Re: How I find out data from access

  #6  
Jul 21st, 2008
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.
KSG
Reply With Quote  
Join Date: Jul 2008
Posts: 2
Reputation: electrosoul456 is an unknown quantity at this point 
Rep Power: 0
Solved Threads: 0
electrosoul456 electrosoul456 is offline Offline
Newbie Poster

Re: How I find out data from access

  #7  
Jul 22nd, 2008
use variable to get text value in it and then apply your code on that variable
Reply With Quote  
Reply

Only community members can participate in forum threads. You must register or log in to contribute.

DaniWeb Visual Basic 4 / 5 / 6 Marketplace
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

 

Thread Tools Display Modes

Similar Threads
Other Threads in the Visual Basic 4 / 5 / 6 Forum

All times are GMT -4. The time now is 5:52 pm.
Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC