Question about how a field in a table is used

[Jim C]

Hello All,

I am trying to design an exit interview survey database in MS Access
for my job, and I'm basing it off of the "At Your Survey" database
created by MSMVP Duane Hookom. (You can just do a basic web search to
find and download the database . . .). I'm using the MS Access 2000
version.

My question concerns the RspnsType field in the tblQuestions table.
The MS Access description of this field says, "Possible Values
7-Numeric, 10-Text, 8-Date, 1-Logical (data types in Access)", so I
suppose that those are the entries that you're supposed to put in this
field. However, I can't find any code or queries that link off of this
to make it work. Can anyone explain to me how the database uses the
entries in this field to dictate the data types that are allowed as
responses?

I know that I could just use the At Your Survey database to create my
survey, but I'm trying to understand how it works, too. Thanks for
your help!

Jim

 

[Duane Hookom]

I'm not sure I used this field anywhere in At Your Survey. I had to balance
adding a bunch of bells and whistles while still keeping the demo easy to
understand. I could have added some validation code for entries in the
subform where responses are entered. I chose not to since this might just
confuse survey creators.

The objective of At Your Survey was to show the basics of how a survey
application could be written without a "field per question mentality". If I
added code to jump questions based on responses or other advanced features,
I think it would scare off some potential users.

Feel free to add code in the on current event of the subform to validate
entries based on the RspnsType value. The other intention with this field
was to provide formatting information in reports or queries for numeric
operations.

I could be wrong with this response since it has been a while since I looked
through the code.

 

[Jim C]

Thank you for your quick response, Duane. If I have other questions, I
will post them here.