Using form with the datasheet view

[CAM]

Hello,

I am using Access 2002 and 2007, some users will use 2002 and others 2007
version. I am making an employee history database and what I want is to
show on top of the form information per employee such as (last name, first
name, date hired, etc.), but below the text boxes I want to show a datasheet
view of only the particular employee selected fields (when employee has been
reviewed, bonuses if given, etc.). In the datasheet I may have 2 - 5 rows
of data. I don't want to display other employees data on the datasheet.
How do I do that? any website to visit or tips will be appreciated. Thank
you in advance.

 

[bcap]

1. Create an employee form to display in form view.

2. Create a history form to display in continuous or datasheet view.

3. Add the history form to the employee form as a subform, and link on the
appropriate field (which will be the primary key for an employee).

You should be able to accomplish most or all of this using the wizards.

 

[CAM]

Thanks bcap, I appreicate the tip.

Cheers

1. Create an employee form to display in form view.

2. Create a history form to display in continuous or datasheet view.

3. Add the history form to the employee form as a subform, and link on the
appropriate field (which will be the primary key for an employee).

You should be able to accomplish most or all of this using the wizards.

 

[Clif McIrvin]

And, if you're new to Access and want a place to start reading, here are
several good links:

--
(Thanks to John W. Vinson [MVP] for this info

Access has a steeper learning curve than (say) Word or
Excel; not least, in order to make productive use of the program you
have to
understand the theoretical basis of database design - a concept called
"Normalization". It is very logical and not at all difficult once you
get the
concepts down.

Here are some tutorials and other resources that I hope you will find
helpful:

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

A free tutorial written by Crystal (MS Access MVP):
http://allenbrowne.com/casu-22.html

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials

--
Clif
Still learning Access 2003