Records in a table

A

Amateur

I have a datsheet form based on a table.
How can I make a specific record from the table invisible in the form?
Thanks
Klaus
 
A

Amateur

How, it's a form - i thought to filter one record out of the Form
properties>>Data>>Filter, but don't know how to do that.
For example I do not want to see "autonumber 13" - Can you tell me how to
write the criteria?
Thanks
Klaus
 
K

KARL DEWEY

What is the Record Source for your form? Is a query or directly from the
table?
If it is a query then post the SQL by opening the query in design view,
click on menu VIEW - SQL View, highlight all, copy, and paste in a post.
If it is from the table then open in design view, click on menu VIEW -
Properties, copy the Record Source and paste in a post.
In either case Tell what is the field name of your autonumber.
 
A

Amateur

Dear Karl

I am again lost. OK, I opened the property from the table where the data for
the form is coming from. There is only the general tab - but I have not the
slightest idea what and where to input that what you are explaining.
AND - I would like to hide a row in the form not in the table, because I
need the data from that row for other queries.
Would you please be a skind as to tell me:
* What, how and where I have to input my "criteria" so that record nº 13 is
not shown in the form.
* Is that record still valid for other queries?
Thanks
Klaus
 
A

Amateur

Dear Karl

I am again lost. OK, I opened the property from the table where the data for
the form is coming from. There is only the general tab - but I have not the
slightest idea what and where to input that what you are explaining.
AND - I would like to hide a row in the form not in the table, because I
need the data from that row for other queries.
Would you please be a skind as to tell me:
* What, how and where I have to input my "criteria" so that record nº 13 is
not shown in the form.
* Is that record still valid for other queries?
Thanks
Klaus
 
A

Amateur

Dear Karl

I am again lost. OK, I opened the property from the table where the data for
the form is coming from. There is only the general tab - but I have not the
slightest idea what and where to input that what you are explaining.
AND - I would like to hide a row in the form not in the table, because I
need the data from that row for other queries.
Would you please be a skind as to tell me:
* What, how and where I have to input my "criteria" so that record nº 13 is
not shown in the form.
* Is that record still valid for other queries?
Thanks
Klaus
 
K

KARL DEWEY

I opened the property from the table where the data for the form is coming
from.
Open the form in design view to determine what is the Record Source for your
form? Is a query or directly from the table?

If it is a query then post the SQL by opening the query in design view,
click on menu VIEW - SQL View, highlight all, copy, and paste in a post.

If it is from the table then copy the Record Source and paste in a post.

In either case Tell what is the field name of your autonumber.
 
A

Amateur

What do you mean with this? - If it is from the table then copy the Record
Source and paste in a post.
I opened the form in design view - the record source for the form is a table
called "Contactos" my autonumberfield is "contactid".
and than ????????????????? what do you mean "....paste in a post" - Where
shall I copy and past the record sorce ("Contactos") too? what is a post?
Where I have to mention that I want to hide "contactid Nº13".
 
K

KARL DEWEY

Use this instead of the table name in the form record source ---
SELECT * FROM Contactos WHERE contactid <> 13;

It would be easier to change and input other criteria if you were using a
query as record source.
 
A

Amateur

Thanks Karl - that's working - but, one more question for this subject.
If I would like to hide more than one record, how the record source has to
look like? (For example I would like to hide record 13,18,23)
I thank you again very much for your help.
Klaus
 
K

KARL DEWEY

You really need to learn how to build and use queries.

Use this ---
SELECT * FROM Contactos WHERE contactid <> 13 And contactid <> 18 And
contactid <> 23;
 
J

John W. Vinson

You really need to learn how to build and use queries.

Use this ---
SELECT * FROM Contactos WHERE contactid <> 13 And contactid <> 18 And
contactid <> 23;
Click to expand...

or more compactly,

SELECT * FROM Contactos WHERE Contactid NOT IN(13, 18, 23);

Karl's right - *learn queries*. They are the basis of any Access application.

John W. Vinson [MVP]
 
Top