Search Combo Box - Cannot Browse Through All Matches
Nov 20, 2011
I have a database that keeps track of customers by last name, first name and various other information. I have the combo box setup so that I can type in a last name and it brings up my results. The problem is that it only brings up the first match and doesn't let me browse through all the matches. The last name and first name are seperate fields so if I look for a last name that more than one customer has like smith it only takes me to the first match. Is there any way to make it filter all the names that aren't matches out of the combo box as the values are typed in?
I adapted the findform from the address book sample database. After the search is performed I would like it to be able to continue to browse (continue scrolling through) the rest of contacts rather than excluding everything but matches. More like a go to kind of search rather than a select query. I'm betting this is a simple fix (I hope), I just don't know what it would be. Any help?
I have a search combo box to search for a field on my form. But it just goes to that particular record. The combo box is for client id and it has more than one record. How can I have it return just the records pertaining to the client id choosen in the combo box.
I was wondering whether it is possible to use a combo box to select a set of records in the same way as you use a ‘LIKE’ statement in the Criteria of a query.
Basically, I want to choose (from a combo box) a year from which to display a set of records in a report.
Hi, I currently have a table with a load of customer details: tblCustomer and i have a form with a combo box that looks up the customer's record with a drop down menu by the surname then the firstname columns from tblCustomer.
The problem i have is there will be over 2000 customers in the system eventually, and a drop down box just isnt going to work, so i need a method of somehow when the menu from the combo box comes down, of selecting a letter from the alphabet and then a list of all the customers with surnames beginning with that letter showing up.
Is it possible to create a combo box to search for a record using "like" for the search. For example, I want to type in "Fred" and the combo box will show any record that has "Fred" in the field: Fred Roberts, Frederica Adams, or Adam Fredericks.
I have a combo box that is filtering a form. The combo box contains employee's last name. However, the field that it is looking up can contain more than one name (e.g., possibilities include just Smith, Smith & Johnson, Smith & Jones & Johnson, etc.).
Thus, when I click on the combo box, I want all records containing "Smith" to show up. However, I have only been able to bring up exact matches. Here is my code. Thanks in advance.
Dim strSQL As String Dim strSQLSF As String
Status_CB = Null
strSQL = "SELECT DISTINCT Pipeline.Status FROM Pipeline" strSQL = strSQL & " WHERE Pipeline.[Lead_Person(s)] = '" & S_MD_CB & "'" strSQL = strSQL & " ORDER BY Pipeline.Status;"
Hi I was wondering if it is possible if I press a key on the keyboard say 'c' once I've opened the combo box, that I will be taken to name in the SECOND COLUMN that begins with c. At the moment if I was to press 'c' it will take me to a unique identifier that begins with c as the unique identifiers are in the FIRST column not in the second.
I have a db which has a field called site_id it a table called sites. I have a form called sites which uses this table as a record source. I would like to make a combo box on the form as a drop down whenever the user selects a new site id it will take them to that ID on my form. I saw where you can do this with the wizard when your add the combo box to the form but it says I need to use a different table or query. Any one know how to use a combo box like this? Thanks..
I am new to access and trying to create a combo box that will enable the end-user to select a field in a database. Then type in the information in a text box to search for information in that field. For example: end-user can select MAC-Address and then type in the MAC-Address number to locate it in the database.
I have created the form and combo box but it will only search the rows of the table.
I have a form that has a combo box that is used to populate data in the detail section of the form, I just added 2 text boxes to search and fill same boxes. They both work, but My problem is after you search using the text fields the filter that the search used stays and causes my combo box not to work unless you go into design view and delete it from the filter property. Any thoughts on how to fix this?? Advance thanks
I'd like to search a combo box on a subform for a string containing a (or multiple) '?' on click of a command button. The point of this is to inhibit the submission of a record with ????? as a field value (in a combo box), however it is temporarily allowed before submission of the form.
I tried this on the command button and it didn't work:
If Me!Subform.Combobox.SelText = "?" Then MsgBox("Error") End If
I think I am referencing the combo box on the subform incorrectly..
What I am trying to do is split a sentence into words LikeJocelyne Labylle And Jacob DesvarieuxThis would produce 4 words as the and,&,/ Ect are removedSo I end up with:-JocelyneLabylleJacobDesvarieuxIf all 4 words are found in a string it returns all matching records plus gets 100%3 words again returns all matching records plus say 75% and so onI haven't done a lot with it at the min as the first bit is quite simple IE getting the names Etc. but I can't think for the life of me how I can do the search.I Have Tried a query With [Names] Like ""*[String Names]*""" but it seems to only work with each letter???but my main reason for asking here is I don't like reinventing the wheel or at least trying to which will mean hours of Fun but maybe somebody knows of something I could use on the net.Thanks for any help/Advice.mick
I'm comparing two tables in a query, the tables are information that was imported from other sources. When I compare the tables, I'm trying to get a one to one result (a reconciliation of sorts). The problem is that there are duplicate line items in one of the tables that may or may not be valid, but all are considered matched. How can I create my query to match to only one line item and leave the others unmatched for analysis? I've tried everything but VBA (of which I have little experience in). Any suggestions?
I have a form that shows a customer number and a dollar amount. In a subform, I want to show all the records with that customer number that are "close" to the dollar amount. For this purpose close can be INT(amt1) = INT(amt2). But I can't figure out how to put that in the parent/child relationship on the sub-form.
I am trying to find company matches between 2 tables. The issue I have is that the spellings on table A differs from table B.Some of the differences are minimal like "St. Annes" and "St Annes". And some really big "St. Annes" and "Annes, ST London".
I have created a table which holds transactions which can be both positive and negative. To this table i have added an extra column that shows the Absolute values which end results is as follows:
I need to create a table that shows those positive and negative transactions that can be netted of. I have been able to create a query with the following SQL code:
Code:
SELECT tbl_All_Absolute.[Posting Account], tbl_All_Absolute.Jnl, tbl_All_Absolute.CCYY, tbl_All_Absolute.PP, tbl_All_Absolute.[Batch Num], tbl_All_Absolute.[Trans Num], tbl_All_Absolute.[Detail Reference], tbl_All_Absolute.Amount, tbl_All_Absolute.RFPNum, tbl_All_Absolute.[Transaction Ref 1], tbl_All_Absolute.[Transaction Ref 2], tbl_All_Absolute.[Transaction Ref 3], tbl_All_Absolute.[Transaction Ref 4], tbl_All_Absolute.Expr1 FROM tbl_All_Absolute WHERE (((tbl_All_Absolute.Expr1) In (SELECT [Expr1] FROM [tbl_All_Absolute] As Tmp GROUP BY [Expr1] HAVING Count(*)>1 )));
Unfortunately (but obviously) the code will list 3x the 50,000 transactions and leaves out the 49.995.
My knowledge in Access is not that of an expert and i am wondering if there is a way for Access to only include the first 2 transactions (the +50.000 and the -50.000)?
I currently have an unbound form I am using as a switchboard. When a button is pressed it loads a form asking for the user to enter their password (the swtichboard is then closed). If the correct password is entered the form opens to their details, when that form is closed, the swtichboard re-opens. I want an action that if the correct password is not used, then a msgbox lets them know and then the Switchboard they were at re-opens. So far I have the following code:
Private Sub Form_Open(Cancel As Integer) If Me.Recordset.RecordCount = 0 Then MsgBox "Incorrect Password!" Cancel = True End If End Sub
This works well, but I am unsure how to write that after the msgbox I want the Switchboard to open. I tried to add "DoCmd.OpenForm frmSwitchMain" in various places, but I am unsure on the proper procedure to do this.
I'm trying to incorporate a combo box in my form to navigate through records. The plan is to select a piece of equipment listed in the combobox, and that record will then be displayed as an "after update" action.
However, I have tried through coding I have tried before and utilising the wizard to create this combo-box, but each time I get a "Complie Error - Can't find project or library".
The section of code is shown below:
Private Sub Combo227_AfterUpdate() ' Find the record that matches the control. Dim rs As Object
Set rs = Me.Recordset.Clone rs.FindFirst "[EquipmentID] = " & Str(Nz(Me![Combo227], 0)) If Not rs.EOF Then Me.Bookmark = rs.Bookmark End Sub
Hope someone can help me with this as I am not sure where I am going wrong. I have two combo box's on a form which are linked to a query which when run SHOULD (this is my problem) populate a subform I have set up on same form. If I run suborm or query on its own it works OK but I cannot get it to work from the main form. I have attached sample of DB so you can see what I may be doing wrong.
As an example lets say I have a table listing some cars:
Car Make Car Model Ford Fiesta Ford Focus Ford GT Mercades C Class Mercades E Class Mercades A Class
I am making a form with two combo drop downs with the ability to select car make or model.
Car Model is Unique so if the car model is entered, I will force the car Make into the other combo box
however, If i select "Mercades" for example in the car make, I would like the combo box of Car model to only be filled with the possible models that Mercades make.
Is this possible? (to search for the values available in Car Model based on the value entered in Car Make?)
