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.
Can anyone help me?
Cheers
Bikeboardsurf :confused:
hey guys, i have this code which will let you type into a combo box "db" and it will pick out the selection "Die Cut / Back Slit". the following code works except for an error message coming up before it goes into the code.
"the text you entered isnt an item in the list"
anyone know how i can get around this? i tried turning warnings off on the sub but it seems to happen by default before the sub?
Code:Private Sub cmbCut_KeyPress(KeyAscii As Integer)' if pressed not enter or tab , add to a string then select value from entered chars'enter or tab key pressed (added delete and space keys to miss adding to string)If KeyAscii <> 13 And KeyAscii <> 9 And KeyAscii <> 8 And KeyAscii <> 32 Then enteredChars = enteredChars & Chr(KeyAscii)Else DoCmd.SetWarnings False Select Case enteredChars ' get letters entered and set value from combo Case "S" Me.cmbCut.Value = Me.cmbCut.ItemData(0) Case "B" Me.cmbCut.Value = Me.cmbCut.ItemData(1) Case "D" Me.cmbCut.Value = Me.cmbCut.ItemData(2) Case "DB" Me.cmbCut.Value = Me.cmbCut.ItemData(3) Case "T" Me.cmbCut.Value = Me.cmbCut.ItemData(4) Case "F" Me.cmbCut.Value = Me.cmbCut.ItemData(5) Case "FS" Me.cmbCut.Value = Me.cmbCut.ItemData(6) Case "FC" Me.cmbCut.Value = Me.cmbCut.ItemData(7) Case "FSC" Me.cmbCut.Value = Me.cmbCut.ItemData(8) Case Else 'do nothing End Select enteredChars = "" DoCmd.SetWarnings TrueEnd IfEnd Sub
In my forms I would often like to move forward or back a records, usually a date by keyboard alone.
The keyboard arrows are good but they are normally used to navigate along a line etc.
Page Up & Down again better & often used for moving between records but do sometime need there native functions.
Trying to avoid changing the functions of these keys depending of what part fo the form I am on or current function I an doing.
It would have been great if there was a Alt Left or Ctrl Left that gave a different ansii.
Alt N - next, Alt P - previous, not pretty.
I have a subform when a user presses Return Or Enter it doesnt go to a new record but instead enters a new line in the same records how can i prevent this from happeneing.
View 1 Replies View RelatedI have a form which consists of 20 similar subforms. The subform has only two fields.
When I want to go to the next subform, I use CTRL TAB
But I want to use only TAB.
I have tried a couple of things with the keypress event of that control, but cannot find a solution that works. What I would like:
- when the user is pressing TAB in the last field of a subform, that the program reacts like CTRL TAB and goes to the next subform.
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.
View 5 Replies View RelatedYea yea I know, another one...
But the way I see is that I haven't asked them all so its ok... :p
Right basically, I only want to allow input of Y N or P into a text field. I thought it would be best to do it with an onkeypress event as I know of no way to block certain characters in a text field with an input mask.. this is what I came up with but it doesnt seem to work...
If Not KeyPress=78 Or Not KeyPress=80 Or Not KeyPress=89 Then KeyPress = 0
Any ideas?
Hello All
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.
Thanks in advance for your help,
Harold Clements
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.
anyone have any ideas please?
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.
Thanks
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..
View 5 Replies View RelatedI 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..
Who can tell me why I don't have following option in the Combo Box Wizard?
"FIND A RECORD ON MY FORM BASED ON THE VALUE I SELECTED IN MY
COMBO BOX"
I am appreciate!
Dear all,
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
Any help gratefully received!
Thanks,
Steve
Is it possible to create a combo box to list all record ID, when selected that record appears on the form?Ifso how would i go about this?
Thanks in advance?
Andrew
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.
Thanks for any help
Rgds
It wont populate the pertinent fields.. where have I gone wrong. DB attached.
View 8 Replies View RelatedAs 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?)
The idea is populate the 2 Comboboxes and year and after that query something like:
Code:
SELECT FileEntryNo, GroupCode, SubGrpName, SubGrpNo, FileNo, GroupName, Subject, NameTo, NameFrom, ConnectedFile, DocumentDate, Month,
Spelmonth, Year, Reference
FROM dbo.Files
WHERE (GroupCode LIKE 'XXX') AND (SubGrpName LIKE 'YYY') AND (Year = ZZZ)
So after the query is executed the results will be available on a third Combobox that after selecting a record will show the detail on the fields.
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?
View 3 Replies View Relatedschool has thrown me in to a bodemless ms access pit. can do a bit of VB but queries...I´m new to this stuff. i am glad to have found this fine forum.
i have:
-1 table: tblSpeler (65 entries)
-1 form: frmSpeler (already conected to a search query)
-1 search form: frmZoeken
*2 combo boxes: zoektekst (mp3 player make), zoektekst2 (mp3 player type), search button (cmdZoek).
my question:when i select a make, and then the type » i want that the form shows me the mp3 player with the selected make and type.
if more info needed, just ask. thanx
i have a search form (see atachment1) with 2 combo boxes.
i have a pruduct form that runs on this query:
Code: SELECT * FROM tblSpeler WHERE (((tblSpeler.merk)=forms!frmZoeken!zoektekst1) And ((tblSpeler.type) Like forms!frmZoeken!zoektekst2));
if i start the the product form, it asks me for the make, and then for the player » it finds the right player in the form.
but via my search form it won´t work. it only opens the product form and no records are shown.
so: in the search form, when i select a "make", and then the "type", and then press search. i want it to show the right record in the product form.
+
when i select a make (eg "apple"), i want the type combo box to exclude all the types that are not from apple (eg only: ipod mini, ipod 20gb. right now it´s like in atachment2.
i know this is a common question, been trying to figure it out with a eg database, but i can´t get it done. all help is welcome
thanks,
-d
I have a combo box that searches for surnames in my database. if there are two surnames the same, it brings up the first one. if this is not what i want then how can I ask it to search again instead of just pulling down the list and searching manually?
View 1 Replies View RelatedI used the Contacts demo on Access 2010, made all the elements Client from web based and then exported to a new database. It worked for the most part but now I am trying to put in a 4 box search and am getting stuck on which form to link it to and also where to put these boxes.
View 1 Replies View Related