Software

Ask something
Discussion Locked

How do I ???? part Threese

0 helpful
5 replies

by joeplaisted

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hello,
Hopefully, this will be the last time I have to ask something on this subject. Does MSAccess have the ability in unbound forms to bring up a previously entered project name when you type in just a few letters of a name. In other words Word has the ability to do this and I am wondering if Access can do the same thing. It would limit the amunt of mistakes in the database as the project managers cannot seem to remember how they have entered the names of the projects they are tracking each time. So for a single project I may have ive or six different names.

5 replies

by cptomlly

There may be other ways, but this is how I'd do it. You would have to set up one table with the project name being the primary field, i.e. tblProjectName. Then you link this project name field to another project name field in another table without a primary key field, i.e. tblProjectDetails. Using my example, ProjectName field in tblProjectName will have a one-many relation to ProjectName field in tblProjectDetails.

So then, you'll need the main form to write to tblProjectDetails. You will need to make a combo box that pulls the ProjectName field in tblProjectName as its source, but the form writes to tblProjectDetails. Do that by setting the RowSourceType to Table/Query and the RowSource to tblProjectName, bound to column 1.

I would recommend using a separate form to enter the project names to which only you and the supervisor can access. This ensures this limits the subordinates to only a specified list of projects.

From here its pretty simple to set up your reports to have a project name as the Heading, then a neat little list of all update entries made by the subordinates.

Hope this helps.

by it_cowboy

In addition to the above answer I think a little more detail is required...
In your tblProjectName table you will have an ID field that will link to the details table and you will have a ProjectName field that describes the project.
Have the ID field as the first field and the project name as the second field in the combo box.
Combo Box properties:
- RowType = "Table/Query"
- RowSource = "SELECT ID, ProjectName FROM tblProjectName ORDER BY ProjectName;"
- BoundColumn = 1 (the ID field)
- ColumnWidths = 0;5 (hide the ID field, display the project name)
- AutoExpand = Yes (this will autocomplete the project name when typed in.)

This discussion is closed to new replies.