Excel like checkbox filter
Is it possible to have an Excel like filter in Access
Thank you for taking the time to report an issue.
What's wrong... Please write below.
I would like to filter in my form only Checked items:
I don't know how to use Filter options and what does Filter On Load means.
I've tried: [FFA_Status]="Yes". Not working
I have an App. that prints out a list from witch people can select (or unselect) list items, using a pen or pencil. The user then types in this selection.
I would like to automate this process using an Excel sheet, but don't know how to implement the bool value in an excel cell. I think a checkBox would be good.
1) Am I right? there are about 200-700 items in the list.
2) How do I format a cell as a checkBox using acc 2003 VBA
2. Checkbox on = Yes; Checkbox off = No
The Main form is a continuous form, so I can't use a subform to show whether or not the checkbox for the corresponding record in KAF is checked.
My idea was to display a label in the Main Form ONLY when the corresponding record in KAF has the checkbox checked. The thing is, BOTH of the fields (P and Country) need to match the record in the KAF form.
I thought that what I could do is to make KAF open as a hidden form when the Main Form opens and then filter KAF so that it displays the record corresponding to the record on the Main Form that has the focus.
Then I would need to run code like this to filter the hidden KAF form to match the current record in the Main Form:
1. I have not been able to filter KAF based on the record that has focus - how would I do that?
2. This feels like a very round-about way to do this - is there an easier way?
I have a Datasheet form that has a checkbox in the header. When the checkbox is checked, I want the datasheet to update and show only records with the field value = 6. The field is called [Category]. If the box is unchecked, I want all records to display.
I should also mention that this form is based on a query.
My form has a checkbox that when not checked the value is "0" When checked the value is "-1"
the checkbox name is "CheckFabric"
In my report, I have an event in the header that starts when printing. The event is an embedded macro as follows:
Budget Report is my table, Extra1 is a value 1 or 0.
When "CheckFabric" = -1 (is checked), I want to filter the table so only the Records that Extra1 = 0 show.
I need that since it set to YES it will filter only a record in my subform:Subform_ProjectList that contains ISOMETRICS under Title field name.
My subform has many field name like Doc Nos, Rev, Title, Status and etc.
The first is a combo list box called request type which contains let's say A,B,C,all. I also have a (date from) and (date to) [LINK] which I am also trying to use as the second filter to filter the dates entered by the user and the request type.
I have created a macro button to export the report query to excel but I am trying to add the appropriate filters to the querybefore exporting to excel.
Also, when (all) is selected, I do not want the filter to apply to (request type).