Is it possible to actually change a number to text? I cant seem to figure out how. I have 2 proprietary systems one uses a number and one uses text for the same item. I know how to change the text to a number however the more efficient way for me to do this is the other way around. Its the differnce from 300 to 400 record change vs 4M. Any help would be great thx.
View RepliesI'm trying to change a 1,2,3 in a table to display NA, Yes, No on a form.
I have an Infopath form with a n/a,yes,no drop down that is dumped into Access. Infopath requires a value be tied to them so it is 1,2,3. So in Access, my table shows the numbers and not the text. I would like to know how to get my access forms to show the text instead. Not sure if I should be setting the field criteria in my query to say if this field is a 1 make it Yes, if 2 make it NO, if 3, make it NA. Or if there is something completely different to do.
I found a workaround by going into the query and using Find and Replace but I need this to update itself automatically.
I have an existing form where users type in information and it generates a couple of reports. In one of the fields, Customer PO Number, the user enters a number from a customer. Up until yesterday all of the customers we have been dealing with have used numbers only for their PO numbers. However, we have a new customer that requires alphanumeric PO's. Is there a simple way to change this field from a number to alphanumeric without having to redo each form, report and/or query. I am using MS Access 2010.
View 9 Replies View RelatedI have two tables(see below). I want to set up a query, link these 2 tables together. I set a one-to-one relationship between Client ID in two table. But got error message :"Type mismatch in expression".
I tried to change Client ID data type from "Text" to "Number", then Access deleted some data under Client ID in Order table.How can I make this work, but not having to re-type in all data?
Client Table:
Client ID(Autonumber)
Client Name (Text)
Client Address (Text)
Order Table:
Order ID(Autonumber)
Client ID(Short Text)
Unit Order(Number)
Unit Price
I have a table with an auto number PK. This table will contain orders. I'd like to use the PK from this table as the Invoice number on the invoice. I'd like to have it start at a number other than "1" just because it looks better on an invoice. I don't know how to do this. I looked at the table design to see if there were options available to me there but couldn't find anything. Is it possible? (I do not know how to use code.)
View 7 Replies View RelatedI have a Form Display Data in my Access Database, which is working really well. However, users was asking if there is a way we can make Font Color Could/would change if The text in A field or Any field in my display form contained the word "SAD or MAD". Is there code for such thing in display form?..
View 3 Replies View RelatedDate of Birth (DOB) field etc. in one program are text - how do I make another file with the same data into number fields for Date of Birth field etc? When I copy data to file that has number fields the 09252004 is changed to 9252004. Can I get reports with the correct Date of Birth in them by moving data from text file to number file?
There is data entered monthly in file and formula has been set up for January, February etc as ---quarter: Int(([month]-1)/3)+1. I would like formula for the fiscal year for April to be counted as month 1, May - month 2, June as month 3, July as month 4, August as month 5, Sept as month 6, October as month 7, Nov as month 8, Dec as month 9, Jan as month 10, Feb as month 11 and March as month 12.
Thank you
have a query with a field that contains numbers with 3,4,and 5 digits. I want to format it so it displays all as 5 digits by adding 0s to the front of the number. EX:
324
4856
45634
change to:
00324
-4856
45634
Help please. Dont want to do it in VBA either. I would rather build it as an expression field or something.
before ACCESS Excel was used to create orders etc,we are up to order number 16223 now I have access and the auto number will start at 1.how can I get the auto number to start at 16223.
View 11 Replies View RelatedCan I change the primary key currently set to my products description to an auto number? I'm trying to make things right, also does the foreign key get an auto number?
View 2 Replies View RelatedIn a field called PSSheets I want the number to be update every new entry, if I use the AutoNumber feature it won't let me enter the number I want to start with, which is 1421001, then the next number would be 1421002 and so on right up to 1421200 and then the number would change to 1422001.
14/21/001 relates to Year/Week/Entry.
I have a randomized table named tblRandomBoxes with the following data:
ID RandomID
1 4
2 5
3 2
4 6
5 1
6 3
I have 6 command buttons named command1,command2,command3, etc. and 6 Labels named Label1,Label2, Label3, etc. On Click of each command button, I want to lookup the ID based on the RandomID and set the backcolor of that label number to a different color.
ie) on command1 click me.Label4.backcolor = 39835
How can I 'build' the label number with the lookup? Here's the code I'm trying, but it doesn't recognize my 'built' label number:
Private Sub command1_Click()
Dim ctl As Control
ctl = "Label" & DLookup("ID", "tblRandomBoxes", "RandomID = 1")
Me.ctl.BackColor = 39835
End Sub
Thanks,
Sup
Is there a way to change the formatting of a numbers column to the formatting :
1 = 0001
11 = 0011
111 = 0111
1111 = 1111
But that would have to apply to this also
1 - 2 = 0001 - 0002
11 - 22 = 0011 - 0022
111 - 222 = 0111 - 0222
1111 - 2222 = 1111 - 2222
If that makes sense ....
I have a report that constists of 4 subreports.I need the first two subreports to render in a two-column format and the 3. and 4. in a single column format.Unfortunatelly I cannot it work as I need to.I have read, that setting the main report in a single-column format and the subreports in a two-column format with "first across then down" setting (Or something like that) is and option.
Unfortunately this option does not fit my requirements.Is there a possibility to set the number of columns through VBA and change it across the different parts of the report?
I want 2 text , when I add a name to text 1 automatically set number to text 2 (Random),
View 3 Replies View RelatedI have Access 2000. I want to update all my records in one table so that they only have 2 decimal places instead of the 10 they have now. What is the expression used to do this?
Thanks
Chad
How can I change a number column in a three digit percent one?Tried the following, however it just deletes the content of the column:
Code:
Public Sub TEST()
Dim a11 As Double
Dim year As Integer
[code]...
="Summary for " & "'Location' = " & " " & [Location] & " (" & Count(*) & " " & IIf(Count(*)=1,"detail record","detail records") & ")"
NOTE: I need the number of the location to convert to the name instead i.e. 6 to Delaware.
So I have decided that I want my ID's to be AutoNumbers, but at the moment they are currently set as Numbers. I have already inserted data, to test, which has been deleted, however I am now unable to change the ID field back to AutoNumber.
How can I duplicate the tables so that this field can be changed again?
I have like 10 tables with heaps of feild, so remaking them will take long, but I know there is a way using queries, I am just not sure how...
I have a table and it is like this 1 a 2 b 3 f let's assume i want to add new data {C} so it will be like this : 1 a 2 b 3 f 4 c
Is their any way i make the table look like this 1 a 2 b 3 c 4 f can i force the auto number to change according to the filter applied on the table is their a numeric field can be used instead on auto number that can be changed according to the filters
Hi,
I have an option group on my form. In my query it uses numbers like 1, 2, 3 and so on.
Is there a way in the query to show say Done where 1 and Not Done where 2 and so on.
On my reports I use the following
=IIf([Status]=1,"Not Satisfied",IIf([Status]=2,"Partially Satisfied",IIf([Status]=3,"Satisfied",IIf([Status]=4,"Waived",IIf([Status]=5,"Client",IIf([Status]=6,"Attorney Consult",IIf([Status]=7,"Attorney Approval")))))))
I am exporting the data to EXCEL and the numbers mean nothing to the end user they want to see what it represents.
Thanks.
Fen How
Hi all.
I have text field with mask:
XXXXX-X
(x are digits), for example - 4 01-1, 4 01-2...
I need find field with text beginning 4 01 and max of last symbol. Last symbol +1, then again convert to text field. For example:
for example 4 01-1, 4 01-2,4 01-3 - must find 4 01-3 , then 3+1=4 and 4 01-4 format again to text.
Please, help me with formatting.
Thank You in advance.
I have a subform that displays doubles in a textbox as fixed with 4 decimal places as default. I have been trying to change the number of decimal places based on the value in a textbox on the main form. I have tried this:
Code:
Forms![Main Form]![Holder_subform].Form![Final PCT].[DecimalPlaces] = CByte(Forms![Main Form].Numdecs)
where [Final PCT] is the textbox on the subform containing the decimal number and Numdecs is the textbox on the main form containing the number of decimals I want to use. I want to implement this Form_Current sub.
I have a report based on a query
and it hase a [Product] and a [Quantity] field
Quantity Product
80 F2 1.25" Fiberglass Sucker Rod
60 F2 1" Fiberglass Sucker Rod
80 1" coupling
60 7/8" coupling
what i am trying to do is multiply the quantity by 37.5 if [Product] equals one of the items that are sold by the foot and leave the other items the same
this is the way it needs to display on the report
Quantity Product_Name
80 (3000') F2 1.25 Fiberglass Sucker Rod
60 (2250') F2 1 Fiberglass Sucker Rod
80 1" coupling
60 7/8" coupling
thanks for any help
How do I change font withing a text string?
for example, to issue a message in which one word is bolded such as...
MsgBox "This macro will not work on Wednesdays"
where I would like to display the word "not" in bold, or even a different colour.
On a form how can i get the text to change to red if the number is Greater than 500 and blue if the number is less than 500, the text box is populated via a query
Jabez