code_junkie

Dictionaries and Hash Tables in MS-Access 2007

Nov 13th, 2011
115
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.42 KB | None | 0 0
  1. Dim Dict1 As Dictionary
  2.  
  3. ' Create a dictionary instance.
  4. Set Dict1 = New Dictionary
  5.  
  6. With Dict1
  7. 'set compare mode
  8. .CompareMode = BinaryCompare
  9. ' Add items to the dictionary.
  10. .Add 1, "Item 1"
  11. .Add 2, "Item 2"
  12. .Add 3, "Item 3"
  13. End With
  14.  
  15. .application
  16. .creator
  17. .delete
  18. etc...
  19.  
  20. Set Dict1 = CreateObject(Scripting.Dictionary)
  21.  
  22. Dim SortValues As Scripting.Dictionary
  23. Set SortValues = New Scripting.Dictionary
Add Comment
Please, Sign In to add comment