Help!!!

[fenerfan]

Hey Guys, I need to make a access database to store some excel files for ease of use, problem is this is the first time I am using access in my life! I Have Created the tables, though I am yet to fill them with data, And I can run simple querys, The Problem I have Is the form Side of things. It has to be practical, as In I want to be able to open it up and be met with a form to select either to view and add records to tables, or to search (i.e via surname), this is where I have the most difficulty, as I am clueless how to do this( search form), If anyone coud point me in the right direction that would be great (i.e web tutorials etc.) I have also uploaded my db so far, it just has empty tables, incase you wanted to have a look at it.................... my main problem is searching via a form

h**p://www.sendspace.com/file/ahcfv5

 

[Dreamweaver]

This should do the trick

http://www.access-programmers.co.uk/forums/showthread.php?t=99353

 

[fenerfan]

First Of All, Thanks For that link, It Helped me out big time......

Though How do I get the filtered Results into A REPORT


ANYONE???

 

[GaryPanic]

use the report wizard , I presume you have the tables set up?? good
right now when you set the tables up their is a tab (s) one called tables one query 1 reports and some others click the reports one their is a wizard in this thats pretty functional now open select this and play around , yu also need to be up to speed on queries which you state you are select the qry and the report wiz will do the rest - may not exactly what your after but follow the wizard through and look at the coding behind all the options this will give an idea on reports, also would recommend getting a good book - helps a lot as do the guys here

 

[fenerfan]

Thanks mate, though what I meant was How do I create a report after the subform has been filtered, reffering to the example in the link,