 |  |  |  |  |  |  |  |
How I find out data from access
Please support our Visual Basic 4 / 5 / 6 advertiser: Programming Forums - DaniWeb Sister Site
 |
•
•
Join Date: Jul 2008
Posts: 474
Reputation: 
Solved Threads: 24
Posting Pro in Training
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.
•
•
Join Date: Jul 2008
Posts: 474
Reputation:
Solved Threads: 24
Posting Pro in Training
I only write, what i want to find. not critera. but now i write "Fieldname = condition" but i want only condition
You mean you want to find data where Fieldname = condition ?
And condition is user input?
And condition is user input?
Never tried = Never Know
So, Please do something before post your thread.
* PM Asking will be ignored *
So, Please do something before post your thread.
* PM Asking will be ignored *
•
•
Join Date: Jul 2008
Posts: 474
Reputation:
Solved Threads: 24
Posting Pro in Training
yes only condition is input. now i write like Name (fieldname) = taher (condition) but i only input taher (condition)
•
•
Join Date: Feb 2008
Posts: 509
Reputation:
Solved Threads: 88
Posting Pro
Hi, First get the input from the user Say (sName) and use Field Names in your coding not as input.
Example
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
|
Similar Threads
- MS Access vs. MySQL (MS Access and FileMaker Pro)
- Centralized data in .NET? (C#)
- "Forbidden / You don't have permission to access / on this server." error (Linux Servers and Apache)
- Vb.net source code to access data from Access Database (Visual Basic 4 / 5 / 6)
- vb.net code to access data from Access Database (VB.NET)
- Archive MSaccess data into a different Access DB (Visual Basic 4 / 5 / 6)
- Can't access my folder! (Windows NT / 2000 / XP)
- Access Sub switchboard password protection (Visual Basic 4 / 5 / 6)
- data access (Visual Basic 4 / 5 / 6)
Other Threads in the Visual Basic 4 / 5 / 6 Forum
- Previous Thread: Working with Files
- Next Thread: loop
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Latest Visual Basic 4 / 5 / 6 Posts
- Today's Posts
- Unanswered Threads
Related Forum Features
* 6 429 2007 access activex add age append application basic beginner birth bmp calculator cd cells.find click client code college column component connection connectionproblemusingvb6usingoledb copy creat ctrl+f data database datareport date delete dissertations dissertationthesis dissertationtopic edit error excel excelmacro file filename form hardware header iamthwee image inboxinvb internetfiledownload keypress label listbox listview liveperson login looping machine microsoft movingranges number objectinsert open oracle password prime program prompt range-objects readfile reading record refresh remotesqlserverdatabase report retrieve save search sendbyte sites sort sql sql2008 sqlserver subroutine table tags textbox time urldownloadtofile vb vb6 vb6.0 vba visual visualbasic visualbasic6 web window windows
