Having problems could use some ideas

[Jim W]

I have a form which is used to manage equipment. On this form there is a Yes/No field. This field is used to delete the piece of equipment. So if the Yes/No is checked once the form updates the piece of equipment will not show up on the form anymore. Now on the form I am trying to add a command button that will open another form using a query with the criteria for the deleted field set to Yes so this form will only show deleted equipment. I then want to beable to remove the check on the deleted field and restore the piece of test equipment. However, when the other form opens I can not make any changes to the record. I get an error thaty the table is in use. I have tried closing the 1ft form before opening the 2nd form but still have the same problem. Can anyone help me resolve this issue?

Jim

 

[Parker]

I have a form which is used to manage equipment. On this form there is a Yes/No field. This field is used to delete the piece of equipment. So if the Yes/No is checked once the form updates the piece of equipment will not show up on the form anymore. Now on the form I am trying to add a command button that will open another form using a query with the criteria for the deleted field set to Yes so this form will only show deleted equipment. I then want to beable to remove the check on the deleted field and restore the piece of test equipment. However, when the other form opens I can not make any changes to the record. I get an error thaty the table is in use. I have tried closing the 1ft form before opening the 2nd form but still have the same problem. Can anyone help me resolve this issue?

Jim

How about, instead of deleting the item you remove it, temporarily, from its original table using a query. Have that query append a temp table.
If you then change the state of the control again have another query put it back.

 

[Oldsoftboss]

Why not base your forms on 2 queries. One with the criteria for the chkbox set to yes, the other no. That way the data is in one table, never deleted, more "selected" or "not selected"

Dave

 

[Oldsoftboss]

A 3 minute whip up

 

[Rich]

You can of course just use one query with no critera and filter your form

 

[Jim W]

No matter what I do with this I get an error msg saying that the Table is exculsively opened and can't be modified. I have tried recreating the table. But I still get the same error when I try deleteing a record.

Jim

 

[fatboy95]

I don't know if this will help you but I have a database I made that does a what you are asking for. Open up the Class Roster form. You will see a check box the says AFI. If you click that and then close the form it moves the record to another table. Hope this helps ya?

I had to strip it down a lot to be able to upload it. Go to the forms and open up Class Form then you will have to go to Student AFI Form to see it totally work. Enjoy!

 

[Jim W]

That is it, Thankyou this help me out alot

thanks for your time

Jim