Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
Password Reminder
Register
| FAQ | Members List | Search | Today's Posts | Mark Forums Read
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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old January 12th, 2007, 11:23 AM
Registered User
 
Join Date: Jan 2007
Location: Ahmedabad, , India.
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
Reply With Quote
  #2 (permalink)  
Old January 12th, 2007, 05:44 PM
Friend of Wrox
 
Join Date: Mar 2004
Location: Yorba Linda, California, USA.
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?



Reply With Quote
  #3 (permalink)  
Old January 13th, 2007, 10:20 AM
Registered User
 
Join Date: Jan 2007
Location: Ahmedabad, , India.
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

Reply With Quote
  #4 (permalink)  
Old January 13th, 2007, 12:17 PM
Friend of Wrox
 
Join Date: Mar 2004
Location: Yorba Linda, California, USA.
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.


Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


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



All times are GMT -4. The time now is 01:50 PM.


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