working in the VBA editor

[Rockape]

Hia all,

I have a problem that when i start writing a bit of code the drop down lists of options dont stay on view on screen to actually view the entire list.

Does anyone know if there is a key i should press or combination of keys to press.

Thanks

 

[Trevor G]

Have you got a timer event going as this causes the list to disappear.

F2 on the keyboard will open the object browser list.

 

[Rockape]

Hi,

F2 doesnt work for me because i want to know what i can assign to what i'm writing.

F2 produces a long list and i dont know waht i can assign!!

thanks

 

[Trevor G]

OK if that doesn't work for you have you tried using me.

The word me basically stands for Object and the fullstop will then show you the list of objects. So if working on a form and you want to refer to a textbox then

me.textbox.visible=true

something like the above

 

[Poppa Smurf]

If you type in Docmd. the list will be displayed but as soon as you enter a space the list will disappear. This will be same for other drop downs if you enter a space.

 

[Rockape]

Hi,

i wish i could say that works .. but alas no!

it also happens with those two commands!!

regards

 

[Trevor G]

Again I ask do you have a timer event within the database?

 

[Rockape]

Hi,

Yes, just checked. But why should that be a problem?

Again I ask do you have a timer event within the database?

 

[Trevor G]

When each timer event is set it is using the pc time, so it interupts you when you are coding in vba.

If you create a blank database and then don't use timer events you will be able to use the suggested options of me. and docmd. and the lists will stay active until you do something else.

 

[Rockape]

Hi,

many thanks. Instead of removing it I just increased tenfold and now it works...

thanks again

When each timer event is set it is using the pc time, so it interupts you when you are coding in vba.

If you create a blank database and then don't use timer events you will be able to use the suggested options of me. and docmd. and the lists will stay active until you do something else.