Recommended Answers
Jump to PostPlease show what you have done so far.
When you say you connected the Database please elaborate.
What Method have you applied. How good is your SQL?
Jump to PostHi
You should do something like this:
sub EmployeeSearch dim EmployNo as integer dim mySQL as string EmployNo = cint(MyTextbox.text) mySQL = "SELECT * FROM tblEmployee WHERE (EmployeeNo =" &EmployNo &")" 'run query on db and get result.
Jump to PostHi
The SQL is basically the same...Provide more details on where exactly you are stuck and we'll see what we can do..
Jump to Posthey im also having this similar problem.
Using Ms Access.
I have a table containing names and numbers and i have created the cmd button for search but kind of miss the coding.
I have a connection in my data enviroment and everything else is good except 4 this…
Jump to PostHi Guys,
Look up any of the following in Google or similar:
ADO.NET DataReader
ADO.NET DataAdapter
ADO.NET CommandPay attention to the examples given...
Also use the Access QBE to design your SELECT Query and switch to SQL view to get the Query in Access compatible …
All 17 Replies
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.