Inconsistent results in the Immediate window

[Amyfb]

I'm working thru exercises in a book on access2019 programming. This bit of intro code to collections is not cooperating. I don't know enough to tell if it is correct or flawed.
EDIT to say that the "set" statement is what seems wrong. I replaced it with Dim collection myTestCollection as New Collection and all works fine.

grumble at the book editor.

i'll leave this rest here in case it helps anyone else.

I'm instructed to type this into the immediate window to begin.

#set myTestCollection = New Collection
#myTestCollection.Add"first member"
#myTestCollection.Add"secondmemeber"
#myTestCollection.Add"thirdmember"


#?myTestCollection.Count

first time - .Count results were 0
i erased and reentered it all again several times, and finally, I don't know what was different but got the expected count of 3.

Then I tried calling the one item and got the correct results.
myTestCollection.item(1)

then i tried the remove code
and when i recounted to verifty , the result was 1.

so i erased it all and typed it in again, and got 0 results on the Count.

i erase and type again and now i get a count of 4.

in this endless cycle of erase and retype I get inconsistent results every time.

here's the latest - why did the count go to four after the first Remove 1 line?

#set myTestCollection = New Collection
#myTestCollection.Add "first"
#myTestCollection.Add "section"
#myTestCollection.Add "third"
#?myTestCollection.Item(1)
#first
#myTestCollection.Remove 1
#?myTestCollection.Count
#4
#For Each m in myTestCollection : myTestCollection.Remove 1 : Next
#?myTestCollection.Count
#0

I've scrutinized code for typos, and fixed them when found. I can't find any more.

All ideas welcome.

thanks
Amy

[Minty]

I've just typed in the same and this is the immediate window result

set myTestCollection = New Collection
myTestCollection.Add "first"
myTestCollection.Add "section"
myTestCollection.Add "third"
? myTestCollection.Item(1)
first
myTestCollection.Remove 1
? myTestCollection.Count
 2

[davegri]

After you type it in and syntax is correct, put cursor at first line and hit enter for each line to execute it. Things should work as expected.

[Amyfb]

I've just typed in the same and this is the immediate window result

set myTestCollection = New Collection
myTestCollection.Add "first"
myTestCollection.Add "section"
myTestCollection.Add "third"
? myTestCollection.Item(1)
first
myTestCollection.Remove 1
? myTestCollection.Count
 2

I don't understand why the Set command won't work for me.
I typed the exact same thing but got goofy results.

If you saw my edit, I had to use Dim collection As before I could get the right results.

Is there something you can tell me about the difference or similarity between the two different approaches?

thanks

[orange]

What is the purpose of the # as leading character??

This worked for me

set myTestCollection = New Collection
myTestCollection.Add"first member"
myTestCollection.Add"secondmemeber"
myTestCollection.Add"thirdmember"
?myTestCollection.Count
3
?myTestCollection.item(1)
first member
myTestCollection.Remove 1
?mytestcollection.count
2

Note your For loop will remove all items in the collection - hence Count 0

Another tutorial/article.

[Amyfb]

After you type it in and syntax is correct, put cursor at first line and hit enter for each line to execute it. Things should work as expected.

???
well that's an unexpected instruction. But I tried it, typed in the code again, then did what you described, and it all works just fine.

now how is anyone supposed to know that hitting enter at the end of a typed line isn't actually executing the line command?
sheesh!

did I just get lucky with the other uses of the immediate window?
or is this one of those "depends" conditions?

thanks for the input!

[Amyfb]

What is the purpose of the # as leading character??

....

Some moderator's post asks for code snips to have the hashtag. I guess i did it incorrectly.

sorry.

[Micron]

Some moderator's post asks for code snips to have the hashtag. I guess i did it incorrectly.

that was likely a reference to the toolbar button. As I type here, it is immediately above the bold red letter.

[davegri]

???
well that's an unexpected instruction. But I tried it, typed in the code again, then did what you described, and it all works just fine.

now how is anyone supposed to know that hitting enter at the end of a typed line isn't actually executing the line command?
sheesh!

did I just get lucky with the other uses of the immediate window?
or is this one of those "depends" conditions?

thanks for the input!

Hitting enter while on a line does execute it. For the code to work properly, each line must be executed in order, top to bottom.
Probably in the failed attempts, your editing of the lines resulted in lines being executed out of order.

[orange]

The hash tag they are referring to is this one

[Amyfb]

The hash tag they are referring to is this one

oh my, is my face red, or what!

thanks for steering this newbie in the right direction.

[orange]

now how is anyone supposed to know that hitting enter at the end of a typed line isn't actually executing the line command?

It comes with the territory and years of experience (and mistakes/corrections....)

[Amyfb]

It comes with the territory and years of experience (and mistakes/corrections....)

let me understand - am I to go back to all my module and class codes where I have edited it and hit the enter button on the edited lines to be sure it executes?
or is this just an immediate window thing.

[davegri]

let me understand - am I to go back to all my module and class codes where I have edited it and hit the enter button on the edited lines to be sure it executes?
or is this just an immediate window thing.

No fear, it's just the immediate window requirement.

[orange]

Was at lunch; slow to respond, but davegri has the answer.