How to hide a record

[Pinkoto]

Hello,
My question is, can i hide a record when i look it in a form. For example i have a table which has 100 records. Can i make some kind of a check box and if that check box is checked to make the record disappear. I want the record to be in the table but i dont need it in the Form.

 

[JHB]

Yes you can, add a "Yes/No" field type to the table.
Base the form on a query where you've a criteria for the "Yes/No".

 

[Pinkoto]

can i do it without the criteria?

 

[Pinkoto]

is that from the filter ? or something else?

 

[JHB]

can i do it without the criteria?

Why do you want that?

 

[JHB]

is that from the filter ? or something else?

It can be the filter but also something else!

 

[Pinkoto]

i dont want to use the criteria. i just want when i open the form every record that has a check in that check box not to show. Is it possible?

 

[smig]

i dont want to use the criteria. i just want when i open the form every record that has a check in that check box not to show. Is it possible?

Either in the Form's Filter or the Form's RecordSource criteria.
Or do you want the form to guess what you want ?

 

[Pinkoto]

i want the records i have marked in the table, not to be shown in the form! I dont want to use special filter everytime i open it. I just want to when i open my form the record which are marked not to be in the form.... how can i do that ?

 

[mohitmm]

I want to track employees login and log out times and also if they are working on any item I want to track how much time they are taking that to complete and Non productive events like :-

How much time they are spending on the breaks?

How much time they are spending on Training , Meeting and any other work should also be tracked down,So that I can calculate the Accurate productive hours for the day and for each employee .

It should be in MS ACCESS 2007

Please help me with this !!

Thanks and Regards,

Mohit

 

[Frothingslosh]

i want the records i have marked in the table, not to be shown in the form! I dont want to use special filter everytime i open it. I just want to when i open my form the record which are marked not to be in the form.... how can i do that ?

As smig said, you include that provision in the form's RecordSource criteria. Something like "SELECT * FROM MyTableName WHERE MyTableName.HideFromForm = FALSE;" That is not the same as applying a special filter.

 

[Frothingslosh]

I want to track employees login and log out times and also if they are working on any item I want to track how much time they are taking that to complete and Non productive events like :-

How much time they are spending on the breaks?

How much time they are spending on Training , Meeting and any other work should also be tracked down,So that I can calculate the Accurate productive hours for the day and for each employee .

It should be in MS ACCESS 2007

Please help me with this !!

Thanks and Regards,

Mohit

You really need to create a new thread and ask your question, as this isn't at all related to the thread topic.

 

[Pinkoto]

i want the records i have marked in the table, not to be shown in the form! I dont want to use special filter everytime i open it. I just want to when i open my form the record which are marked not to be in the form.... how can i do that ? Can someone help me with it ?

 

[Frothingslosh]

We have told you several times how to do that without using a special filter. Filters and queries are NOT the same thing.

 

[CJ_London]

you've been given the answer

1. put a yes/no field in your table

Yes you can, add a "Yes/No" field type to the table.

2. write the following query as the recordsource to your form

 SELECT * FROM MyTableName WHERE MyTableName.HideFromForm = FALSE

 

[smig]

i want the records i have marked in the table, not to be shown in the form! I dont want to use special filter everytime i open it. I just want to when i open my form the record which are marked not to be in the form.... how can i do that ? Can someone help me with it ?

If you dont want to use a filter nor using a criteria in the form's RecordSource you can ask the form nicely to hide this record for you.

 

[CJ_London]

you can ask the form nicely to hide this record for you

I was thinking tippex