Wrox Programmer Forums
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old January 12th, 2007, 11:23 AM
Registered User
 
Join Date: Jan 2007
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default DATABASE RELATED QUESTION

HI ,
I want to store student information in MS-Access dabase.
my problem is that how can i display student ************ on vb form.
mead i have a field in access named st_************ that is logical type.
on vb form i want to connect them with option control.
my problem is that option control don't have data property so how i can store data which is user input on vb form.

anybody help me.thanx in advance
-DK
 
Old January 12th, 2007, 05:44 PM
Friend of Wrox
 
Join Date: Mar 2004
Posts: 217
Thanks: 0
Thanked 1 Time in 1 Post
Default

DK-
Welcome to the Forum.

Are you sure you really want to make that field a boolean (yes/no) value? How about making it text with a length of 1 and allow only "M" and "F". Then if the user DOESN'T choose, they are not assigned by default. Are you attaching to an option button control or a combo box?



 
Old January 13th, 2007, 10:20 AM
Registered User
 
Join Date: Jan 2007
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default


thanx for take interest in my problem. your idea is good that make a charater field length is 1 but
Actually i think it not not better way. because i have see some software that use "option control" for boolean data type.so can u tell be more...
 DK

 
Old January 13th, 2007, 12:17 PM
Friend of Wrox
 
Join Date: Mar 2004
Posts: 217
Thanks: 0
Thanked 1 Time in 1 Post
Default

DK,
Try this:
1) Recommend you then make the gender field a byte. Assign "1" to male and "2" to female.
2) Use the Option Group Wizard. (From the tool box) Make the first value label "male" and the second "female". The value of "Male" should be set to 1 and female to 2.
3) Select no default value from the wizard. Then for the Option
Group control, set the Control Source to the Gender field. (with your Option Control selected, select the "data" tab>Control Source.)

This will get you the type of control you want in the interface, and it will help keep your data meaningful. If you treat ************/gender as a boolean (yes/no) datatype you run the risk of someone who does not answer being assigned an incorrect value if they skip the question.







Similar Threads
Thread Thread Starter Forum Replies Last Post
Anchor tag visited CSS related question mat41 Classic ASP Basics 0 April 16th, 2008 05:55 PM
gdi+ related question ashwinikalokhe C# 0 September 10th, 2007 02:43 AM
database related query dkvaseeta Pro VB Databases 2 February 22nd, 2007 10:59 AM
Question of Combining Multipe Related Tables mariushung VB Databases Basics 0 January 12th, 2005 03:06 PM
Insert on 2 Related tables question acdsky Classic ASP Databases 1 July 21st, 2004 09:29 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.