help me out......

[subhadrasn]

hai
i am basically working in mainframes and i am anew kid to access and vb.
I hav to create access database in backend with form as frontend.My database has 17 fields and i hav included that as checkboxes.what i want now is: when the user clicks the checkbox(It can be more than 1) and then clicks the summit button on the form, it has to retrieve data from database.How can i do that???

Please help me out....

Thnx in advance.
Subhadra

 

[namliam]

If it is a bound form, it is automatic...

 

[subhadrasn]

but i donno how to find out ????
what is bound and unbound?

 

[namliam]

*Geez*

Bound = Based directly on a table or query...

Go to design view of your form, if your textboxes say "UNBOUND" it is unbound, otherwize it is bound...

 

[GaryPanic]

also why have you split these up into FE and BE

yes this is the right thing to do - but easier to do this last i.e. keep it together then use the wizard to split FE/BE after you have finished

 

[GaryPanic]

also why have you split these up into FE and BE

yes this is the right thing to do - but easier to do this last i.e. keep it together then use the wizard to split FE/BE after you have finished

 

[subhadrasn]

my checkboxes r unbound only..
wat shall i do now??
Thnx Gary and Thnx namliam (in advance!!)

 

[GaryPanic]

right back to basics

on click of a box say box1
it does something
so on your afterupdate of box1 = ??
if box1=true then
if box1 =false then something else

you need to go into a bit more detail as to what you are trying to achive

 

[subhadrasn]

thnx Gary,
I now hav another pblm.I get the output in separate datasheets.can i merge the output into a single datasheet(and not in word)??

 

[GaryPanic]

Sure

you need the format of you data to be the same ie
cloum n1 refno
column 2 product
column 3 whatever
etc

now we get into temp tables get your qry to work normal fashion
and have them append to a temp table (this will delete itself after you close the d/base down) but I would recommend some sort of complie routine to be built into your d/base on exit (see samples on this )
so each main record will have if box1 = ticked or true(yes) then qry1 will apply
if box2 = false then no
if box 3 = true qry run
and have a button to run these qry and make temp table

give us some more info on how you have this set up - if the information you wish the tick boxes to get is in 1 table - very easy - if in different tables harder

 

[subhadrasn]

actually i hav a database which contains the details about employees in 17 fields.this database must be accessed by everyone.new users must b able to add their data or update the data by themself.Also they must be able to retrieve the data.
To retrieve,they can select any of the 17 fields i.e. the selection criteria is done at runtime and based on the selected field, datas must be retrieved in 2 different styles.
One is they can retrieve all 17 fields.Second is they can select only some fields.for ex: if they want to see the details of employees who have B.E.as their educational qualification, they could b able to c all the details (17 fields) of the B.E. or if they want to c only the first name and mobile number of the B.E. they could be able to select these fields as runtime selections.