Access Excel VBA Blog » Excel spreadsheet and Access database development and VBA programming for Excel Power Users & Programmers. I often use a combobox to filter.For an example, when browsing between the tasks assigned to the staff, it can be selected, which co-workers jobs should be displayed.It occurs sometimes, that in an Access form we have to include to a combobox / dropdown list an “Any/All” item, which can be used, when we don’t want to filter according to the co-workers.I have a stylish/interesting solution for this problem.I create a query, which shows only the active records in alphabetical order.It looks like this: The joker record is not yet included.I open the query for editing (View/SQL view).
SELECT tblUser.userID, tblUser.usernameFROM tblUserWHERE (((tblUser.active)=True))ORDER BY tblUser.username; I change the query source to: Programmez Office en VBA. Les premières leçons du cours VBA pour Excel ici Vous êtes un utilisateur averti de Word et d'Excel ?
Vous avez souvent entendu parler de VBA, ce fameux langage de programmation qui permet de décupler la puissance de vos logiciels favoris ? Vous êtes tombé juste ! VBAXL. Exemples de programmation Excel VBA.