I know there is a way to filter tables without using a query, but I am not sure how to do it. I think it is done placing the SQL code right into the VB code. Any help would be great, or a reference to a helpuful tutorial on this would also be great. THanks!
9 1789
Please have patience when you are awaiting an answer. The exports on this forum dedicate their free time to help others without any compensation. If you have not received a reply after 24 hours, then feel free to bump the thread. But you must give the experts a chance to get to your question.
MODERATOR
You can filter a table without using a query if you open up the table and use the menu Records > Filter.
You can filter a table without using a query if you open up the table and use the menu Records > Filter.
Can you point me towards an example of this, because I am not sure how to do this.
Can you point me towards an example of this, because I am not sure how to do this.
Well, when you have your table open, at the top of your Access window is the title bar, below that are menus. File, Edit, Tools, Help, etc.
You just click that, point the mouse towards filter, and you can choose what kind of filter you want to apply.
Well, when you have your table open, at the top of your Access window is the title bar, below that are menus. File, Edit, Tools, Help, etc.
You just click that, point the mouse towards filter, and you can choose what kind of filter you want to apply.
I was wanting to know more how to use the VB code of a form to filter the tables. any thoughts on that?
You can use the Form's .Filter property to set up a filter built like the WHERE statement of SQL Code and then set the Form's .FilterOn property to true.
Personally I prefer to use the right-click popup menu to apply a filter on a table or form. The input box will even allow to specify a LIKE with wild characters.
Nic;o)
Hello...
Are you using a Recordset? In Vb, I guess you have to store the Data from your database to a recordset object. You can then use the Filter method of recordset object to filter data under given condition. If example you have a recordset named RSTPROFILE, then
RSTPROFILE.Filter = "lastname = '" & txtlastname.text & "'"
to remove the filter just use
RSTPROFILE.Filter = ""
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Robert Neville |
last post by:
I would like to add filter functionality to my database whether
through the Main form or the subform. This question may be
rudimentary, yet I have not less experience with filtering data
outside...
|
by: dick |
last post by:
I am just trying to print/report the results of a "filter by
selection" which is done by right-clicking a form, filling in values,
and "applying the filter."
I have searched the newsgroups, and...
|
by: Brian |
last post by:
I hope this will make sense. I'm trying to filter the records in a
table based on records in a 2nd table. The trick is, I can't use a
query. I'm trying to filter down the number of records going...
|
by: werk |
last post by:
For limiting access to the database to strictly necessary I try to
filter the query by using DataView.
Thw DataSet ds contains three columns (fields) : (LAND_ID, Landcode,
Landnaam) and four...
|
by: Bob |
last post by:
I am in the process of upgrading an Access database to SQL Server (and
climbing that learning curve!). The wizard happily upgraded all the tables
and I can link to them OK using ODBC.
The...
|
by: turtle |
last post by:
I have Two tables (Table1 and Table2). Both tables have a common field
called part number. Table 1 contains an extra field that i would like
to update table 2 to match if the part number matches....
|
by: Josetta |
last post by:
This is for informational purposes...I had a problem and I thought it
might help others in a similar situation. I hope someone, someday,
finds this idea useful. I've garnered so much knowledge...
|
by: jcf378 |
last post by:
Hi all--
Does anyone have any insight as to how I might create a search form
that allows a user to select criteria based on any related table in
the whole database. The search form I have now only...
|
by: sharsy |
last post by:
Hello,
I have a Database setup that has two tables that are linked. Table1
contains a list of people with their basic contact details (name &
phone number etc.) and Table2 contains a list of all...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
| |