Show Text In Drop Down Box Instead Of Numbers

May 31, 2007

Hi *,

OK, still new to Access so I apologize in advance if that is a dumb question ;)

I have a table "survey" where I wanna store number values (0,25,50,75,100 respectively). The user is supposed to use a form to input the data into the table. For this purpose, he/she is supposed to use a drop down box.

So, is it possible that the drop down box does not show the values but instead a verbal description of these values (very important, important, average, etc.)? What I have tried was to create a table with the number values and use this table as data source for the drop down box... it shows the values but for the end user, verbal descriptions would be better...

Thanks!
Steve

View Replies


ADVERTISEMENT

Numbers Stored As Text Convert To Numbers?

Jan 10, 2007

Ok so in excel I have some numbers that are stored as text. The reason being that they are zip codes and some begin with 0 and excel doesn't want numbers to start with 0....so when I import these into an access field that has an input mask for zip codes...will it convert these correctly since the field is a text with input mask?

View 1 Replies View Related

Forms :: Drop Down Box Show Query

Jan 15, 2014

I have a database with a drop down box that lists all of the contacts in the database. When I select someone in that drop down box it goes directly to their record.

What I want to do is be able to display different criteria in the drop down box based on some criteria. So one criterion might be everyone, another criterion might be only people with a certain product.

How would I do this?

I guess I would like something like, one drop down box selects the criteria (show all clients, or show all clients with a certain product), then another drop down box is based on that one which displays that which was select in the first drop down. Then the results in the form would display based on the second drop down.

View 5 Replies View Related

Tables :: How To Show 3 Values But Display 3rd From Drop Down Box

Nov 20, 2012

I have created a table (data entered/selected via a form) which includes a drop down box, for 'Ethnicity' to pick a value from another table (ie used Lookup wizard to for options from another table).

The row source looks like this:

SELECT [Lookup_Tbl_ethnicity].[Code], [Lookup_Tbl_ethnicity].[Category], [Lookup_Tbl_ethnicity].[Sub-category] FROM Lookup_Tbl_ethnicity ORDER BY [Code];

Setting the ORDER BY [Code] displays the options in the drop down box in the correct sensible order.

The 'Bound Column' is column 3 - Sub-category. I assumed that this would be the 'value' stored, searched and displayed... but the table (and related form) display the Code.

how to change this so that the Sub-category is displayed?

View 5 Replies View Related

How To Show Letters And Not Numbers

Sep 16, 2015

In the attachment. I want to show the letters and not the numbers that is stated in step 4. How will I do this....

View 1 Replies View Related

Generating Car Show Entry Numbers

Feb 3, 2007

I'm building a database for my folks's volkswagen car show (www.texasvwclassic.com) if anyones interested ;)

So I've got a Registrations table and a Classes table. Each person that registers for the show is an entry in the Registrations table, and a field in that table is Class, with a relationship to the Classes table. That is all set up and working fine, but I want to add an EntryNumber field generated at time of checkin, so some VB function I can call when the checkbox is clicked in the form, or a query based off the value of the checkedIn field. I want the EntryNumber field to contain a number like 0503 (CCNN) where CC is the class number (class #5) and NN is a counter of how many people have checked in so far in that class (so 0503 would be the 3rd person to check in for class #5). I can get the class number fine, and I can prolly figure out how to stick em together into another field, but im not sure how to generate the NN part.

In the classes table, each class has a sub-table listing all the registrations that have entered that class. I need like an autonumber field in each of those subtables, but I dont understand how to add something like that.

I hope this makes sense, as always any help is appreciated. =)

View 2 Replies View Related

Filtering In A Report - Show Numbers That Are More Than 2 Only

Oct 20, 2014

In my report there is a field with a number of numerical value. I want the report to show those numbers that are more than 2 only.

View 8 Replies View Related

Reports :: Negative Numbers Show As Positive

Aug 28, 2013

I am trying to have a number that is negative hold its negative value but show as positive when it is displayed on a report.

View 6 Replies View Related

Reports :: Field To Show Ratio Of Two Numbers

Mar 5, 2015

