Input Value By Combox Only
Jan 10, 2006
Hi,
In MS Access, the form,
I make one combox, I want anybody input the value by dropdown list, they cannot input the value by typing in keyboard.
How can I lock to enter the value by typing, but they can input it by dropdown list.
Because, if I lock the field, then we never enter the value, if no lock, then we can enter it either dropdown list option or type in keyboard.
I just want to make dropdown list option to enter the value.
Please let me know, thanks.
View Replies
ADVERTISEMENT
Feb 8, 2006
Hi,
I've a unbound combox field in main form, which upon select the subform should display the information. I tried this code but it gives me an error :
Dim strSQLSF As String
strSQLSF = " SELECT * FROM UT_table_EOM_UT "
strSQLSF = strSQLSF & " WHERE UT_Table_EOM_UT.Expr7 = '" & UTEOM_SEL & "'"
Me.UT_Table_EOM_UT_subform.Form.RecordSource = strSQLSF
Me.Requery
Run-time error 2001
You canceled the previous operations
View 5 Replies
View Related
Oct 12, 2005
I ve searched these forums but cant for the life of me find the answer althought there are a lot of posts on combo box filters.
I have MainForm based on tblStaff. I have SubForm based on tblTimesheet.
They are linked by StaffID.
The user selects a Project from ProjectID in the Subform which is filtered to only show Projects assigned to that user. This is done by filtering the combo box by StaffID from the MainForm. Works no problem.
The problem i have is in the next combobox which displays the potential activities for the user. As there are about 80 potential activities i want to filter this based on the Project Role. There are only 5 project roles. I can refer to the project role in either the SubForm query or the ProjectID combobox query but it doesnt work.
I hope this is coherent. Could anyone suggest some code or query parameters for this!?? I'm not an idiot but im beginning to wonder.
Thanks in advance
View 1 Replies
View Related
Jun 22, 2006
hi, umm im tring to copy values from a combobox into a textbox so that multilpe values can be saved on the databse.
the textbox it linked to a table, and the combobox uses sql quries 2 get data from a table... i have a command button which then inserts the vaule from the combobox to the textbox.
in the commmand button the vba code used is:
textbox.value = combobox.value
but this only insert one value to the text box i want multiple value one after the other. it just keeps replace the value which is already in the textbox i want it to add on 2 the value in the textbox...
can any1 help me out?
thank you 4 ur time!
purejoker!
View 5 Replies
View Related
Nov 15, 2006
Hello,
I have a simple question with an answer that hides relentlessly from me. I have a combo box on the main form called cboProjects. I also have a subform called SubProjectsDetails. I'm trying to get it to where if a user selects a project from the combo box, the details show up in the subform. The relationships are good and working, and if I add a Find Record button on the form, that works as well. I just don't know the code to dynamically populate the subform with combo box values.
Anyone have any tips?
Thanks
View 2 Replies
View Related
Oct 10, 2005
Hi
I have a combo box to select a record on a form.
I would like then record to lock once it is selected via the combox box and the combo box to clear.
If a records is slected again from the combo box it will then show the new record and lock it again.
The problem is users are sometimes using the mouse button to scroll and moving to a different records by accident.
Thanks
View 6 Replies
View Related
Jun 29, 2005
Hi every body. I got bounded form as picture below. Initially the form loads all the recod.
I want add a feture to this form so that when i make 4 combo box selection it goes and
load those records that matches that crieteria only . All my controles are in the main form.
I am not using form and subform.I be happy if some one show me how i can switch from show all
mode to filtered mode.(an example higly appretiated)Thanks
http://i5.photobucket.com/albums/y180/method007/comboboxfilter.jpg
( form pic)
View 1 Replies
View Related
Jan 30, 2005
Hello,
I need to create a field in an input form that is simply the concatenation of two other text fields. I have tried all sorts of things, but when I look at the data in the table that field.
I have a field called ID that I want to be created like this:
=Format([UniqueID],"00000") & "-" & [Mosque]
This works well in my output fields, but does not work the same way on the input form. It needs to be based on the currently input values from the current record. Anyone have any ideas?
Thanks in advance,
--Robert
View 3 Replies
View Related
Sep 22, 2015
I need to be able to query the service dates for the bill. So I can query 1509 for the .billYYMM and .readdate and it will give me the TO Date. How do I in the same query tell the query to subtract 1 from the BillYYMM that I just entered and give me the read date for that field in that query? So Query 1 MBRHISTDETL.BILLMOYR and in the criteria box use [Enter the Bill Month Year YYMM you want to search for] will allow me to run the query at any time for any bill month year that I enter. So another field in that query is MBRHISTDETL.READDATE. So to get the FROM date and the TO date i need the following MRBHISTDETL.BILLMOYR (whatever I enter as input) and MBRHISTDETL.READDATE that corresponds and then I need [MRBHISTDETL.BILLMOYR]-1 and MBRHISTDETL.READDATE. The first gives me the TO date and the 2nd gives me the FROM date?
View 5 Replies
View Related
Feb 7, 2007
hi guys
i hvae a situvation that i hvae to take password from the user for that i am using inputbox option to take password. the problem is if i use input box we can't mask the input text box as far i know. so do we hvae any other option without creating another form for that.
thank you
View 4 Replies
View Related
Apr 26, 2005
HOW DO I DO THE FOLLOWING:
I want to use input mask in my email field i.e the @ must be present but i must be allowed to input values or numbers before and after the @. This did not worked because i have fixed the values: ????@????
thanks
View 2 Replies
View Related
May 2, 2005
Dear All,
Is there any way that I can use an input mask to enter serial numbers of softwares.....
the data will be like this...
ABC8F-CHJ68-FH76F-GHF87-67JH5
Thanks in advance
Thanks
View 1 Replies
View Related
Jun 29, 2005
I am trying to uses a inputbox. I need it to end the script if cancel is hit, but the value from the input box can be zero? So cant filter it that way.
Also
Does the SQL command LIMIT work in access and is it possible to number row in order?
View 4 Replies
View Related
Sep 15, 2005
What I have is field called contract number, and its entered as 09-0011, which is ok.
Now I like it to show up in a different field as 090011. I guess my first question can this be done. Or even better how would I do it?
Now your question is. Why don't you put it in correctly the first time, and the answer is we want the number to have a dash.
Any suggestions
Never can be easy for me.
View 3 Replies
View Related
Oct 24, 2005
Does anyone know how to get input from a com port and parse it into access?
View 1 Replies
View Related
Jun 21, 2006
Hey all, I am currently looking to make a great database system for use within my community. What I currently have is a mdb with just 3 tbls but will be building from there. I have the normalization down thus far, but wanted to put things out there for any suggestions or ideas to make this a useful system. This is not a profit situation, and will generally be used only by myself or possibly one or two others.
What I have is a database that tracks the homeowners within our community (subdivision) and their properties. So far I have 3 tbls
tblOwners
- OPkey (autonumber)
- OFname
- OLName
- OStAddress
- OCity
- OState
- OZip
tblUnits
- UnitPKey
- StNum
- Street
- PIN
- Check2005
tblJct
- UnitPKey
- OPKey
Structurally this works great so far. I can easily relate properties to their owners and link multiple properties to those who own more than 1 (landlords). I structured it this way since the two tbls had many to many relationships, so the junction tbl made the most sense.
Now I am looking to add information from a tract search (mortgage holder information) which technically relates to both of these tbls (Unit & Owner) as well. I already know that most of the owners with multiple properties will most likely have the same mortgage holder, but that is not definitive. Since the same mortgage holder could easily be associated to multiple properties within the community, I know I have to have an independent tbl for that information as well.
What I would like to head for is something that will allow me to send notifications, letters, flyers and the likes to either the owners, residents, mortgage holders, or any combination of the three. I have attempted to create a few thus far but have issues with getting all of the required data output to Word, so I am thinking I may need to design these items in a Form instead.
Any thoughts or comments would be appreciated. I know I am heading in the right direction, but just putting it out here for the Access community to put in their 2 cents.
View 3 Replies
View Related
Jan 13, 2008
Dear fellow forum members have been trawling the forum but unable to solve what seems a simple issue.Have a form with a field for a short date input.I would like the year to be input automatically and the user to be left to input day and month.Have played around with format(date(),mm-yy) but unable to crack it.If someone can save me another sleepless night I would be more than grateful.
View 3 Replies
View Related
Jan 31, 2005
let's say i have a field, in which i store and identity card number. This number may consist up to 7 digits (of which 3 are mandatory) plus 1 letter (mandatory) at the end. Thus a valid identity card number may be the following: 1234567M, 123M
Eventually, since the field must always contain a letter, i set the data type to Text with field size of 8 ... and i set the inout mask as follows:
9999000L (since the first 4 digits are mandatory). With this input mask, if i have an ID Number of 123M, i have to input it as 0000123M.
Although, I would like to have the leading zeros, is it possible that during data entry time, i would simply type 123M, and i will get the zeros automatically, after the field loses the focus, rather than having to type them myself ?
Thank You
View 13 Replies
View Related
Sep 12, 2005
I want to force user to input state in capital letters, ie; CA, CO, WA, etc., with two text characters only. Working in design view, I used this character: > in the input mask field property area,
which I understand (perhaps mistakenly) will convert characters to uppercase. Now, I cannot enter any info in the state field.
Any help would be most appreciated.
View 1 Replies
View Related
Oct 2, 2005
Hi Guys,
I posted on this forum a few months ago chasing a solution and still haven't found something. Is ther any way in vb that you can prompt the user to input a number? I was posted the code below to try and help. In the example below, i would like to be able to have the end user input the first and last numbers (11000 and 11100, in the example) in a pop up box, as these vary, not have them defined in the code, is this possible? In the database, the first and last numbers in a string are all that is needed and the db fills in the gaps, so to speak
Const MyTable As String = "YourTableName"
Const MyField As String = "YourFieldName"
Dim db As DAO.Database
Dim rs As DAO.Recordset
Dim intCounter As Integer
Set db = CurrentDb
Set rs = db.OpenRecordset(MyTable)
For intCounter = 11000 To 11100
rs.AddNew
rs.Fields(MyField) = "TP" & intCounter
rs.Update
Next intCounter
rs.Close
db.Close
Set rs = Nothing
Set db = Nothing
Thanks for any help you can give. I hope it is pretty straight forward, as my vba skills are fairly limited.
View 5 Replies
View Related
Oct 18, 2005
Trying to set an input mask to Capitalize the first letter of a surname but also to do this for ie MacDonald or O'Brian? How can i do this?
View 1 Replies
View Related
Jul 19, 2006
When you add a new column you can select different data types such as text, memo, currency,...
When I pick currency and typ in 12345 in the column and press tab it automatically puts the € sign behind 12345.....
View 1 Replies
View Related
Feb 22, 2007
Hey guys,
I'm creating a database based on an Excel file. The Excel file has about 180 columns and are only linked by to distinct fields. Is there any possible way that I can break this down into easier to manage tables? There are different categories of columns such as
Financial Info
Personal Details
Products
Requirements
I'm not too sure how to link these categories other than the two distinct fields I've mentioned and I know it's not a good idea to have 5 tables with identical primary keys across all 5. Can anyone offer some input?
View 5 Replies
View Related
Sep 2, 2007
I am trying to create an input mask for a name field. I have Spanish names with two last names separated by a hyphen, a comma after the two last names, a space, and then the First Name a space and the Middle Name. The First Last Name needs to be in all capitals like the example. Example: NARANJO-Ramirez, Jose Luis
Can someone please help me format this mask. One trick is that there aren't always middle names. Since all parts of the name are different lenghts for everybody, I need to have an optional number of characters for each of the four parts of the name.
Thanks for your help.
View 2 Replies
View Related
Dec 1, 2007
Input/Output
I’m reading “Selecting the Data” from Running Microsoft Access 2000, pp. 87-94. The confusing part is the input/output explanation. When I think of input I think of typing, keying, or entering raw data into the computer. Output to me is information displayed or printed.
Okay, here is what was printed:
“A data item is an input for a task if you need to read it from the database (but not update it) to perform the task. For example, a customer name and address are some of the inputs needed to create an order. Likewise, data is an output for a task if it is new data that you enter as you perform the task or that the task calculates and stores based on the input data. For example, the quantities of items you enter for an order are outputs; the shipping address and phone number you provide for a new order are outputs as well.”
The above is confusing me. Can anyone explain it better so this dummy can get it? Thanks!
View 5 Replies
View Related
Mar 3, 2008
I'm having an usual problem. I can input the value "BVE" in a table field and save it. When opening the table back up, the value is changed to "BE".
Any ideas??
Thanks.
View 2 Replies
View Related
