![]() |
|
|||||||
|
|
|
|
|
|
I have recently learned to used MicrosoftAccess and although I have used the learning tools on the net provided by Microsoft I'm still a little lost with some things.
I'm trying to develop a training/qualifications database where I would like to search for people with a particular qualification specifying the ...
|
![]() |
|
|
Thread Tools |
|
#1
|
|||
|
|||
|
I have recently learned to used MicrosoftAccess and although I have used the learning tools on the net provided by Microsoft I'm still a little lost with some things.
I'm trying to develop a training/qualifications database where I would like to search for people with a particular qualification specifying the qualification and inversely searching for employee's details and individual qualifications specifying their name. Is it possible to be able to produce drop down menus on request, where the values in the drop down menu are transferred to the desired locations (ex queries and forms). Also is it possible to open queries/forms that require specification (for example like a wild card for the criteria in queries), where the specifications relate directly to a linked form without requiring repeated typing? Any assistance would be much appreciated |
|
#2
|
|||
|
|||
|
You can populate a drop-down list via code (VBA) or from a look-up table.
You can take the contents of any text box or drop-down and feed that into any query, again using VBA. And you can validate the data before it gets passed to the query to detect typical user errors too, again in VBA. EG reject non-numerical data as clearly wrong or reject something as not being a valid date. However it's a while since I last did that, and without a copy of your database to work from, I can't write code for you. |
![]() |
|
| Bookmarks |
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| (Microsoft MN-500 Router) Cannot access Base Station Management Tool | veleron11 | Networking, Modems & VoIP | 0 | 6th Jun 2009 14:02 |
| Problems Blocking Access to Certain Material on Ie8 Without Damaging All Access | simon1990 | Web Browsers & FTP Clients | 2 | 10th Apr 2009 01:14 |
| Microsoft Access on shared drive | bigyin | Office Suites & Applications | 2 | 11th Aug 2008 13:36 |
| Microsoft Access on Windows 98 | alanturner81 | Windows Operating Systems | 3 | 31st Mar 2008 12:13 |
| Aol ie troubles | mrdaveyk | Web Browsers & FTP Clients | 1 | 2nd Dec 2007 16:39 |
| Thread Tools | |
|
|