Member Avatar for baabjitvk

hi..
i'm using visual basic 2008. and ms access 2007.
i inserted check boxes in table to get many records at a time. i.e all checked records will be collected.
i have two problems. can you please give me solutions..

  1. how to write a query to meet 'check box is selected' condition
  2. how to collect many records(i.e all the checked records) at a time.

my vb is not supporting ADODB. is there any way to be supported by vb ?

many of my trials lead to numerous errors.. can anybody please help me...?

  • 2 Contributors
  • 1 Reply
  • 186 Views
  • 2 Days Discussion Span
  • Latest Post Latest Post by srkv03
Member Avatar for srkv03

Hi babjitvk,

You can use DAO (add references to your project as Microsoft DAO 3.36 Object Library) and follow these steps
Dim dboSample as Database
Dim rsSample as Recordset
Dim strSQl as String

Set dboSample = Workspaces(0).OpenDatabase(ViewDatabase, False, False, vbNullString)

strSQL = "SELECT YourDBName.ColName FROM YourDBName where YourDBName.ColName = Yes;"
Set rsSample = dboSample.OpenRecordset(strSQl, dbOpenSnapshot)

rsSample has all the records which have the checkbox ticked.

Regards
Sr

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.