Access 2010 - Search a form programmatically

Question

0.00/5 (No votes)

See more:

Suppose we have an Access 2010 form that allows a user to navigate over every single employee in the table Employees.

Suppose also the form contains a TextBox txtId where the user can type the Id that uniquely identifies an employee. After clicking a button OK the form should show the information related to the employee identified by the typed id.

How can I do that using VB6 and without using filters?

I'd like the same effect the macro SearchForRecord has but doing all the work from Visual Basic.

Thank you in advance.

Posted 5-Mar-12 8:22am

arpoarpo

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Clifford Nelson · Answer 1 · 2012-03-05T08:57:00

An Access form has a Filter and an FilterON property. Just need to set the FilterOn to True and the Filter property to the text as would appear in a SQL Where clause (ie, Company LIKE "C*").

Me.Filter = "Company LIKE """ + CompanyFilter.Text + """"
Me.FilterOn = True

This should also work fine when form only shows a single record, or when it shows many records.