I have the following input mask for a certain field in an ACCESS 2010 table : 00-000-a-a-a;0;-
It works fine. That is when I tab down to it and if I know that the format is : xx-xxx-x-x-x
but if someone does not know the format , things can be out of position.how do I code the field such that the format (xx-xxx-x-x-x) is displayed in the input field awaiting the actual keying of the data?
From a table I want a text field which has a path to a file to be copied automatically into a another field of the same table with a hyperlink text type...
View 5 Replies View RelatedI have a form that utilizes a combo box with 2 options: 0 & 0.5. If I select 0.5 on the combo box the field in the table records it as 2. Why doesn't it reflect as 0.5? And how do I fix it?
This is the general info that I have for the field properties:
Field Size - Double
Decimal Places - 1
Default Value - 0
I need an input mask for a general date field. When I add the date "11/01/2012 10:00:00" it works fine.
When I add an input mask of 00/00/0000 00:00 it then doesn't work.
I'm trying to set an input mask for a text field.
The data will be 1 to 4 digits preceded by 1/
I have tried the masks 1/####;; , "1"/####;; 1/####;; , "1"/#### , '1'/#### but none work as if the first nubber entered is a 1 it replaces the 1 in 1/
If it is a 2 then it works fine.
I can set the 1 to and f (f/) and it works no problem.
Designing a table of companies.
Need a field containing the website adresse for each company.
MS-Access 2013 does not offer such a field format.
On a form I can create it, click on it and it will open the website.
But that way it opens the same website instead of different websites for different companies.
I tried the hyperlink format but it did not work.
I would like to format the AutoNumber field so that it shows the current year - #...i.e. 2012-01.
View 4 Replies View RelatedI have a table, at the table I'v got these fields:
ID | num1 | num2 | sum
I want that the user put numbers at 'num1' and 'num2' fields and then the 'sum' field will calculate automatically the operator (sum=num1+num2).
I've tried to put any combination at 'Default value' of the sum field (all the fields are numbers , also tried to change the sum field to text...nothing works).
I'm getting a message that 'num1' field is not recognize at the table
(I tried =[num1]+[num2], without the '=', num1.table+num2.table , ...nothing works)
I also tried to do it with SQL command but it dosn't work.
There is any way to do it, is it possible? Or other way to do it at least at Form or at Report ?
I have a table which will contain project information, and want the ID field, which auto assigns a unique number to each record, to be formatted like this P12-001, where 12 = the last two digits of the year the record was created. I know that if I type into the format field "P"00"-"000 i get the ID number in the format I want, but cannot figure how to get the first two zeros, to be the date format.
Further, I would like the ID numbers to restart from 1 each year, so this year this first project, P12-001 and may run through to P12-063, then the first project I enter next year to start P13-001.
How to display field types of access tables in vba?
can any one show me how i can display display field types(like : phone integer ....) of
access tables in a text box using vba? I have no idea how i
can obtain that information using vba. Looking forward to your
replys.Thanks
I want a field that I will enter the current work experience of an employee years and months and i would like it to update as time passes. I am willing to accept it displayed as a decimal, i.e 4 years 7 months would be 4.7, I would just need to have it calculate on base 12 but I don't know how?
View 1 Replies View RelatedHiya everyone,
I'm try to do a database for items with part numbers.
& I want to be able to set the field to only accept data which has two letters at the begining, but any other characters after that (no fixed size).
ie.
part num1: pn047589sdf8m3
part num2: pn6583
part num3: pnfdgmj5973m
part num4: pn-fdgmj-5973m
Is this possible to do?
Cos all I can do at the moment, is to put a fixed number of characters.
ie. is the field size is 30characters
then I'd have to do this:
>LLCCCCCCCCCCCCCCCCCCCCCCCCCCCC
but this isn't good.
I just need something like:
>LL*
* mean any character for as many characters in length.
Adam
BIGmrC
I have the following query.
SELECT Table.*, Table.Date
FROM Table
WHERE (((Table.Date) Between [start date] And [end date]));
Is there anyway I can format the box that prompts you for the start and end dates? I would like the format to be, mm/dd/yyyy ? Any help?
I am trying to create a calculated field in my table, I am trying to use the following code:
DatePart("ww",[Gas]![Date Opened])
I receive the following error message: "The expression DatePart("ww",[Gas]![Date Opened]) cannot be used in a calculated column."
Access 2007 - I really need to be able to display the week number in the table, based on the Date Opened field.
I guess this is pretty fundamental but I cant get it right! I want to search for a member by post code so I need to have validation for my table field post code so that when my parameter query accepts the post code input records will be returned covering all input types e.g. Users can put in CF72 (space)9AD or CF729AD and still get the same records or alternately how do I make users enter Post Codes with the correct UK spacing i.e 4 characters a space then the remaining characters?
View 7 Replies View RelatedHi,
I am creating a database where the serialID can be a number of different 'formats'. TBH, I don't know if this can even be done in the first place, but on the off chance that it can....:p
Firstly, i'm not sure whether to use Input Mask or Format...
But the serial may be '1234567AB', '12345678AB' or '12AB1234AB'.
Or to put another way
'7 numbers 2 letters',
'8 numbers 2 letters'
or '2 numbers, 2 letters, 4 numbers, 2 letters'
I have tried creating a mask such as '00LL0000LL' (can't remember exactly, had some '9's in there too some where...) but just keep hitting a brick wall, whereby it not satisfying all of the types.
Any help much appreciated, Ben
I have a query which is pulling its data from a form, which in turn is pulling data from a table. When I select 0.82 on my form, my query runs fine. But when I select 0.826856 from my form the query does not return any result.
0.826856 is available in the table and the pull down list in the form. The data format for all my table, form and query is General and decimal places is set to 8.
Could you plz tell me why I am not able to run the query using 0.826856 ????
Hi All,
My Querie:
I have a relational database, that is basically made up of a few tables, I will
simplify for this to two.
TblFieldNames and TblFieldValues
Basically using a form you can fill in a field (TblFieldNames.FieldName) and it
is then appended to TblFieldValues.FieldValue.
On the form the properties of the input text box are changed according to the
record selected in TblFieldNames.
Ie. ListBox with FieldNames from TableFieldNames
ListBox_AfterUpdate sets properties of
TxtValue
The Issue:
I have a Field in TblFieldNames that has a setting of Currency.
(TblFieldNames.FieldType = "Currency")
I have changed the TxtValue.Format = "Currency"
It doesn't:
A. Allow entry as a currency, ie. $ sign and thousand seperators
B. Append the details to the TblFieldValues Table, which it is going across to
into a field that is set as Text (this can't change)
I have tried:
Changing format of input Txt box
Changing Input Mask for inptu Txt Box
"$###,###,###" but doesn't work for me....
"/$###,###,###"
"/$###,###,###!"
I want it to allow me to enter in the Value as a Currency and append the value as a currency
ie.
Key Press = 12345
Field Shows = $12,345
Appends this value as Text?
Key Press = 1234567890
Field Shows = $1,234,567,890
Etc
Any ideas?
All, using access 2010. How do I display the default value of a date/time field to just the current year instead of using =date() to get the full date.
View 5 Replies View RelatedHello,
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
Hi, I would like to create a Custom input mask in access 2000 with the format dd/mm/yy can someone please help me?
View 1 Replies View RelatedI have problem loading data from an excel file in to a table. I usually import the excel file in to a table via VBA script (because there are some changes I need to do before importing).It was working fine until this week when the data in a cell for a particular column in the excel file changed from being 3 letters to 4 letters. The column in the table is defined as text.
The data in this column usually looks like 001, 002, 003 etc but one of the cells in the excel file has data as P001.So now I get an error Runtime Error 3349 even though I have defined the column as text. When I change the data P001 to 004 similar to the other data, it works just fine. Is there a format or Input Mask I can set so that the data are correctly loaded in to the table?Or am I missing something?
How do I apply this - can't seem to get it right - just want to control user into putting whatever and two deciimals for pence.
99.99 input mask is halfway there - except I don't want to limit the pounds amount. putting 99999.99 makes entering 12.31 etc a little awkward.
Cheers
Is there a Input Mask or Rule Validation that would automatically or require user to input data into Access field in a proper case format? Such as my text would be "My Text" when viewing the actual table? If so how would you do it when in Design View of Table.
View 1 Replies View RelatedI wanted to assign the field "Number of magazine" with special format based on date/time format but showing only year and month in the format: "yyyy-mm".
So in property of this field in format I put yyyy-mm and in input mask I type 0000-00;;-
I also created the form based on the table containing above field and I defined format and input mask for corresponding formant in the same way like at the table.
But if I try to type date for example 2014-01 in text box of the form it comes up with the full date 2014-01-01. Why does it do like this? What do I do incorrectly?
NO matter what I do I can't get the InputBox to work
Code:
NewEmailAddress = InputBox("There is no Client Email Address on file would you like to enter one?", "Information Required")
It just won't display or stop at the above command.