I am trying to produce a query that will search for multiple records by job id entered into a text box eg 17656,18768,15679.
The example i have found uses the (LIKE '*value*') so if i type in part of a job id (176) it will display all records starting with 176. I would like to enter specific job id numbers seperated by a , and only display these
Would be grateful for any help
I’am a fairly new to access I have a Database with forms, on one form that is linked to the student table you can put in all the student details.
what I want to do for the post code is have a drop down box with two place names that have different formats for there post codes E.G London : LL0 0LL and Cardiff : LL00 0LL , depending on which one is selected the corresponding mask would be applied to the Post Code text box.
Any Suggestions will be much appreciated.
I have table(fruit) with 5 fields - apples, pears, grapes, oranges and lemons.
Say i have a shopping list apples -5, grapes -6 and lemons -2.How do i get this into the table.
My idea have combo box that you can select the apples, grapes and lemons from.
Have input form
label(apples) input(5)
label(grapes) input(6)
label(lemons) input(2)
how can i do this.
A few weeks ago I had a post in which I asked how a user could type in the text value of a list of selections in a list box, and arrive to that selection.
Such as if they type in "A" then "B", it goes to "Abby" rather than "Aaron" then "Ben". It was answered that this was not possible in MS Access with a list box, so after that I basically told the users I would look into it more.
I have finally cleared off my desk and arrived back to this small issue.
I thought of the idea to add a Drop-Down Combo Box to the form. I could use the functionality built into the Drop-Down Box to allow them to type in the person they are looking for in the List. Then click a button labeled "Find" and it would take them to the correct person in the list box. They could then function as before.
I just could not figure out the code to put behind my "Find" button. I am not sure if you can do a "Goto record" against a List Box, or a "Find record" against a list box.
Has anyone run into this issue, and if so, was there a way to work around it?
Thank you,
T.J.
Access Table. I pull small data from excel to access and in Table "Sub Activity" Field is thr if in this filed "Exception","Random Fee" and "Missing Fee" is thr then in Last Field automatic "Exception" should come and if "Correction" is thr then "Correction" shd come like this if "Plant Check" and "Plats" then "Plats" shd come.
View 2 Replies View RelatedI have an MS Access DB, that uses a list box to give users a view of the possible selections to choose among.
It works great, but the database has grown to the point there are nearly 3,000 items in the list box.
I found that if you type in the first letter, it will take you to the first alphabetically in the list with that letter.
So if I type in "A" it takes me to "Aardvark". But even this could use improvement, as typing in the first letter with 3,000+ selections means the users may scroll a few hundred to find what they are looking for.
Is there any code, or property setting that can set it up, so the users can type in the entry and it will narrow it down?
So if they type in "AS" it goes to "Assumption" rather than "Aardvark" then jumps to "Sail" (as it does right now).
Thank you for your help,
T.J. Bernard
Probably an easy one here...I have a series of cascading combo boxes where once the last once it chosen, I'd like some sales info to populate in a group of text boxes. What command would I use for this?
Also, I have a checkbox that I'd like to use to either enable or disable a textbox as well. Any ideas?
Thanks!
Hi
I have an text box with an input mask of
>???????? to convert the text entered to capitals
1. Are there any other ways to convert to capitals?
2. With the way i have done the input mask if you click anywhere in the text box the curser starts from there. I would prefer it if no matter where in the text box you clicked the curser starts from the beginning
How do i do this ?
Thanks
I created a button that when pressed concatenates any items selected in a list box and places them in a text box on the form with the format of "itemselected1" or "itemselected2" or "itemselected3"
However, I need to set the criteria in a query to look at this text box and return the results based on that selection. When I do that I get no results even is the query should run fine with that type of format.
Attached is a copy of the Code for the button and the result
Dim txtValue As String
Dim varItem As Variant
Dim strlnameselect As String
Dim intCount as Integer
'Cycle through selected rows in listbox
For Each varItem In Me.Queueselect.ItemsSelected
intCount = intCount + 1
Select Case Len(txtValue)
Case 0
txtValue = Chr(34) & Me.Queueselect.ItemData(varItem)
Case Else
txtValue = txtValue & Chr(34) & " Or " & Chr(34) & Me.Queueselect.ItemData(varItem)
End Select
If intCount=Me.Queueselect.ItemsSelected.Count Then
txtValue = txtValue & Chr(34)
End If
Next
'Assign variable value to textbox
Me.Queuetorun.Value = txtValue
End Sub
the result in the text box is
"A" or "B" or "C" or "D"
I have a combo where the list is populated with a bit of VB code to create a two field list. When the user selects the item they want from the list it displays the item in the combo box and should populate a text box in the same row with the value from the second column.
This combo is part of an orders subform and the user is selecting a product from the list which displays the product_name and the product_id.
The problem is that the product_id is not filled in and access returns the following error:
Run-time error ‘3101’:
The Microsoft Jet database cannot find a record in the table ‘product_table’ with key matching field(s) product_id.
This is the VB code that populates the list :
[code]
Private Sub comboCatagory_ID_AfterUpdate()
Dim sProd_description As String
sProd_description = "SELECT products_table.product_id, products_table.prod_description " & _
"FROM products_table " & _
"WHERE products_table.prod_catagoryID = " & "'" & Me.comboCatagory_ID.Column(0)
Me.comboProd_description.RowSource = sProd_description
Me.comboProd_description.Requery
End Sub
[end code]
What am I doing wrong?
Thx
Kev.
I'm pretty new to this type of programming and i was hoping for a little help,
I have completed the majority of my program it's just a few little things i need to tweak.
The main thing is that i am trying to get a text box to autofill from a selection in a combo box i.e.
i have selected a drop down box with 3 coloums looked up from another table i would like 1 of the columns to stay in the combo box after selection and the other two to appear in the text boxes on the same page.
Any help would be much appreciated.
thanks
Brad
I have a table with a field name compliance level which is filled with drop down list and having like this;
poor
good
excellent
IR
Now what I want is if i select poor from list then in query it generate -10 in query field named analysis, same if select good then generate 10 and so on means i will assign numbers for each field...
One can select only one item like, poor at one record entry...
I am trying to auto populate the text boxes in the form based on drop down from the combo box. As you can see in the form Frm_Input, this works fine for FL, but for some reason it will not populate for Skill, Role, FLM and Location. The table it is linking to is Tbl_Names. Why as I have changed the column source?
View 8 Replies View RelatedHello, all.
I have created a project in Access 2003 to track a student's progess toward a college degree. I want the user to enter their student id in a text box on a form, look up if that user is present in the student table, and if not show the form to enter their student information.
I can't get the text box to accept user input, and return the student info as a single record on the form. I have a query but I don't know how to set the proprerties to run the query.
Thanks for any help.
I want numeric only input for a certain textbox. I can use a ISNUMERIC function to test this, but prefer to use the Keypress event. So far got the following:
Code:
Private Sub txt_Position_KeyPress(KeyAscii As Integer)
Select Case KeyAscii
Case 8 ' backspace
Case Asc("1") To Asc("9")
Case Asc("-")
If InStr(1, Me.txt_Position.Text, "-") > 0 Or Me.txt_Position.SelStart > 0 Then
[code]...
It is working alright, except I want to avoid input that has multiple leading zeros, such as 00000 or -00000 (i.e. minus sign with mulitple leading zeros).
I have a textbox where I need an afterupdate event, which should check that input is 3 letters followed by 3 numbers. The total is 6 characters, but always 3 letters + 3 numbers. If condition not met, a msgbox will be shown, for the user to input correctly, before being able to continue.
View 1 Replies View RelatedIs it possible in Access to use an input value (text) as a field name? I want to access a field based on what the user enters.
View 6 Replies View RelatedI have a table with a field named 'Comments'. On the form, I would like to have a text input and a command button. After the user enter the comments onto the textbox and subsequently click on the command button, the comments will be input onto the 'Comments' field of the table.
Q1. How can the text box be link to the 'Comments' field of the table?
Q2. Only after I press the command button then the input text on the text box will be transfer to the table. What is the command for that?
In the database attached I have a form called from Candidates.In this form is a combo box where a user can select what company the candidate belongs too.
However some candidates are Private Individuals (do not belong to a company).Therefore, I want the Position field to be set to 'n/a" by default if 'Private Individual' is selected.
I have a form based on a query.On the form I have 4 comboboxes.The combo boxes filter eachother without a problem (based on custom select query).Now I want after the fourth combobox value is selected, I want to populate a text field with a value from a different column from the master query (after the 4 selections only 1 value should be possible)I try to say this easy.Master query contains 5 columns:
- group
- type
- job
- insurance
- charge
combo1 selects group (and filters records)
combo2 selects type (from remaining records and filters again)
combo3 selects job (from remaining records and filters again)
combo4 selects insurance (from remaining records and filters again)
[code]....
This works great and the dropbox only shows 1 OF EACH DIFFERENT record...If I add a text box and want to see the "charge" value, that I thought I could use the ME.text-code. But in order to do this, I have to add the charge column into the query of Combo4.the dropbox for insurance gives me multiple values that are the same. Is there any way to make this work?
Good day... beginner Access user (converting from Lotus Approach) and need some help please. Please excuse my novice... I'm on a deadline at work and need help:
-- Data source: MS Excel Table
-- Database form: MS Access 2003
My form is using the excel table as its data source. There are two fields: TELEPHONE AND FAX
When I try to use the input mask in Access to view the numbers in TELEPHONE FORMAT, it keeps telling me the input mask works only on text or date fields. Do I have to first modify the field format in excel? What does this error mean?
I'm trying to apply a custom input mask to a text box control. The text box must contain a 43 character string, broken into sections as follows :
AAAA-AAAAA-AAAAA-AAAAAA-AAAAAAAAA-AAAAAAAAAAA-AAA
(The format is quite strict and always comprises alphanumeric characters , hence I figured an input mask would, if nothing else, support the user to key the string accurately from its constituent parts...)
However, when I try to apply the input mask to the text box, I seem to run out of characters - I get as far as the below but the input mask wizard won't let me extend the mask to the final 8 characters
AAAA-AAAAA-AAAAA-AAAAAA-AAAAAAAAA-AAAAAAAAAAA-AAA
Are input masks restricted to 35 characters in length? And if so, how else could I make this, admittedly complex, text input more manageable for end users?
I have 2 text boxes and 1 push button for each text box for input to table. When I click on 'SaveInput1' only Input1 is save onto the Table and when 'SaveInput2' is click only Input2 is save. I want each command button to save each input separately.
I know ACCESS have a SAVE RECORD function, but I do not want to use this because it will save the entire record all at once.
TextBox1 = Input1
TextBox2 = Input2
Commandbutton1 = SaveInput1
Commandbutton2 = SaveInput2
I have a combobox on an unbound form. After making a selection, I click a command button which opens a bound form to a new record. What I need to code next or add into the macro, is for the selection of the combobox to fill in the contact id, and contact name in the correct text boxes.
The combobox row source is: SELECT qryPBS.ConID, qryPBS.PBSName FROM qryPBS; bound column 1.
I am trying to populate multiple text boxes from combo box using one table. First text box is getting populate on base of combo box value while 2nd text box is not getting populating.
I have used the following to populate the text boxes, even row count is correct, But why is not 2nd text box is not populating ?
=[Combo2].[Column](1)
=[Combo2].[Column](2)
One thing I noted when I provide the control source then selection gets stop from combo box...I am giving the valid control source is customerID but its not working.Could it be the reason ? Why selection gets stop from combo box when provide the control source ? If remove the control source then 1st text box is getting filled on basis of combo selection and 2nd text box value is not getting filled as describe above.
I have a listbox with several options.
When the user selects one of these items, i want a combo box's text to be changed to the selected item in the list box.
The listbox is named : D_OutputLsb
The combobox is named : D_ComponentNameCmb