I am pretty new at this so please bear with me :confused: (like that isn't said a thousand times!). I am creating a small database to track task data (manpower tracking basically) where I have the following fields:
Customer
Functional Group
Task Status
Task Name
Task Description
WO #
Funded Hours
Notes
I would like to create a combo box where the user can select the customer (I have 124 records in total, 15 unique customer names) and all tasks relating to that customer are filtered directly in the Form by clicking a single button to do the filter.
I don't want to create dozens of tables and forms to flip through and such (users need it as simple as possible). I have created queries but the only way I have successfully filtered each customer is via buttons...but 15 buttons to filter each individual customer is a pain in the butt, so any help would be REALLY appreciated.
Please let me know if I haven't explained this clearly enough! :)
I would like to filter a data from a table using a combo box in a form.
The field I would like to filter is called ManufacturersID in MainTable and consist of text and wildcard characters [e.g., Teledyne O&G (ODI), TE Connectivity (Deutsch), etc...], so are the combo strings which are extracted from the table ManufacturersTable. It is not filtering anything. I suspect that the wildcards and spaces are the problem. I also tried to get the combo string to a text box in the form and use it in the query with no success. Additionally, I also tried Like [Forms]![FormName]![textbox] in query criteria but still not filtering...
I use filter Combo boxes in a lot of places so that users can filter records easily. (Not combo boxes for input).I have them labeled as filters but nonetheless users keep trying to input into them for some reason.How would I add a message box to it so that it states that 'this box is not for data entry etc'.
I have a continuous form based on table "INCOMES" that shows all the payments received, which mediums can be (field "PMNT_MEDIUM"):
- check - transfer - taxes - cash
Table "INCOMES" is filled using another form, but in this particular form I just want to show "check", "transfer" and "cash" (not "taxes") so that I can track all the cash incomes.
Note: taxes are loaded because they appear in my invoices and I need them there to reach the invoice total amount.So my form has a search bar which allows me to search by PMNT_MEDIUM listing all "checks", all "cash" or all "transfer". I can also search by payment number (meaning: check number). To that end I have a "search" button that applies the filter. And I have another button that "cleans" the filtering by "putting a "" in the search-bar and then calling the "on click" of the search button".
What I need is, no matter if I click over the "search" or "clean" button, it NEVER shows me the "taxes".Search button, on click code:
If IsNumeric(Me.busq_chq_med) Then Me.Filter = "[PMNT_MEDIUM_NUMB] =" & Me.SEARCH_BAR Else Me.Filter = "[PMNT_MEDIUM] like'" & Me.SEARCH_BAR & "*'" Me.Filter = "[PMNT_MEDIUM] like'" & Me.SEARCH_BAR & "*' or [INVOICE] like'" & Me.SEARCH_BAR & "*'" End If Me.FilterOn = True
How can I create a "Filter Button" on a form and filter my records? I create a textbox on a form and a filter button on the right. Then I click the filter futton, the filter function will search/match the content in the box through the datasheet. And then the results of the filtering will be pop up on the split form datasheet.
When I click the filter button I get a blank message box titled 'Microsoft Access" and an OK button, when closed the filter works perfectly.I have checked this procedure in other forms and it works without showing the blank message box.The only difference with this form is that its control source is a union query.
I have seen a few articles here and there on using a combo box to filter records in a sub-form and to filter records in another combo box, but I am not getting anywhere. I hope someone can belp
Exercise 1
For this exercise, I have the following tables:
tblClients containing client names tblProjects containing some project details
I want to set up a simple form, so that the user can select a client name from a combo box on the main form which filters the project detail records in the Projects sub-form. Once the user enters project details, I want this info as well as the selected ClientID to be fed back to tblProjects.
Exercise 2
I have the following tables:
tblProjects as above tblWorkstream containiig names of workstreams and some other details.
Every project has one or more workstreams
I have a form where users will enter hours worked on each workstream. They will first select Project from a combo box on the main form. This should then filter records to be displayed in the Workstream Combo box, before they can then enter hours.
Please let me know if you need me to explain any part of this better.
Thanks in advance.
ps. I am a novice, so I'm hoping to do the above using default MS stuff, not with complex programming!!!
I'm having a little difficulty setting up a combo box to filter another combo box. I've actually got one working but the second one is giving me all sorts of errors. On the attached database, there's a form called frmAddNewRecord. At the top of the form there's a combo box which allows you to select a name and another combo box beside it which acts as a filter so only names from a certain section are shown (working fine).
The subform which is attached to this form and contains the training details, has another combo box which allows you to select a job...I've tried to add a combo box beside this to filter it but I can't get it to work.
I have a combo box with different department names in it I have a button in a form called cmdShowDept the caption "Show only one Department"
When I open the form I have the combo box set to not be visible When the Show only one Department command button is pressed I want the following to happen; The Department combo box should appear The button's text should change to "Show all Departments" in red If the button is clicked when the text is red then: the original button text should return in Black the department combo should disappear
After clicking on the button and you click one of the specific departments ie accounting I want it to show only the accounting records in the form.
I'm still learning about access, so thanks for any help anyone can give me pleeeese!!
I have a form and I have placed a "Filter by form" button in it. Now I would like to create a second button that applies the filter (same funtions as the funnel icon on the toolbar. I tried using a macro with a command but when I click the first button and the form is ready to accept my criteria for the filter both button are greyed out. The only way I could apply the filter is through the toolbar. Any way of doing this second button?
Hi, I am trying to find code that will let me put a command button on a search form. When it is clicked I want the command filter by selection to filter the records. Basically copying the command when you click the button on the toolbar :rolleyes:
I am trying to put a button on a form I have created so that I can use Filter by Form feature on it. I used the toolbox commnad button wizard and chose the Form Operations -> Apply Form Filter option for the button.
Unfortunately, this button does not work for this choice. In the Form view, if I click on this button nothing happens. Other choices in the wizard such as Edit Form Filter etc works.
Does anyone know what could be the problem? Is this an Access bug (i am using Access 2003).
If it is a bug, can anyone suggest what little modifications one might have to do to the VBA code underlying OnClick event for the button to make this command button work?
Hi, I'm an Access newbie. I've designed a fairly simple database to replace an old spreadsheet that was becoming unwieldy -- it was never really used so much for calculation as for data storage, so Access seems more appropriate anyway.
One of the functions I used in Excel was the autofilter, which I found very useful for zeroing in on specific portions of the data. I was wondering how I would do the same thing in Access, and then I discovered the "Filter by Form", which works just fine -- even better actually, since it has the whole and/or functionality.
I was wondering though if it would be possible to invoke "Filter by Form" using a command button. That would make it even easier, especially for some of my users who would almost certainly not know about "Filter by Form" otherwise.
I have searched the forms and I see codes to apply filters to a button, but can someone tell me what is the code to remove all filters on the current form? I know I can always hit the filter on/off button at the top but im trying to keep users from having to leave the current database form. THANKS IN ADVANCE!
I have this code set to a button on a split form. It filters out all the blank records for the "Status" column.
Private Sub cmdFilterPendingStatus_Click() Me.Filter = "[Status]" Me.FilterOn = True Me.Requery Me.txtFilterNamePlate.SetFocus End Sub
I would like to do the exact opposite and filter out everything except for the blank records in the "Status" column.
How can I change the code to do this? I guess I should also mention that the "Status" field is a long text/memo box but I can easily change this to short text if I really have to. I realize that short text can do the blank filtering within the split form itself by clicking on that tiny arrow in the column header but I am trying to make it really user friendly where the user can just click a button to do this. The long text box has some options to filter but not for blank fields in a record which makes me think that this may not be possible to do if the Status field remains a long text box. Some examples for the filtering options that are available in the split form for a long text box are: Begins with, contains, ends with, etc... however, when I type "" to try and filter out everything except the records that have null in the Status field, it says that "" is not valid.
I am trying to create a form with control buttons on the form for all the letters of the alphabet. When a user clicks on the button for A, I would like them to only see records that starts with an "A". I assume that I should apply an event to the button's OnClick-property, with a filter, but I can't seem to get it right...any suggestions would be very much appreciated!
Every Page has its on data source based on query, and they aren't related to Parent form or to each other. I want to set few buttons on every Page which would filter records in predefined way.Ex: one page has calculated field named [Za platiti]. It has numeric values form 0 up. I want to set one button to filter only records where field [Za platiti] is greater then 0, and other butt to filter only records where [Za platiti] is = 0. Other filters based on combo box I use regularly.
This is just an example and it is not exactly what my database looks like however it allows me to explain easier.
tblOrders and tblPurchaseOrders are related One-to-Many ( tblOrders.[ID]->tblPurchaseOrders.[AssignedID]).
Anyways, I have a listbox on my primary form that lists tblOrders by ID, Date, Consignee and OrderComplete. When I first built the form and I bound the listbox to column 0 ([ID]) and created the event on double-click which the code looked like this:
Code: Private Sub listOrders_DblClick(Cancel As Integer) Dim stDocName As String Dim stLinkCriteria As String Dim intLinkID As String intLinkID = Me.tblOrders.Value stLinkCriteria = "[ID] = " & intLinkID Debug.Print stLinkCriteria stDocName = "frmManageOrders" DoCmd.OpenForm stDocName, , , stLinkCriteria
Exit_Command23_Click: Exit Sub End Sub
Now, for whatever reason - either something I've changed or a bug somewhere... when I double-click the list item, it opens as a new record rather than the corresponding record. I noticed that the "Toggle Filter" button on the access ribbon was ticked so I unchecked it and it immediately switched to the proper record. Why does this happen and what (if common) changes can make this appear or work this way? I am a novice with Access and I am still learning VBA. I struggle with not knowing parameters by heart, although the syntax seems to be similar to other languages I've worked with.
I had somehow enabled "Data Entry" which is located on the Property Sheet of a Form under the "Data" tab. Apparently this mode removes your ability to actually filter values properly and is intended for what you'd assume it means - Data Entry.
hi, i have a search form, and when you double click on the record, it opens that record in my main form (which opens filtered)
this is fine because it displays the record that i want to see
however, when i try to perform other tasks on my main form, such as choosing the id from a combo box and finding that record, it wont work because the form is still filtered, one way to get around this is to open and close the form, but is there a way that i can implement something into my refresh button that removes a form filter.
Private Sub Refresh_Page_Click() On Error GoTo Err_Refresh_Page_Click
how i would filter a form using an option button. E.g i want to be able to click an option button that is called Filter user and it will filter the query based on who is logged in? and a Filter all option that will clear the filter and show all records?