I know VB but I haven't used it in like 4 years. My problem is I haven't learned how to retrieve data from MS Access database using VBScript. Can someone please help!! It would be greatly appreciated. Thank you.
Thank you Peter for your help. But unfortunately I cannot use the shortcut. I have to actually code it in notepad. Now if you know how to code it using VB that would be real helpful. I do apologize, I should have stated that on my first post. But once again thank you for your help.
I’m not too sure about that question. I guess you could use a Directory object to store the array then display it.
Possibly something like this?
'Returns an array containing all the items in a Dictionary object
Dim a, d, i, s ' Create some variables.
Set d = CreateObject("Scripting.Dictionary")
d.Add "1", "fee" ' Add some keys and items.
d.Add "2", "fie"
d.Add "3", "foe"
d.Add "4", "fum"
a = d.Items ' Get the items.
For i = 0 To d.Count -1 ' Iterate the array.
s = s & a(i) & VbCrLf ' Create return string.