borderAndreaVB free resources for Visual Basic developersborder

borderAndreaVB Visual Basic and VB.NET source code resources - Copyright © 1999-2007 Andrea Tincaniborder

AndreaVB | Forum | News | Downloads | Register | Help | Member List | Statistics | Search | PM | Profile

Print This Topic
Next Topic (any sample of bus ticketing database?) New Topic New Poll Post Reply
AndreaVB Forum : Database : Make field in Access appear as checkbox
Poster Message
dwsteyl
Level: Graduate

Registered: 17-09-2007
Posts: 9

icon Make field in Access appear as checkbox

Hi there

I'm working in Visual Basic 6. I've created a database in Access 2000, that I connect to via ADO.

One of the fields in each record is a Boolean on which the user is suppose to click "Yes/No" - exactly like a checkbox.

I display the entire table from the database in a grid (for ex. MSFlexgrid etc). Is there a way to make that specific column appear like a checkbox, instead of a "0" or "-1"? Of course the value would be read as "0" or "-1" depending on whether or not the field has been ticked of. The problem is that the normal user would not know what "-1" means.

Any help would be appreciated!

Thanks!

05-11-2007 at 02:45 PM
View Profile Send Email to User Show All Posts | Quote Reply
xtramac
Level: Professor


Registered: 28-08-2005
Posts: 94
icon Re: Make field in Access appear as checkbox

that will not be possible.  

06-12-2007 at 06:59 PM
View Profile Send Email to User Show All Posts | Quote Reply
dwsteyl
Level: Graduate

Registered: 17-09-2007
Posts: 9
icon Re: Make field in Access appear as checkbox

Does that mean that Microsoft missed that functionality when they designed VB6?

That's something that should be a pretty basic feature. How would you do that if you had to?

07-12-2007 at 05:25 AM
View Profile Send Email to User Show All Posts | Quote Reply
stickleprojects
Level: Moderator


Registered: 09-09-2002
Posts: 907
icon Re: Make field in Access appear as checkbox

Hi
That is extremely possible, and depends mostly on the grid that you are using.
The datagrid in .NET supports check boxes using column styles.
Google for "MSFlexgrid checkbox" came up with a lot of solutions, are they any help?
http://www.planet-source-code.com/URLSEO/vb/scripts/ShowCode!asp/txtCodeId!43129/lngWid!1/anyname.htm

____________________________
Build it better, faster, quicker, easier.. then fix it (non-offical MS mission statement)

07-12-2007 at 08:50 PM
View Profile Send Email to User Show All Posts | Quote Reply
AndreaVB Forum : Database : Make field in Access appear as checkbox
Next Topic (any sample of bus ticketing database?) New Topic New Poll Post Reply
Surf To:


Not Logged In? Username: Password: Lost your password?
Partners: Download Actual Software | Free Software Download
borderAndreaVB free resources for Visual Basic developersborder

borderAndreaVB Visual Basic and VB.NET source code resources - Copyright © 1999-2007 Andrea Tincaniborder