If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Search My Report Help
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? |
#2
|
|||
|
|||
Search My Report Help
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? |
#3
|
|||
|
|||
Search My Report Help
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? |
Thread Tools | |
Display Modes | |
|
|