Solved

Dictionary Object Please Help.

Posted on 2000-03-22
1
130 Views
Last Modified: 2010-05-02
Hi everyone. I am trying to use Dictionary Object having a Tons of problems. I am trying to add strings to it. If string holds a value i save it, i aslo save it to it if strings is empty. THen i need to loop though these empty once and show them on screen. Someone knows how this can be done ? Please show me how. Thanks.
0
Comment
Question by:vbRetard
1 Comment
 
LVL 2

Accepted Solution

by:
corvanderlinden earned 30 total points
ID: 2648367
Dim x As Dictionary
Dim a
Dim i As Integer

Set x = New Dictionary

x.Add "0", ""
x.Add "1", ""

a = x.Keys

For i = 0 To x.Count - 1
  If x(a(i)) = "" Then Debug.Print "Empty"
Next
0

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

When designing a form there are several BorderStyles to choose from, all of which can be classified as either 'Fixed' or 'Sizable' and I'd guess that 'Fixed Single' or one of the other fixed types is the most popular choice. I assume it's the most p…
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…

706 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now