?
Solved

name and numbers

Posted on 2003-03-30
8
Medium Priority
?
163 Views
Last Modified: 2010-05-03
hi i just want to most efficient (cpu and size) way of storing and retrieving a list of names and numbers

thanks!
0
Comment
Question by:FeVeR
8 Comments
 

Expert Comment

by:kartik
ID: 8236850
Use VB collection.
0
 

Accepted Solution

by:
jazzzz20 earned 100 total points
ID: 8237403
Hi.

Use Dictionary object:



Dim d
Set d = CreateObject("Scripting.Dictionary")
d.Add "Name1", "Number1"
d.Add "Name2", "Number2"
d.Add "Name3", "Number3"

MsgBox "Number of Name2 is " & d("Name2")



Regards.

0
 

Author Comment

by:FeVeR
ID: 8242666
sorry, i need to be able to view them also, on a scroll bar type setup
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 

Expert Comment

by:jazzzz20
ID: 8244896
Hi FeVeR.

Actual question does not contain any such requirement. Therefore you should initiate a new question if you want its answer.

Regards.
0
 

Author Comment

by:FeVeR
ID: 8267994
are you serious?? sorry but no
0
 

Expert Comment

by:CleanupPing
ID: 8531288
Hi FeVeR,
This old question (QID 20568433) needs to be finalized -- accept an answer, split points, or get a refund.  Please see http://www.cityofangels.com/Experts/Closing.htm for information and options.
0
 

Expert Comment

by:jazzzz20
ID: 8579971
Hi Moderators.

Please do not refund the points. FeVeR tried to change the question after receiving a comment/answer. Please see his/her comment of [ 03/31/2003 06:13PM PST ] and match it to the actual question. He/she extended a "hint" to a whole application after receiving a comment/answer.

I don't need the points but they should not be refunded to FeVeR because such behavior discourages people like me from answering the question because after commenting on it, the question's scope is extended which is totally unfair. I request you to discourage this type of behavior by canceling the points of FeVeR.

Regards.
0
 

Author Comment

by:FeVeR
ID: 8584163
technically you're correct. not exactly collaboration though. thanks jazzzz20.
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction While answering a recent question about filtering a custom class collection, I realized that this could be accomplished with very little code by using the ScriptControl (SC) library.  This article will introduce you to the SC library a…
Have you ever wanted to restrict the users input in a textbox to numbers, and while doing that make sure that they can't 'cheat' by pasting in non-numeric text? Of course you can do that with code you write yourself but it's tedious and error-prone …
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
Suggested Courses
Course of the Month12 days, 17 hours left to enroll

579 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