background preloader

Access

Facebook Twitter

Industry Data Models. Crystal's Access Basics. The accuracy and thoroughness of this document would not have been possible without lots of help. In addition to those listed in the introductory comments, I wish to give a BIG thank you to my fellow Microsoft MVP, Tom Wickerath. Tom, your never-ending patience, great technical knowledge, and true friendship are blessings in my life ... words cannot express my gratitude ... I also wish to give a special thanks to Allen Browne for hosting this document on his fantastic website that has brightened many a dark corner. In the 15 or so years that I have been using and teaching Access, this document is the result of what I feel is most important to know.

Check back every now and then to see if a new version has been posted. For those of you who are new to this information, don't be discouraged if there are things that don't make sense. Nothing with the power of Access is easy, so just take one step at a time ... you will get there Each time you read this document, you will learn something new. Listes déroulantes liées. Comment combiner 2 listes déroulantes, de façon à ce qu'un choix dans la première filtre automatiquement la seconde ?

Dans l'exemple ci-dessous, une liste propose les différentes activités possibles pour un client (Plongée, Pêche, Cabotage...). La seconde liste n'affiche que les clients liés à cette activité. Il y a plusieurs manières de réaliser cette synchronisation de listes. Cet article décrit l'approche graphique, avec le moins de programmation possible. Construction de la 1ère liste déroulante Pour simplifier, on suppose que la 1ère liste est basée sur des valeurs tapées manuellement, et que le formulaire sur lequel vous travaillez s'appelle "frm Clients" Ouvrez votre formulaire en mode Création.

Construction d'une requête pour la 2ème liste déroulante La 2ème liste déroulante sera basée sur une requête, qui sera chargée de filtrer les clients. Construction de la 2ème liste déroulante Ouvrez votre formulaire en mode Création. Mise à jour de la 2ème liste déroulante par la 1ère liste Me! Microsoft Access help, tutorials, examples. Where to ask for help For a list of places where you can post questions, see Forums on our Links page. Brief tutorials and help for novices and database developers. Examples and solutions to implement. Bugs and traps to avoid. Sample code and utilities to download. All free. This is literally an FAQ. Re newer versions, see Converting to Access 2007 or 2010.Examples have not been tested in versions beyond Access 2010.Articles marked MS are quoted by Microsoft (on the Office website.)

Allen is no longer accepting database clients. Search this site If you don't know how to write code, these may help. Table Design Forms Reports Expressions Solutions for developers. Combo Boxes Queries Relational Design Coding examples for VBA (Visual Basic for Applications.) Solutions (VBA) Error Handling in VBA Access 95 and laterELookup() - an extended replacement for DLookup() Access 95 and laterECount() - an extended DCount().

Functions (VBA) Pitfalls and Traps Examples by Library Applications Utilities Corruption / Repair. CSD - Access Resources. Access Junkie's Resource List This is my list of Access Resources I have compiled over the last several years. I hope you find this list as useful as I have. Use this page as a starting point when you need to find anything related to Access. List last updated: March 5th, 2013 - New entry since last revision - Link updated since last revision - Access MVP site Table Of Contents Link Count as of Last Update: 431 Starting Out with Access: Number One on your start list for comprehensive Access help: Top Access Ten Commandments: Follow the wisdom and do not stray towards the Dark Side.

"...fear leads to anger, anger leads to hate, hate leads to Lookup Fields. " Microsoft Knowledge Base Articles: Main Page for searching: How to use the Knowledge Base: Netiquette: Top.