Database and checkes..

I have an Access database. How can i write all of records that my database has and how can i create checkboxes for each record?. Ex: i have 5 records and i want my form reads all of the records and writes all records and creates one checkboxes for each?

Thanks
yarasakolAsked:
Who is Participating?
 
SpideyModCommented:
All,
I am unlocking this question in preparation for cleanup.  I will return in 7 days to finalize this question.  Please leave any recommendations for the final state of this question, I will take all recommendations into consideration.  Failing any feedback, I may decide in 7 days to delete or PAQ this question with no refund.  Thanks.

SpideyMod
Community Support Moderator @Experts Exchange
0
 
ITugayCommented:
Hi yarasakol,

can you be more specific? Do you wish to have checkbox in first column of DBGrid or just new TCheckBox controls on form where every checkbox has a caption like record in the table?

-----
Igor.
0
 
CrazyOneCommented:
I am little confused. Are you talking about records(a record can have 1 or more fields) or individual fields each having its own check box.


The Crazy One
0
Cloud Class® Course: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

 
yarasakolAuthor Commented:
I have a database that has 2 fields price and name. I want to list all of the record while record.eof and put a checkbox for each record that was listed. Sorry for my english...
0
 
CrazyOneCommented:
Do you want to store the checkbox value in the Database? I am not being nosy but just looking for clarification by asking what is the intent of these boxes. In other words what are they going to be used for. This info might help us to figure out how to find a solution for you.

BTW your english is good. :>)
0
 
yarasakolAuthor Commented:
When i list the records from database and put checkboxes each i will calculate whic records are checked and give a report to a user. But i don't want to use checked or not checked in DATABASE. Just on Form..
0
 
kretzschmarCommented:
in short

? add a calcualted field typ boolean, get a free dbgrid which are providing checkboxes for boolean fields, use the oncalculate-event and set the calculated field to true

meikl ;-)
0
 
pisceanCommented:
Use TListView to display the data. Setup the columns (Double-click the control and add 2, price/name, setup the captions). There's a code in the bd5 help file for sorting the rows according to the clicked column.

TLISTVIEW:
Checkboxes = True
ViewStyle = vsReport
ReadOnly = True
RowSelect = True

To retreive the records:
Table1.Filter := '';
Table1.First;
ListView1.Items.clear;
while not Table1.EOF do
  begin
    with ListView1.Items.Add do
      begin
        Caption := Table1.FieldByName('NameField').AsString;
        SubItems.Add(FormatFloat('#,##0.00', Table1.FieldByName('PriceField').AsFloat));
      end
    Table1.Next;
  end;

To determine checked items:
for I := 0 to ListView1.Items.Count-1 do
  if ListView1.Items[I].Checked then
    {your stuff here ...}
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.