Object List Problem

[dccjr]

Ok, this is a complete Noob problem. Whenever I have used the VBA Editor in Access and type something like Me. it has a floating window woth all of the objects in it. Or properties for the object. I now get nothing when I type. Have I inadvertantly changed a setting, or is there a error in the code above that is preventing it?

[pbaldy]

Check

Tools/Options/Editor/Auto List Members

[Estuardo]

G'd evening,
In the vba editor go to the main menu select tools-->options-->editor under the Editor tab find the radio button Auto List Members and mark and enable that option. (Sorry Paul, i was typing when you posted )

[pbaldy]

You're too slow my friend!

[dccjr]

It is enabled, but still nothing. I have the following at the top of the Code:

Option Compare Database
Option Explicit
Public cenSQL, endSQL As String
Public intSetNo As Integer
Set cenSQL = "','"
Set endSQL = "');"

If I comment out all but the Option lines, it works. Am I not declaring these global variables correctly?

[June7]

cenSQL is not explicitely declared as String so it will default to variant. Unlike some languages, in VBA all variables must be individually declared or they will be variant type.

Public cenSQL As String, endSQL As String

However, don't see how any of this causes intellisense to deactivate.

[dccjr]

Figured out a solution. Since these never change between procedures I defined the as constants like this. Everything works great now. Learned something else.

Option Compare Database
Option Explicit
Private Const cenSQL As String = "','"
Private Const intStartNo As Integer = 1
Private Const endSQL As String = "');"

Thanks to all of you guys for the continued help.