Pleae take a look at the attached database, open frmUpdate and select an item in Group1.
I get a message box "Enter parameter Value" - Group1.
After I click OK, sometimes I get a run-time error, usually everything works fine until the form is reopened.
Can anyone see my problem.
thanks
Steve
I am using a combo box to filter a 2nd form upon clicking a button. I posted on this topic the other month and was given some code that works. I am attempting to tweak it for another part of my database.I am receiving a Run-time error "3464': Data type mismatch in criteria expression.
DoCmd.OpenForm "Utilities Contacts", , , "[Utility] = """ & Me.Utility.Column(1) & """"
DoCmd.Close acForm, "Utility Menu"
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!!!
Thanks
i have a table with three column Named
1-State
2-City
3-Customer
on a form i m placing 3 combo box for each column how can i filter combo 2 from table after select value from combo 1
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 created forms for inputting into my database.
First of all a form opens with a choice of opening up another form displaying certain tables to input into.
On the startup form there is also a text box for the user to type in text and then using a command button filter the next form with what they have typed in.
Firstly when they dont enter anything into the text box but still press the command button this error box appears
"Syntax Error (missing operator) in query expression '[Last Name]='."
Then it just has an ok box
How do i get it come up with the message
"Please enter a Last Name before clicking run"
And then an OK
Secondly, once someone has entered the last name in the text box, pressed the command button, and the filtered form has opened and displayed the results, and then they close the results form and return to the original startup form. The text they entered in the text box is still there. Is there anyway of clearing it each time when they close the filtered form.
Many Thanks
Hi,
I am working on an ADP ( first time working with this ). I have a form that is based on a parametized query.
The record source for the form is the parametized query which works fine the first time it is brought up. When the user wants to change the client number, a button "change client" is clicked and the event that gets triggered is openform=("edit client")...... Well, instead of being prompted, I get the error "The ApplyFilter action contiains a filter name that cannot be applied".... When I do a right -click on that same button, and "remove filter "I can get my prompt, but I dont want to keep doing that. I am not sure how to remove the filter from this button. I am not sure what the error message is telling me. Thanks for your help.
Hello All
I have an issue I am trying to resolve and I need some help.
I have a database that I just created in access and pulled in data from an old Approach database.
When I try to do a filter on Form it gives me an error and closes out. I sent the error report to Microsoft and they said to intall the updates. I did that and restarted and still I have the issue of not being able to filter on the form.
I have other forms in this database and I can do it on them, but not on the main form.
Does anyone have any ideas?
Hi All,
Just after a code or way to filter client details via a combo box.
Basically select combox drop down menu select the sales rep then it filters by sales rep and shows only the clients for that sales rep. I can get it to filter but it does the first client of that sales rep but not the rest.
Thanks
Karl
I have two combo boxes, Company Name & Name. The data that is selected is used to run a query from a button. However i would like to set it that if the user (but not required) selects the company name then only the names of the people belonging to that company appear, but if no company is selected then all the names for every company appear.
Can anyone make a suggestion as to the best way to go about this.
Thanks
I've read several threads about one combo filtering a second combo on a form, but can't seem to find a similar enough situation. Can you please advise on the following:
I have a form based on a query containing a whole load of fields from several tables. In particular the query contains a field called WorkstreamID from tblWorkstream.
Each tblWorkstream record has a Workstream ID, Workstream and foreign key called Project ID from tblProjects.
I want my form to have two combos: one for Projects (unbound) which filters the combo for Workstream (bound to the underlying query of the form)
How do I do this?
Please bear in mind, I am not an expert!
Thanks in advance
Sunil
Ok heres the situation, Ive had to edit a piece of code that worked fine filtering but wouldnt allow me to refresh a subform on the main search form. Now im using OpenArgs to pass the Selected bike ID to a popup form. This bike ID should then be used to filter the pop up form. But i get error 2001 (You cancelled the previous operation) when the code is run.
The Code follows:
Private Sub cmdSell_Click()
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "frmSubSell"
DoCmd.OpenForm stDocName, , , stLinkCriteria, , acDialog, Me.frmSubBikes!BikeID
Me!frmSubBikes.Form.Requery
Private Sub Form_Open(Cancel As Integer)
Dim SearchStr2 As String
SearchStr2 = "[BikeID]= " & Chr$(34) & Me.OpenArgs & Chr$(34)
Me.Filter = SearchStr2
Me.FilterOn = True
End Sub
Thanks, Sci
I have a cross-tab query that is filtered on user-defined date range using a where condition of:>[Forms]![Reports_Menu]![txtFilterDateFrom] AND <[Forms]![Reports_Menu]![txtFilterDateTo]
the Query functions perfectly. The report based on that query, however, only functions with a DateFrom that is before 1/28/14 and a DateTo that is after 2/27/14. If I enter a date in either field that is outside of those ranges, I get the following error:The Microsoft Access database engine does not recognize " as a valid field name or expression.I have defined both of my Query Parameters as Date/Time in the Xtab query design.
Hi,
I have a form with a list box that is filtered by the entry made into a combo box. It works fine except that I want an option which shows all records in the list box. I tried using the formula below in the query criteria for the list box but it returns no records when I select All in the combo box. Why won't it work? Is there a better way to do this? Can anyone help?
IIf([Combo32].[Value]="All",Like "*",[Combo32].[Value])
hi all,
another quick question (last one for awhile I promise) but is there a way to add an option to a combo box (Filter by Selection) and Remove/Filter sort without right clicking on it?
cheers,
Andrew
I have a table that has the fields Scheme no, Title, Area, Pole No, Rate No, Description, Quantity. Each Scheme No has a number of Poles attached to it, and subsequently each Pole has a number of different rates attached (eg of table shown below)
On the corresponding form I have ID No, Title and Area in the Form header as they are the same for all fields. Therefore in the detail section I want the rest of the fields. The problem I have is I want the user to be able to choose a pole no from a combo box and show up only the corresponding rates to that pole. So for instance below the user could select in the combo box Pole no YP08 and only the rates used on that pole would show up (in this case it would be just HV99 and its description).
SchemeNo.....Title......Area......Pole Number.....Rate......Description etc
001...............xxx........UK...........YP26.... .......LV01..........xxxxx
001...............xxx........UK...........YP26.... .......HV89..........xxxxx
001...............xxx........UK...........YP08.... .......HV99..........xxxxx
001...............xxx........UK...........YP09.... .......YG67..........xxxxx
001...............xxx........UK...........YP99.... .......LG45..........xxxxx
I hope this makes sense to you. Any help with how I can set up this combo box would be greatly appreciated
Hi There. Im Trying To Filter Records Through A Combo Box Which Is So Far So Good. However What I Would Like To Do Is Select The Records Through The Combo Box And Have It Return And Populate Only Those Records. Has Anyone Got Any Suggestions To This?
Ive Attached The Sample Database Im Working On.
Cheers
I have a form with a combo box on it.
I want to use the combo box to query a subform.
So basically when you click on the record in the combo box it will filter the subform based on the selection.
Is there is a simple way or do I need to be more specific about the requirements ?
Any help would be greatly appreciated.
Domble
I am having an issue with my combo box filter, this set of code dynamically updates the combo box to add any new user and select the accounts that are assigned to them. Given everything works and everything filters, the problem is merely a cosmetic one that has to be fixed.
Basically what is happening is the Combo Box displays "*", and "All Records" but we can not get it too show the "Unassigned" -- any idea why?....
Hello everybody,
I have a problem.
I want to apply a filter on my form.When I filter on the combobox it works fine.
But when I filter on the date the form jumps into the error handler. Below is the code that I use for my filter:
Sub ApplyFilter()
Dim sFilter As String
sFilter = ""
'Filter on date
If Me.txtFilterDatumMelding = "" Or IsNull(Me.txtFilterDatumMelding) Or Me.txtFilterDatumMelding = 0 Then
If sFilter = "" Then
sFilter = ""
Else
sFilter = sFilter & ""
End If
Else
If sFilter = "" Then
sFilter = "[DatumMelding] = " & "'" & txtFilterDatumMelding & "'"
Else
sFilter = sFilter & " and [DatumMelding] = " & "'" & txtFilterDatumMelding & "'"
End If
End If
'Filter on combobox
If Me.cboFilterCallMelder = "" Or IsNull(Me.cboFilterCallMelder) Or Me.cboFilterCallMelder = 0 Then
If sFilter = "" Then
sFilter = ""
Else
sFilter = sFilter & ""
End If
Else
If sFilter = "" Then
sFilter = "[CallMelder_ID] = " & cboFilterCallMelder
Else
sFilter = sFilter & " And [CallMelder_ID] = " & cboFilterCallMelder
End If
End If
If Len(sFilter) > 0 Then
Me.Filter = sFilter
Me.FilterOn = True
Else
Me.Filter = ""
Me.FilterOn = False
End If
End Sub
I hope that you gus can help me. Could it be that the filter is a string and the date filter field is a date??????
thanks in advance.
I have at present 2 combo box's that filter, now....... the 1st combo box is a drop down value list that will filter the OPOwner (persons name) for example there are 3000 records and 5 OPOwners, I can for now filter my name in cboOPOwner combo box.
The 2nd box (drop down list) is Status which would be "New";"Open";Pipeline";"Lead" ect...
If I filter my name it brings up all records related to my name and the when I want to filter status it will bring up all records relating to say 'Pipeline' however it will bring everyone's ;Pipeline and not just mine.
What I want is to filter my name in the OPOwner combo box and once all records are filtered in my name then in the status combo box filter what ever I want to look at. example what I want to filter - 'Filter Neil' then 'Filter Pipeline, or filter Lead or New'.
This is the code I have in both combo's....
Private Sub cboOPOwner_AfterUpdate()
If Nz(Me.cboOPOwner.Text) = "" Then
Me.Form.Filter = ""
Me.FilterOn = False
ElseIf Me.cboOPOwner.ListIndex <> -1 Then
Me.Form.Filter = "[OPOwner] = '" & _
Replace(Me.cboOPOwner.Text, "'", "''") & "'"
Me.FilterOn = True
[Code] ....
I am trying to edit the below code to use 'Form_Select_Batch_Number_Form.Combo9.Value' as the combobox value to filter the records in 'Form_ Remitter_DB_Entry_Form'. I am trying to get the filtering to occur when a button on Form_Select_Batch_Number is selected. Below is my attempt to create the button to accomplish this but it is not functional and needs some work.
Code:
Option Compare Database
Private Sub Command0_Click()
DoCmd.OpenForm "Blank Form2", windowmode:=acDialog
Dim MyValue As String
[code]....
I am back with another question about Access 2010. I would like to filter a table by using a combo box.
I have several columns in the table, and I would like to filter them by their departments (there are several users in each department)
I have tried using the combo box wizard and select " I would like to search records based on the values in combo box" but the problem is that the department shows up as many times as it is in that table.
I came across another solution which was to create an unbound combo box and link it with the query. and the department criteria would be the following:
[Form]![NameOfTheForm]![NameOfTheCombobox]
but it did not work either.
I`m using access 2010 version, i have one table(Customer) which has one-to-many relationship to the table(Order), so the Order table contains many records from one single record in Customer. How to create a combobox that filter and show how many orders the Customer has. Example:
Table(Customer)
Line 1 - Crystal
Table(Order)
Line 1 - Water
Line 2 - Cookies
Line 3 - Pens
Hi all, I’m trying to filter the records a subform shows based on the employee number (in a combo box) that the user selects in the main form. At the moment im getting the following message when I select an employee number in the combo box: “Compile error, method or data member not found”:confused:
Ive searched the forums on here and tried to make use of the information other people have posted but im still having trouble getting this to work
Below is the code I have on the combo box of the main form:
Private Sub Cbo_Emp_Filter_AfterUpdate()
Dim strSQl As String
strSQl = " Select * from DATA-EMPLOYEE_MASTER where DATA-EMPLOYEE_MASTER.EMPLOYEE_NUMBER=" & Form![SCREEN-ABSENCE_TRACKING_MAIN]![EMPLOYEE_NUMBER]
Me.SUBFORM_ABSENCE_TRACKING.RecordSource = strSQl
Me.SUBFORM_ABSENCE_TRACKING.Requery
End Sub
Ive also posted the database if any one is willing to have a look for me (ive removed irrelevant tables/forms/reports). Im using access 97
Thanks
Jim
I'm creating an item look-up form with 2 criteria that I wan't to auto-filter as the user types. I'm placing my code in the Change event of the textbox, and only calling the .text for the current textbox (.value or no property at all for the other). The filter works smoothly and as intended until it returns no results in my table, and then it pops me with the error. I've tried forcing focus to the textbox in different places throughout the code, but to no avail. If I use the .value or no property for the current textbox, I'm not getting the CURRENT text, but the old text before it was changed, so the filter doesn't work properly.
Private Sub txtVendor_Change()
Me.FilterOn = True
Me.Filter = _
"((strSearchVendor Like '*" & Me.txtVendor.Text & "*' AND strSearchItem LIKE '*" & Me.txtPartNum & "*'))"
Me.txtVendor.SelStart = Len(Me.txtVendor.Text)
End Sub
It usually pops the error on the last line "Len(Me.txtVendor.Text)", but I've had it do it on the Me.Filter line as well (only when debugging and messing with next statement placement).