Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / General 2 / January 2008

Tip: Looking for answers? Try searching our database.

Display numeric value as text label

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Lafayette - 15 Jan 2008 22:51 GMT
Design a database for survey. In the input form, users are faced with a text
listbox, with choices "strongly agree", "somewhat agree", and so on. However,
the responses are actually stored as numeric values, say,  

"strongly agree" = 7
"somewhat agree" = 6, and so on.

How shall I realize it? Appreciate the answer.
Jeff Boyce - 15 Jan 2008 23:27 GMT
Can't tell from your description, but there's a possibility your survey data
is set up for ... a spreadsheet.  Take a look at Duane Hookom's AtYourSurvey
as a model for data structure.

See:

   http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane

Regards

Jeff Boyce
Microsoft Office/Access MVP

> Design a database for survey. In the input form, users are faced with a
> text
[quoted text clipped - 6 lines]
>
> How shall I realize it? Appreciate the answer.
Lafayette - 16 Jan 2008 00:56 GMT
Thank you, Jeff. The sample database indeed accommodates the issue I have on
hand.

But since it's so sophisticated, I can't figure out how that actually works.

Does anyone have a concise anwer for my problem: display numeric value as
text labels. Or conversely, store texts as numbers.

> Can't tell from your description, but there's a possibility your survey data
> is set up for ... a spreadsheet.  Take a look at Duane Hookom's AtYourSurvey
[quoted text clipped - 19 lines]
> >
> > How shall I realize it? Appreciate the answer.
Jeanette Cunningham - 16 Jan 2008 01:31 GMT
Lafayette,
this is a very common thing to do. The usual way is to have combo box on the
form ( can also use a listbox).
The combo box has 2 columns, the 1st column is hidden and contains the
number corresponding to each choice.
The combo's row source is a query, table or a value list.
In your case you might have a value list if only a couple of choices. It is
easier to use a table if there are several choices.
So you might create a new table with 2 fields, the 1st field is a number,
long intereger, default value leave blank - name the field ChoiceNbr
the 2nd field is text, name it Choices. Save the table as tblSurveyChoices.
In the table enter your data with the numbers in ChoiceNbr and their
matching descriptions in Choices.
The combo box on your form has tblSurveyChoices as its row source.
Set up the combo box on your form so that when a user selects 'strongly
agree', the form stores the number 7 in the database.
This long description is only half of the process, you need to set up the
main table that records data in a way that in can store the number selected
in the combo box. This gives you the idea, but not all the info you need to
make it work. See the sample databases on ComboChoosesRecord.mdb (
beginner )
This illustrates how to have a combo box in which you can choose a value and
have that record appear in the form. at
http://www.rogersaccesslibrary.com/download3.asp?SampleName=ComboChoosesRecord.mdb
to see how this all works.

Jeanette Cunningham

> Thank you, Jeff. The sample database indeed accommodates the issue I have
> on
[quoted text clipped - 31 lines]
>> >
>> > How shall I realize it? Appreciate the answer.
Lafayette - 16 Jan 2008 07:45 GMT
Thank you Jeanette. Your example is very useful. I've figured it out.

> Lafayette,
> this is a very common thing to do. The usual way is to have combo box on the
[quoted text clipped - 59 lines]
> >> >
> >> > How shall I realize it? Appreciate the answer.
user2 - 18 Jan 2008 03:26 GMT
¿À ¸¶ ÀÌ °«!!!!
> Thank you Jeanette. Your example is very useful. I've figured it out.
>
[quoted text clipped - 71 lines]
>> >> >
>> >> > How shall I realize it? Appreciate the answer.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.