Prev: DAO Recordset Issue
Next: Still confused on relationship queries and similating a vlooku
From: Rangermry on 4 Mar 2010 15:35
I made a report from a table that is a list of files with their hyperlink, a
description column, etc. I want to make a report that has a search button at
the top, and can be searched by All columns or the few columns I have. I
have tried to search for answers and am new to Access. Can someone give me a
good resource, give me some code help, or tell me if this is possible?
From: Jerry Whittle on 4 Mar 2010 15:53
You can't put command buttons on a report. Therefore you need to "search" for
the data in the query that you use for the record source for the report.

You can search on a form. In fact there's a find function on the menu or
ribbon similar to that in Word or Excel. However if you have a lot of
records, say over 10000, this can be very slow.

One thing that worries me is that you want to search All columns. In a
database you should have all the same data in one column. For example all the
last names should be in something like a LastName field. If you have
fields/columns with similar data, except each column is something like a
Month, your tables aren't set up properly and you'll have a lot of problems
in the future.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"Rangermry" wrote:

> I made a report from a table that is a list of files with their hyperlink, a
> description column, etc. I want to make a report that has a search button at
> the top, and can be searched by All columns or the few columns I have. I
> have tried to search for answers and am new to Access. Can someone give me a
> good resource, give me some code help, or tell me if this is possible?
From: Jerry Whittle on 5 Mar 2010 10:37
You can filter on fields in a report at least in Access 2007. However this is
filtering by one column at a time. To do multiple columns you would need a
lot of OR clauses.

Also in Access 2007 you can use the Find button on the Home ribbon to search
for text in any field of a report!

This is all new to Access 2007. I just checked and it doesn't work in Access
2003.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"Rangermry" wrote:

> I made a report from a table that is a list of files with their hyperlink, a
> description column, etc. I want to make a report that has a search button at
> the top, and can be searched by All columns or the few columns I have. I
> have tried to search for answers and am new to Access. Can someone give me a
> good resource, give me some code help, or tell me if this is possible?
 | 
Pages: 1
Prev: DAO Recordset Issue
Next: Still confused on relationship queries and similating a vlooku