Selecting records to open in a subform

  • Thread starter Thread starter Mr-Re Man
  • Start date Start date
M

Mr-Re Man

I have a table with 6 fields,
[ID] autonumber
[Application No] text
[Type] text (types stored in a seperate table and selected via the forms
combo)
[Scanned] checkbox
[Indexed] checkbox
[Comments] memo

What I would like to do is open a form with a list of all the applications
in [Application No] order, then be able to select a number of records (by a
checkbox).

Once the appropriate number of records have been selected, a [Display
Results] button is pressed and will either open a new continuous form or a
continuous subform so that the [Scanned] & [Indexed] checkboxes can be
updated by the user in one hit instead of updating records one at a time.

It would be good to hear if this is possible then provide me some of your
expertise to help make this work.

thanks in advance.
 
My immediate thought is that you can select the records you need using a
checkbox.

Create a query filtering for those records that have been checked and use it
as the source for the new form.

Does that make sense?
 
Would I have to include the checkbox as a field in the table or add it in
somehow on a form.

If I check , lets say 20 records and update them, how would you remove that
checkbox from the record so it doesn't appear in the next search.

I can see this method working.

scubadiver said:
My immediate thought is that you can select the records you need using a
checkbox.

Create a query filtering for those records that have been checked and use it
as the source for the new form.

Does that make sense?

Mr-Re Man said:
I have a table with 6 fields,
[ID] autonumber
[Application No] text
[Type] text (types stored in a seperate table and selected via the forms
combo)
[Scanned] checkbox
[Indexed] checkbox
[Comments] memo

What I would like to do is open a form with a list of all the applications
in [Application No] order, then be able to select a number of records (by a
checkbox).

Once the appropriate number of records have been selected, a [Display
Results] button is pressed and will either open a new continuous form or a
continuous subform so that the [Scanned] & [Indexed] checkboxes can be
updated by the user in one hit instead of updating records one at a time.

It would be good to hear if this is possible then provide me some of your
expertise to help make this work.

thanks in advance.
Click to expand...
Click to expand...
 
You would have to include it in the table.

You can remove the checkbox by creating an update query (uncheck all
checkboxes that are checked)

Mr-Re Man said:
Would I have to include the checkbox as a field in the table or add it in
somehow on a form.

If I check , lets say 20 records and update them, how would you remove that
checkbox from the record so it doesn't appear in the next search.

I can see this method working.

scubadiver said:
My immediate thought is that you can select the records you need using a
checkbox.

Create a query filtering for those records that have been checked and use it
as the source for the new form.

Does that make sense?

Mr-Re Man said:
I have a table with 6 fields,
[ID] autonumber
[Application No] text
[Type] text (types stored in a seperate table and selected via the forms
combo)
[Scanned] checkbox
[Indexed] checkbox
[Comments] memo

What I would like to do is open a form with a list of all the applications
in [Application No] order, then be able to select a number of records (by a
checkbox).

Once the appropriate number of records have been selected, a [Display
Results] button is pressed and will either open a new continuous form or a
continuous subform so that the [Scanned] & [Indexed] checkboxes can be
updated by the user in one hit instead of updating records one at a time.

It would be good to hear if this is possible then provide me some of your
expertise to help make this work.

thanks in advance.
Click to expand...
Click to expand...
Click to expand...
 
Could you provide me the code for update query.

I have created a button to close the form, could I include the code here?

scubadiver said:
You would have to include it in the table.

You can remove the checkbox by creating an update query (uncheck all
checkboxes that are checked)

Mr-Re Man said:
Would I have to include the checkbox as a field in the table or add it in
somehow on a form.

If I check , lets say 20 records and update them, how would you remove that
checkbox from the record so it doesn't appear in the next search.

I can see this method working.

scubadiver said:
My immediate thought is that you can select the records you need using a
checkbox.

Create a query filtering for those records that have been checked and use it
as the source for the new form.

Does that make sense?

:

I have a table with 6 fields,
[ID] autonumber
[Application No] text
[Type] text (types stored in a seperate table and selected via the forms
combo)
[Scanned] checkbox
[Indexed] checkbox
[Comments] memo

What I would like to do is open a form with a list of all the applications
in [Application No] order, then be able to select a number of records (by a
checkbox).

Once the appropriate number of records have been selected, a [Display
Results] button is pressed and will either open a new continuous form or a
continuous subform so that the [Scanned] & [Indexed] checkboxes can be
updated by the user in one hit instead of updating records one at a time.

It would be good to hear if this is possible then provide me some of your
expertise to help make this work.

thanks in advance.
Click to expand...
Click to expand...
Click to expand...
 
You can either use a button or you can run the query when you close the form.

In the design view

select the update query from the 'query type' list
choose the checkbox field
In the 'update to:' field insert a zero
In the criteria row insert a -1

UPDATE Table1
SET Table1.[check] = 0
WHERE (((Table1.check)=-1));


To run the query choose

DoCmd.OpenQuery


This is a very useful thing to do if you want to look at certain records
with certain conditions because a standard select query is updateable.

Mr-Re Man said:
Could you provide me the code for update query.

I have created a button to close the form, could I include the code here?

scubadiver said:
You would have to include it in the table.

You can remove the checkbox by creating an update query (uncheck all
checkboxes that are checked)

Mr-Re Man said:
Would I have to include the checkbox as a field in the table or add it in
somehow on a form.

If I check , lets say 20 records and update them, how would you remove that
checkbox from the record so it doesn't appear in the next search.

I can see this method working.

:


My immediate thought is that you can select the records you need using a
checkbox.

Create a query filtering for those records that have been checked and use it
as the source for the new form.

Does that make sense?

:

I have a table with 6 fields,
[ID] autonumber
[Application No] text
[Type] text (types stored in a seperate table and selected via the forms
combo)
[Scanned] checkbox
[Indexed] checkbox
[Comments] memo

What I would like to do is open a form with a list of all the applications
in [Application No] order, then be able to select a number of records (by a
checkbox).

Once the appropriate number of records have been selected, a [Display
Results] button is pressed and will either open a new continuous form or a
continuous subform so that the [Scanned] & [Indexed] checkboxes can be
updated by the user in one hit instead of updating records one at a time.

It would be good to hear if this is possible then provide me some of your
expertise to help make this work.

thanks in advance.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top