Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / New Users / January 2008

Tip: Looking for answers? Try searching our database.

Multi-select list box

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
E.Q. - 03 Jan 2008 22:41 GMT
I've developed a training tracking application and showed it to my fellow
supervisors and bosses from various departments. They've requested somethying
beyond my MS-Access skills.  They would like to select multiple "milestones"
as they relate to specific "objectives" when tracking training.

Some background; two tables in the application hold the objectives data

tblTrainingObjectives
lngObjID (PK)
chrPlantArea
chrObjectiveName
intObjType
chrDescription

tblObjSpec
lngSpecID (PK)
lngObjID (FK)
chrSpecName
chrTestQuestion

I currently have two tables to track training:
tblTracking
lngTrackID (PK)
chrEmpID
dtmWorkDate
etc.

tblTrainedOn
lngTaskID (PK)
lngTrackID (FK)
lngObjID(FK)
blnTrained
sngTaskHours

I am set up to track time spen on each Objective in tblTrainedOn. I used the
wizard to generate a form using tblTrackin as the main form and tblTrainedOn
as the subform.  My fellow supervisors would like to track each "milestone"
(which as I have here is uniquely identified by tblObjSpec.lngSpecID) by
having a "drop down" list and select all that were covered during a given
training day.
I believe a multi-select listbox might work, but I've never configured one;
my question is, what kind of output does this provide and how can I get the
data I want into the records and future reports?
To give an idea of the scale, I've received 185 "milestones" to include,
each relating to one of 44 objectives... So far, no objective has more than
about nine milestones associated with it.
We'd like to generate reports to track training... to see which milestones
have been covered. For example, we'd like to be able to see when  an employee
received instructions pertaining to tub management (milestone) for the fine
screen building (objective).
Any suggestions for a multi-select technique (whether listbox, pop-up form,
or whatever) will be appreciated.
Peace.
EQC
Larry Daugherty - 04 Jan 2008 03:05 GMT
Access Help regarding MSLB is pretty good.

In broad strokes the main thing about multi-select list boxes is that
you must interrogate every item in the list to determine if
".Selected" is True and to take appropriate action.

HTH
Signature

-Larry-
--

> I've developed a training tracking application and showed it to my fellow
> supervisors and bosses from various departments. They've requested somethying
[quoted text clipped - 50 lines]
> Peace.
> EQC
Tony Toews [MVP] - 04 Jan 2008 04:14 GMT
>In broad strokes the main thing about multi-select list boxes is that
>you must interrogate every item in the list to determine if
>".Selected" is True and to take appropriate action.

And you must do so using VBA code.

Tony
Signature

Tony Toews, Microsoft Access MVP
  Please respond only in the newsgroups so that others can
read the entire thread of messages.
  Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
  Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.