Search and Delete

[Tommy2326]

Im wanting to vreate a form where I will be able to search for data in a
table 'Equipment_Table'. The search should be carried out using either'IT
Asset No' or Serial No' both of these contain unique data. I then want all
the information on that piece of equipment displayed on screen, Product Type,
IT Asset No, Manufacturer, Model No and Serial No. I then want an option to
delete this information. I think the delete can be carried out using the
standard delete button in Access.

Thanks for the help

Tommy

 

[scubadiver]

You may be able to use a delete query as the source for the form (which I
have never done myself). Insert a criteria into the query. In the form use a
combo box and an after update event that refreshes the records. You can then
use a command button that runs the delete query.

Or you can use a normal select query as the source with a criteria and use
the same criteria in the delete query.

 

[Tommy2326]

Its more the search bit of it I'm stuck at. When I open the form just now I
can navigate through all the records that are in the table, I would like to
open a blank form, enter the information I am looking for, press a search
button, the required data will appear on screen, then I can press a delete
button to delete it.

 

[scubadiver]

That is sort of what I suggested.

Use a query as the source for the form.

In the header of the form create an unbound text box (or two) for search
information. Give them appropriate names (in the name box in the "other"
tab). Or you may want to use a combo and specify what you want to search for.

In the criteria of the query write the reference to the text box.

[forms]![form name]![search text box name]

I suggest you use a search button that refreshes the records when you have
entered what you are looking for.

Or if you are using a combo, you can use the "after update" event to refresh
the records.

One step at a time.

 

[Tommy2326]

Ive done that, but how do i get the form to search for the It Asset number or
Serial Number, then display the results?

That is sort of what I suggested.

Use a query as the source for the form.

In the header of the form create an unbound text box (or two) for search
information. Give them appropriate names (in the name box in the "other"
tab). Or you may want to use a combo and specify what you want to search for.

In the criteria of the query write the reference to the text box.

[forms]![form name]![search text box name]

I suggest you use a search button that refreshes the records when you have
entered what you are looking for.

Or if you are using a combo, you can use the "after update" event to refresh
the records.

One step at a time.

Its more the search bit of it I'm stuck at. When I open the form just now I
can navigate through all the records that are in the table, I would like to
open a blank form, enter the information I am looking for, press a search
button, the required data will appear on screen, then I can press a delete
button to delete it.