I would like to have a field in a report show the ratio of two numbers i.e. New Customers is 20 and Lost Customers is 24, and have the ratio field to show 5:6 ratio. I know how to do it in an Excel Spreadsheet (=B1/GCD(B1,B2)&":"&B2/GCD(B1,B2), B1 is new customer and B2 is Lost Customer, but I have not been able to figure out how to make it work in an Access report. I tried to do it in a query, I've tried this code I found on the forum, but could not make is work for my problem.

Public Function CalcGCD(OneNumber As Long, OtherNumber As Long) As Long
Dim lngSmallest As Long
Dim lngGCD As Long
Dim i As Long
lngSmallest = IIf(OneNumber < OtherNumber, OneNumber, OtherNumber)
For i = lngSmallest To 1 Step -1

[Code]...

View 2 Replies View Related

Sorting Text Field Containing Both Text And Numbers Sequentially?

Mar 26, 2014

We have a database that we use to track the tablets in our organization, a combination of Apple, Android, and Windows.

We label them with a hostname depending on their branding. Example below.:

APPLE01
APPLE02
APPLE03

ANDROID01
ANDROID02
ANDROID03

WINDOWS01
WINDOWS02

In the database we use the field name HOSTNAME for these entries. When sorting the field, due to it being a text field, we get the traditional sort of

APPLE01
APPLE02
APPLE10
APPLE100
APPLE101
APPLE11
APPLE110

ANDROID01
ANDROID02
ANDROID10
ANDROID100
ANDROID101
ANDROID11
ANDROID110

We would like to have them show up as

APPLE01
APPLE02
APPLE10
APPLE11
APPLE100
APPLE101
APPLE110
ANDROID01
ANDROID02
ANDROID10
ANDROID11
ANDROID100
ANDROID101
ANDROID110

What is the best way to tackle this?

View 1 Replies View Related

Reports :: Average Of Numbers - Show Only 1 Record In Report

Sep 11, 2013

I have a report with 3 fields in it. I have made the control source for each field an average of the #'s in the field of the query. I only want it to show 1 record but can't seem to figure out how. I've already listed the cycle option to current record, but it still shows the 3 fields repeating over and over... for ex:

Field 1 Label 7.4
Field 2 Label 8.4
Field 3 Label 6.4

Field 1 Label 7.4
Field 2 Label 8.4
Field 3 Label 6.4

And it goes on and on like this... the averages are correct, but I only want to show them 1 time, not repetitively..

View 1 Replies View Related

Forms :: Show Current And Total Record Numbers

Nov 27, 2013

This code shows current record number:

Code:
=[CurrentRecord]

This code shows total record number:

Code:
=DCount("[Category]","tblCategory")

How do I combine them in a textbox to say something like "8 of 10"?

View 1 Replies View Related

How To Have Text And Not Numbers In Text Data Type

Jan 13, 2006

I was wondering if there is a way of only allowing text in a text field - we need to do this for validation purposes when inporting a text file into a database. I have tried input mask but this only checks when entering new data - I have tried to use validation rule like"???????" however this means that there has to be 7 letters in each field and this is not the case. - the field is for town and a couple of the records in this field have numbers at the end which are incorrect that we want the database to reject :eek:

View 1 Replies View Related

Show Text Box In A Form Based On Character Within A String In Another Text Box

Dec 21, 2012

I have a form where I want a textbox [txtMaxOrdLimit] to be visible only if another text box on the same form [PaNumber] contains the letter D in the string. This is the code I have on the forms On Current property but I'm missing something because textbox [txtMaxOrdLimit] doesn't show on the form at all.

If Me.PaNumber = "*D" Then
Me.txtMaxOrdLimit.Visible = True
Else
Me.txtMaxOrdLimit.Visible = False
End If

View 3 Replies View Related

Reports :: Text Box From Drop Down Not Working

Jan 7, 2014

I have a textbox that has 3 columns in it (Rank, First Name, Last Name)...when the user selects the appropriate choice, it just shows the Rank.

Ex: Lt. John Smith --> just shows Lt.

To get around this I made an unbound text box and have it set to show all three choices when the selection is made in the drop down box. Unfortunately, it isn't working right. This is the code I am using for the text box:

=[OPRID].[column](1) & [OPRID].[column](2) & [OPRID].[column](3)

Is there anything that looks wrong with this code?

What it ends up showing in the text box is: JohnSmith (no rank, no space between the names).

View 3 Replies View Related

Forms :: Align Combo Box Drop Down Text?

Mar 20, 2013

it possible to align the row source values of a combo box? i want to align it to the right instead of the left

View 2 Replies View Related

Forms :: Referencing Text From Drop Down Via ID Number

Jul 8, 2014

I know this is simple, but I feel like Simple Jack this morning. I'm trying to take the text from a drop-down menu and use that as part of the form caption. However, the text is not what is bound, the ID number is.

View 4 Replies View Related

Enter Text Into A Memo Field Using A Drop Down And Button

Dec 6, 2005

I have this database which has a comments field which often gets the same text added into it depending on what is in it. what I am trying to do is something similar to signiatures in outlook express.

What the end user wants to do is select from a dropdown box what text they want to add to the field and hit a button and it will insert it into the memo (comments) field in the form without overwriting any of the text they have in there already, they might want to just add one of the sentences or several.

Does anyone have any suggestions on how I might go about this?

/locomotion

View 7 Replies View Related

Drag And Drop Listbox Item Into Text Field

Nov 7, 2006

the title explains this..

im not even sure if this is possible.. but if it is it will be just what i need.

basically the job1 form has a search feature added to it..

as users type the passenger name in the form.. a listbox below updates if a match is found..


if you can imagine the situation..

my user will be entering jobs into this form.. they will not know whether or not a passenger has used us before.. the only way they will know is if they see in the listbox the same name.. and pickup/destination/phone no. details as the job they are about to enter


i wondered if it was possible for the user to click on the customer in the listbox.. and drag and drop it into the passenger name textbox..

can this be done.. the attatchment is very simple.. one form.. job1.

if someone can explain to me how to do it.. or perhaps alter the db i have attached i will be most grateful

thanks

View 1 Replies View Related

How To Have Users Drag And Drop A Document Into A Text Box Within A Form

Jul 7, 2015

how to have users drag and drop a document into a text box within a form and have it create a hyperlink. What I need to know now, is if there is a way that when a file is dropped into the text box, it only shows the icon associated with that file, or at the very least, edit the hyperlink to only show a certain text. The files I need to see are all in a networked drive, so the hyperlink addresses can be quite long, and ultimately I'd just like the hyperlink to say "letter". Showing the icon would be a plus.

View 3 Replies View Related

Converting Text To Numbers

Jun 14, 2006

I wondered if someone could help.

I am using the Val () Function to convert a text field to number within a query which still gives me a text output.

P.S I do not have permissions to change within table as using Access as a front end to SQL via link Tables.

View 1 Replies View Related

How To Convert Text To Numbers?

Mar 24, 2007

Hello, I have a Field in a Table called Fund Codes and they are entered as text: 1, 2, 3, 4 all the way to 1000. Now i need to find away to change 1 to 001, 2 to 002, 3 to 003, 10 to 010, but leave 100 as 100 and 222 as 222, so only add 0s to numbers from 1 to 99. Is there a way to do it? I know i can change the text to numbers and use format to do that, but i need to leave it as text. Please help. Many thanks!

View 11 Replies View Related

Treating Text Like Numbers

Oct 12, 2006

HI,
I have a field that contains mainly numbers, but the data type is set to Text because there are a few records where the numbers have a letter suffix.

Eg. Invoice numbers 100, 101, 102, 102A, 103 etc.

These suffixes are a result of poor data entry when the data was stored in Excel.

What I was to be able to do is sort this field and treat all entities as numbers. Currently when I sort it, it shows:

1
10
11
2
20
21
3
...etc

Is this possible, even though the data type is Text?

View 2 Replies View Related

Text + Numbers In 1 Field

Feb 17, 2005

Is it possible to have text and numbers in one field as access asks you specify the data type of that field?

View 1 Replies View Related

Tables :: Drop Header Records During Import Of Text File

Feb 11, 2015

simple table 6 columns
startdate
enddate
custacct
salescost
salesprice
salesqty

the txt file is set up so that there is a header record, 4,999 lines of data, then the same header record, then 4,999 lines of data, then a header record etc etc. for as many lines as is in the download. This is a download TXT file from a Microsoft Axapta ERP system.

I have my table all set up and during the import I want the header records to be dropped. I tried in the validation section for startdate {Not "startdate"} but that did not work. Is there some simple way to ensure the header records are dropped?

View 2 Replies View Related

Calculate Numbers From A Text Field?

Dec 27, 2006

Ok, this one has me stumped.

I have a several fields on my form that are list boxes that must have text as the properties so I can populate the lookup data with things like" Severe rating = 7 points" and "Moderate rating = 3 points". I have another similar field where the choices are "High probability = 9 points" and "Low probability = 2 points" etc. A third field needs to show the total points (product) of the choices from the first two fields, i.e. 9 points x 2 points = 18 points. Then,
a fourth field needs to display where the answer falls in a grid, i.e. 1-14 points = Low, 15-29 points = medium, 30-49 points = high, etc.

How do I apply the calculations on the field choices if the field properties have to be text instead of number?

Thanks,

bugleboy:confused:

View 10 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved