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.
Hi,
I have a text box on a form to enter doc id's. The doc id's can either be a single letter followed by six digits or two letters followed by six digits.
I can create masks for either of them but not so it allows either of the options to be entered, is it possible to create a mask to cover both options?
Thanks
I was wondering if anyone could point me in the right direction..
I'm working on a database for work :eek: there are a million things giving me a headache (I've attended two 1 day courses but haven't a clue :rolleyes: )but one little thing that is annoying me is a problem I have with input masks..
In my Contacts table, I have First Name, Surname, Company, etc..
I've made the first letter of the first name and surname have a capital letter ie;
FIRST NAME
Field Size: 20
Format: *Is clear*
Input Mask: >L<CCCCCCCCCCCCCCCCCCC
SURNAME
Field Size: 20
Format: *Is clear*
Input Mask: >L<CCCCCCCCCCCCCCCCCCC
COMPANY
Field Size: 30
Format: *Is clear*
Input Mask: >L<CCCCCCCCCCCCCCCCCCCCCCCCCCCCC
I have a problem in that, usually company names contain more than one word plus PLC or LIMITED at the end.. I want to be able to make each word start with a capital but as the lengths vary, I don't know where to put these in the input masks :confused: :o
Any help? I'm sure it's easy but I don't know :o
Hey all,
I had a question about input masks. The boss wanted all the fields to automatically capitalize names and last name. Did that, was happy for awhile. What we didnt realize is that there are names like DiGianno or McDonald that still need caps in certain spots.
The original input mask went like this: >?<CCCCCCCCCCCCCCCCCCCCCCCCC;;
This mask would caps the first letter and lowercase the rest.
What i need it to to is CAPS the first but leave whatever may follow up to the user..
In other words.... The first letter is always caps, the rest that follow is up to the user, upper or lower.
Is there any way to do this? Couldnt figure out a solution! :(
Any help would be appreciated
Mateo
Does an input mask have to be static? The format for the numbers entered in a control in my form is digits separated by periods for WBS number entry (9.9.9.9.9). Each '9' will represent a digit. I want to allow the user to enter different depths (ie 1.1, 1.2.3, 1.2.2.1, etc.) up to 5 levels.
Is it possible to make the input mask automatically adjust as more numbers are entered?
Greetings
I was wondering how I go about this?
I have a table that holds vessls and barrels in a winery. When I enter data via a form I have a lookup to showme the location of a vessel or barrel. The vessels are static and have a two letter location ie WT or RT etc. The barrels, once filled are put in different locations in a warehouse. Each location has a code ie WW011121 etc.
I have a range of codes in the form as follows;
Private Sub Location_Enter()
If IsNothing(Me.Location) Then 'means it is probably a barrel
'and needs a warehouse location
Me.Location.InputMask = ">LL00000"
End If
End Sub
Private Sub Location_Exit(Cancel As Integer)
If IsNothing(Me.Location) Then 'tried to leave without a location
MsgBox "Location Required", vbCritical, gstrAppTitle
Cancel = True
End If
End Sub
What I wish to write is some code to find a ducplicate location in the warehouse not in the static locations.
What I have written thus far is;
Private Sub Location_BeforeUpdate(Cancel As Integer)
If Me.Location.InputMask = ">LL00000" Then
then the air code would be to find duplicates from there.
Would it be best to compare string length (clues needed) as the static locatons on have two letter where as the barrel locations will have two letters and five numbers. Or is there a trick in dcount to look at bits of the contents of a field? ie ignore fields with on two letters and do a dcount in fields with say two letters and five numbers?
I do not have any experience writing code involvine string lengths.
Thanks in advance
~rbinder
I have my database done, for the most part. But I want to add a lookup to a field in my Component table so that I can associate a particular number (paragraph number in a pub) to a failure mode description. In the Failure Mode table, I have associated a paragraph with a failure mode:
Example: 6-66.2Visual
6-66.8Continuity
6-66.8Insulation
Yes, some paragraphs have more than one failure mode. The primary key for this table is an autonumber which allows me to do this with minimal headache.
When I created a lookup within the appropriate field in the Component table, it erases my format/input mask and makes it look like this:
6662 Visual
6668 Continuity
I wasn’t able to put an input mask in the General tab of the FailureMode field in the Component table – I guess because it has the paragraph AND the failure mode in the lookup and 9-99.99;;_ just won’t cover the text for the failure mode description. The input mask is present in the Failure Mode table but isn't "crossing over" to the lookup!
I REALLY need those “masks” in the paragraph callout to help me distinguish and match the failure mode! Can someone please explain how to do this?
Thanks!
I have a field in a table with the input mask LLL0000;0;_
when I use an append querry to put data in the table it still puts in data which does not follow the input mask. Is there some tick box I have not checked or somthing because this is getting really annoying.
All help really appreciated.
I'm using a simple input mask via the wizard for a date of birth field in a table, but the table is accepting entirely invalid dates such as 32/12/2005. When I tried inputing something like this in the wizard it says invalid input, so why is it valid in the table?
Should I set validation rules?
I tried this:
>31/12/2004
and set the validation text to "Invalid data"
i.e. limiting input to less than 31/12/2004... but it still didn't work.
Can anyone help?
thanks
I have a form control with the input mask on it for a phone number. I am using an append query to append the information entered in the form to a table. I need to pull two fields from a linked table from another database. What I need to do is be able to compare the entered phone number in the form with the phone number from the table. The problem I am running into is that it won't match the phone numbers. The same mask is used in the table I am pulling from. Why can I not just put =[Table].[Phone_No] in the Criteria of the field where the number from the form is placed so that I can get the right record from the linked table?
View 4 Replies View RelatedI have a field in my table called SATS. This is then on my form as a control bound to the SATS field in my table. The application is for a surgery where the person doing vitals ( blood test and HPpressure testing) need to enter the redings. The norm is 96%RA80 tHE 96 never goes beyond 100. The RA will always be there and the 80 can be higher up to three digits.
What i manage to do so far is this 99\%LL999;;- the problem is that the R has to typed everytime. How can i set it to __%RA__
I have is that if we want to scan the past consults and link it to a patient. What are the requirements?
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
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 Relatedhi 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
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
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
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?
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.
Does anyone know how to get input from a com port and parse it into access?
View 1 Replies View RelatedHey 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.
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 Relatedlet'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
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.
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 RelatedWhen 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.....
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?