Please help me impress my boss ;)

[Skhatun786]

Hi all



Im new to this forum and know the basics of Access.

Ive been asked to design and create a basic database on access. work at a college and the database will be used to store data unique to our dept..nothing too complicated. The templates i have come across are too complicated for what we need...hoping for a pay rise....lol...The database must allow users to;

-Input student data
- search for customers using national insurance numbers and then display in a form view
- filter data by course start date and print off in report view
I have already done one table which will store the data and also a form to input all the data into which is working all fine.


I am stuck on the last two points :

- search for customers using national insurance numbers and then display in a form view
- filter data by course start date and print off in report view

Any help would be much appreciated. im really stuck and my deadline is this coming friday...

pretty plz and thanks in advance

[June7]

Review:
http://www.datapigtechnologies.com/f...earchform.html
http://www.datapigtechnologies.com/f...mtoreport.html
http://www.allenbrowne.com/ser-62code.html

[Skhatun786]

thanks...

is there no way the results of search can be shown in a form view as opposed to being in a table view

[June7]

Certainly. Use any view of the form you want. However, Datasheet view doesn't allow buttons to show. Continuous can be made to look like Datasheet.

[Skhatun786]

Sorry to sound thick lol... Would it be possible to elaborate on that

[June7]

What specifically do you not understand? Have you reviewed the links? Have you tried anything they describe?

[Skhatun786]

ive filtered data by course start date and print off in report view as shown in the second video...tried the steps on searching student by national insurance screen using the instructions above but only allows me to print off in table format...

[June7]

Why only table format? What are you printing?

[Skhatun786]

It's printing off as if am print directly from table and printing all the records... Another problem which I've encountered now is all my forms are all maximised and fill the screen when I put it in form view... I've tried to code it docmd.restore on the open form code

[June7]

Forms can be printed and can look like a report or a table depending on the set up but better to print reports.

I always set my db for Overlapping Windows instead of Tabbed Documents.