Create a Constants table in VB code

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance


I need to create a constants table that exists entirely in VB code.

The table consists of 3 columns and 5 rows
I want the table to look like this:

ID Start Finish
1 3/1/07 3/5/07
2 3/6/07 4/10/07
....etc.


I then want to have code to pull out values in the table e.g.
GetStart(1) would use the Dlookup function to return the value in the
"Start" from the row with id "1". I'm pretty confident I can program
this portion of it.

What I don't know how to do is declare this table to exist in VB. Do
I want a table? Do I want an array instead? What is the best way to
go about this?

Thanks

.

Relevant Pages

  • Re: How to list the statement of all var ?
    ... I must to declare and use all variable with this strict scheme ... Array consists of arrayObject.length elements and you handle ... The posted structure is *not* an array. ...
    (comp.lang.javascript)
  • Re: How to do an array?
    ... I have a html file that consists of several hundred ... To store the data on the server, ... correct to say an array is created and for this example the array ... I had wanted to write a shell script ...
    (alt.html)
  • Re: Refer to field headings?
    ... first line consists of field names and the rest of the lines have the ... An alternative would be to create explicit variables based on those names (or at ... Which approach to choose (array or variables) depends on how many times you need ... to reference those fields (the variables require more typing at initialisation, ...
    (comp.lang.awk)
  • Serializing array of objects of different types
    ... So that Contents object is array that consists of Resource or Category ...
    (microsoft.public.dotnet.xml)
  • Re: How would you design this?
    ... C is TableCell which can have an entire table within it after parsting HTML. ... >> Object of class A consists of array of objects B which consist of array ...
    (comp.lang.java.help)