Search results

re what i mean is click on view speechs (the button on the start up screen) see how it shows the records (how it is set out) see how the is a open record button (which opens the record) i want the search results to be displayed like that if you can?

re dude that is fantastic but... if you sayclick on view speeches from the startup form and then it opens up and shows a brief decription of the record and you have the option to open record. i dont suppose you could the results to be displayed exactly like that once again if you think im...

re dude your a star (Attachment removed by admin at member's request.)

Re Dude im hungover and not getting what you are saying I have cleared out all the info and just put test data in Here is the actual database Can you put a search box at the bottom of the form thats opens on startup so that you can search for a word in all fields of all of the tables and...

re actually having looked again some of the tables do have the same field im not sure what you mean by a union select query. Im at work and just been given this to do. Its actually a search function i want to be put on a form to display results from the five tables in a form and then you can...

Re No they do not all share the same fields. But they have been put together using a query. About five or so fields need to be searched at the same time

Hi I have a database with a five tables in it. I have created a form which displays information from each of these tables at the same time I want to put a search box on the form that will allow the user to search all of the fields in the tables for a keyword. It will then output the results...

Hi People Im at work creating a form from a table which has been populated. Havent filled about with access for years. I found like the command button in the tool box to create a search button I need the vbscript to be able to get it too work though. Can any of you lot help For example i...