 |  |  |  |  |  |  |  |
finding record in MS Access
Please support our Visual Basic 4 / 5 / 6 advertiser: Programming Forums - DaniWeb Sister Site
Thread Solved |
ui.bmp
i hv an interface sumthing like this. i/m using VB6 and i wanna find record in MS Access using find command button. firstly user will key in an employee number as a key to find that user record in MS Access. after that, the data will appear in the form above the search frame. im new with VB6'so i need some help.. thanks..
i hv an interface sumthing like this. i/m using VB6 and i wanna find record in MS Access using find command button. firstly user will key in an employee number as a key to find that user record in MS Access. after that, the data will appear in the form above the search frame. im new with VB6'so i need some help.. thanks..
You can do this ata database level using SQL queries.
if the employee number is a number use emp_number=number
if the employee number is a string use emp_number like '%string%'
if the employee number is a number use emp_number=number
if the employee number is a string use emp_number like '%string%'
Share your Knowledge.
•
•
Join Date: Jul 2008
Posts: 473
Reputation: 
Solved Threads: 24
Posting Pro in Training
Private Sub cmdfind_Click()
Dim a As String
Dim b As String
a = text1.text 'employee number
If Len(a) = 0 Then Exit Sub
b = "Employee Number Like """ & a & "*"""
Data1.Recordset.FindNext b
If Data1.Recordset.NoMatch Then
MsgBox "No record found", vbExclamation
end If
Exit Sub Last edited by Tekmaven; Jul 30th, 2008 at 9:48 am. Reason: Code tags
when i put dis coding, there was an error.
Run-time error '3077'
Syntax error (missing operator) in expression.
when i debug, the error was at:
Data1.Recordset.FindNext b
Run-time error '3077'
Syntax error (missing operator) in expression.
when i debug, the error was at:
Data1.Recordset.FindNext b
 |
Similar Threads
- Finding the nth row (SQL)...debative question (MS SQL)
- Synthax for finding a record:Re (Visual Basic 4 / 5 / 6)
- Synthax for finding a record (Visual Basic 4 / 5 / 6)
- "Forbidden / You don't have permission to access / on this server." error (Linux Servers and Apache)
- verify page not finding random records (ASP)
- Finding use cases and actors in UML (Java)
- finding the max date in a record (MS SQL)
- another newbie with alot of redhat and apache server Q'S (Linux Servers and Apache)
Other Threads in the Visual Basic 4 / 5 / 6 Forum
- Previous Thread: Find Com Port
- Next Thread: Access Parent node from a child node
| 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
