I have two separate but similar databases and each has a split form that acts as the main form used. One of these split forms is able to be filtered from the datasheet portion of the split form using Quick Filters at the top of each column.
The other database split form doesn't show any Quick Filter values when the column headers are clicked. Does anybody know what the problem is, or where I would change the parameters to enable Quick Filters?
I appreciate any help that anyone can give me. Thanks in advance.
9 10465 NeoPa 32,584
Recognized Expert Moderator MVP
I would guess one or other of the form's properties needs to be set to allow filtering. Hang on. I'll check quickly...
I would suggest paying particular attention to the AllowFilter property, but compare both forms for differences and see what allows it to work.
Has there been any resolution to this issue?
Leon
NeoPa 32,584
Recognized Expert Moderator MVP
Nothing confirmed. Why do you ask (The answer seems fairly obvious)?
Sorry let me explain: I tried what was posted above, and still cvant get it to work. I was wondering if anyone found the propertu that was causing this problem. I would appreciate any help, thanks.
Leon
NeoPa 32,584
Recognized Expert Moderator MVP
No sorry.
I would need to see the items concerned even to know where to look if it's not the .AllowFilter property..
Megalog 378
Recognized Expert Contributor
I've seen this happen a lot on columns using multi-value fields, or if there's a complex SQL string as the form's RecordSource. The filtering option isnt turned off, it's just not returning any of the column values when you click the headers, correct?
If the form's RecordSource is a SQL string, try taking that string and creating a new query with it. Save the query, and set the form's RecordSource to that query instead. Normally it wouldnt change anything, but split forms are very strange and I've found this solution works most of the time.
That is correct, its not returning the values. Instead of changing the record source to filter the subform, i used filter functions in my VBA. Seems to work fine now. i appreciate the post.
Leon
Megalog - this is ancient history for you now, but I just encountered this problem in an Access 2007 split form. After searching far and wide your suggestion was the only one I found that made any sense for my situation. I do have a complex SQL string in the form's RecordSource so creating a new query and referencing that was spot on. All the quick filters are there now! Thanks.
@Megalog
- Hi... this was exactly the issue: the "Data Source" of the form had an SQL string instead of a query. This was preventing the display of the quick filter option. I replaced the string for a query and it did the trick. Thank you very much for the tip, saved me a lot of time.
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 from queries. Let me just add that Allen Browne excellent
article about this subject may not apply to this scenario on an
elementary level. (Here's the link to the article; Filter a Form on a
Field in a Subform -...
|
by: CSDunn |
last post by:
Hello,
I have a problem with field filtering between an Access 2000 Project form
(the application is called CELDT), and the report that shows the results of
the filter. Both the form and the report are based on the same View
addressed in the Record Source of both as 'dbo.CLMain_vw'. The View resides
in a SQL Server 2000 database. There are two different problems I am having
with filtering: The first involves filtering in the form by date...
|
by: Richard |
last post by:
Hi,
I have a form based on a table. When I filter the form I want to run a
report based on the same table with the same filter as the form. No problem
until I want to filter a combo box where the text value is on a different
table. The me.filter is then a text instead of the id-number from the lookup
table. This causes the report to prompt for the parameter.
How do I get by this problem? Do I need to create a temporary table? I
rather...
|
by: Julia |
last post by:
Hello there.
I have a question somewhat related to this topic, and I don't know
where else to go. I hope somebody can help. I've created a database
in access, that I'd like to share with less than 10 users. I'd like
each user to see only some of the records in the database. So for
example, if I have eight users in eight countries, I want each of them
to only see information for their country.
I was told that the easiest way to do...
|
by: Jay |
last post by:
I need to add a parameter to a directorysearcher.filter rather than using
hard-coded text. I have the following code that finds all members of an AD
group and then for each of those results tries to find that users
samAccountName.
Perhaps I'm going about this incorrectly but I know if I could pass my
searcher.filter a paramter rather than typing "cn=jason", etc this code
would work, any help would be very much appreciated!:
'Get all...
| |
by: Mike |
last post by:
I'm trying to filter a dataset on items that are being passed in via a
querystring.
the string looks like this.
chevy|ford|BMW|
on the information page i split the string such as
selCars.split("|")
and i want to filter the dataset based on the string so i do this
|
by: Dave G |
last post by:
Since upgrading one of my clients from A97/W2000 to A2003/XP they have
suffered no end of data corruption problems, mainly involving one of
the main tables. The corruption can result in one record's fields
turning into chinese characters. On running the compact/repair I can
see that the corruption may be deeper than I expected because sometimes
indexes are missing and need to be replaced.
I used to think that overuse of 'ctrl-alt-delete'...
|
by: pobnospam |
last post by:
I have a field called ingredients where multiple ingredients can be
contained in one record (client request). Now when a report is run I
need to prompt a user to determine which records to display which could
be all of the below ingredients or just 1.
Order ID Ingredients
1 PEP, SAU, MSH, GP
2 SAU
3 PEP
|
by: Abedin |
last post by:
I have 9 digits in form of "111020402". Then I have another 9 digits
in form of "111020403". I have 100,000 records of these two 9-digit
numbers.
I want to filter this as follows:
District: 111
Charge: 02
Circle: 04
|
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |