Go Back   Access World Forums > Microsoft Access Discussion > Theory and practice of database design

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 05-07-2015, 02:00 AM   #1
bamerand
Newly Registered User
 
Join Date: May 2015
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
bamerand is on a distinguished road
Subject: Combo-box with values per department

Dear all,

I need assistance in providing guidance and assistance in the following database (I am a newbie with VBA and queries). I have attached the <Personnel.zip> and here is a description of the purpose of the DB and what I cannot accomplish and called for your expertise.

The DB is made of 2 tables, those are <Personnel> and <Trainings>, 2 forms, those are <Personnel List> and <Personnel Details>. The <Personnel Details> form consists of two tabs, one is called <General Information>, which contains overall information about employees. The second tab, with which I am having difficulties, is called <Training information>.

I need to have the <Training information> tab, which is sub-formed with <Trainings> table, to be in continuous combo-box, i.e. for each created employee (the sample contains 4 employees) I need to have the field <Training title> in the combo-box field by department field. Like, if value <HR> is selected in the <Department> field, then the combo-box should list the values that are <Internal Auditor Course> and <Lead Auditor Course>, or if selected value <Maintenance> in <Department> field, then the combo-box should list values that include <Basics in instrumentation>, or if selected value <Construction> in <Department> field, then combo-box should list values that include <Intensive English>. What I was able to accomplish is the <Trainings> table is sub-formed to <Training information> tab and I can physically type the values for each of the trainings attended by all employees (over 2,000 in total).

The second issue I have is I need to make inactive cells <Issued date> and <Valid date> if the <Permanent> field is checked-in. Alternately, if the <Permanent> field is checked-out, then the cells <Issued date> and <Valid date> should become active.

I look forward to receiving any support, recommendations, if you have code / DB that has similarities, please post along.
Attached Files
File Type: zip Personnel.zip (95.5 KB, 51 views)

bamerand is offline   Reply With Quote
Old 05-07-2015, 02:43 AM   #2
BlueIshDan
 
Join Date: May 2014
Posts: 1,122
Thanks: 155
Thanked 160 Times in 156 Posts
BlueIshDan is on a distinguished road
Re: Subject: Combo-box with values per department

Honestly, I feel like you're dropping a spec on this forum.

Show us, in detail, where you currently stand with coding and design issues.

Also, give this book a read: Don't Make Me Think

Reading this "spec" was like getting slapped awake at 3AM and told to solve the rubix cube.

Cheers
__________________

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

Blue's Age Poll:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

Animated Sorting:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

Mining File Directories:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
GetSubFolders:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

GetFileLines:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

FindSimilarValues:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

Move (Avoid moving objects game):
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
BlueIshDan is offline   Reply With Quote
Old 05-19-2015, 01:34 PM   #3
GinaWhipp
AWF VIP
 
GinaWhipp's Avatar
 
Join Date: Jun 2011
Location: Ohio, USA
Posts: 5,380
Thanks: 21
Thanked 896 Times in 881 Posts
GinaWhipp has a spectacular aura about GinaWhipp has a spectacular aura about
Re: Subject: Combo-box with values per department

Welcome to the Forum!

For dependent Combo Boxes I suggest you read up on cascading Combo Boxes. You can start here...
http://www.blueclaw-db.com/comboboxl...pdown_list.htm

Your second problem is you are missing a table...

Code:
 
tblPersonnelTraining
ptPersonnelID
ptTrainingID
This is a Many-to-Many table.

As for making fields active/inactive... does not work so well on a continuous Form.

Side note, in Excel they are called Cells in Access on Forms they called Controls and in Tables fields. Tables, even Datasheet View, does not format like Excel.

__________________
Gina Whipp
Microsoft MVP (Access 2010-2015)


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
GinaWhipp is offline   Reply With Quote
Old 06-10-2015, 05:53 PM   #4
Thales750
Formerly Jsanders
 
Join Date: Dec 2007
Location: Galveston, Texas
Posts: 1,671
Thanks: 54
Thanked 28 Times in 28 Posts
Thales750 is on a distinguished road
Re: Subject: Combo-box with values per department

Hey Gina, don't those Blue Claw folks have some information on CDO as well? LOL
__________________
Aboard Oceans Eleven on Offatts Bayou
inveniemus viam aut faciemus
Thales750 is offline   Reply With Quote
Old 06-10-2015, 06:21 PM   #5
GinaWhipp
AWF VIP
 
GinaWhipp's Avatar
 
Join Date: Jun 2011
Location: Ohio, USA
Posts: 5,380
Thanks: 21
Thanked 896 Times in 881 Posts
GinaWhipp has a spectacular aura about GinaWhipp has a spectacular aura about
Re: Subject: Combo-box with values per department

Look at the date.... it's old news.

__________________
Gina Whipp
Microsoft MVP (Access 2010-2015)


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
GinaWhipp is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Add field values in subject and body of a mail Soughi Modules & VBA 8 02-04-2014 05:31 AM
SUBJECT: Form Combo Box Causes Query Error Message dlhappy Forms 7 03-17-2010 02:31 PM
Department / supervisor hooks Tables 9 08-07-2006 08:02 PM
Search by subject but save it as subject ID Gruung Forms 1 11-30-2003 12:43 AM
Sum by department Chimp8471 General 1 04-29-2003 11:46 PM




All times are GMT -8. The time now is 09:50 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World