Using form with the datasheet view

  • Thread starter Thread starter CAM
  • Start date Start date
C

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.
 
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.
 
Thanks bcap, I appreicate the tip.

Cheers

bcap said:
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.
Click to expand...
 
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
 
Back
Top