VBA Auto fill code feature

[gblack]

Hey,

I am trying to figure out what the term for that auto-fill feature in VBA is called...I'm talking about the one that automatically gives you dropdown choices. Mine isn't working right but I don't know what it's called to research the issue.

My problem is:
Whenever I write any code if I hit the space bar it instantly pushes my cursor back to the lat word. Very annoying! Also all the auto drop down stuff pops up for a milisecond then disappears...

Does anyone know why this could be happening? Or at least know the name of this feature, so I can look up my issue?

Thanks,
Gary

 

[vbaInet]

It's called Intellisense.

In the VBA editor go to TOOLS > OPTIONS > AUTO LIST MEMBERS

Also, check your REFERENCES (under TOOLS) to ensure you have ticked the libraries you want to work with. Without that Intellisense won't work.

 

[gblack]

It's not that it's not working... it is, but it only shows up for a brief moment then diappears... there seems to be something going constantly in the background messing things up... but I don't know what. If I look at the title bar while I am in the code, it is constantly flickering... I don't know why.

But the irritatiing thing is that it won't let me type I have to type everything out, then go back and put the spaces back in. for instance:

I'dhavetotypethisfirstthengobackandchangeittothis:

I'd have to type this first then go back and change it to this.

which is highly annoying!

 

[vbaInet]

What are we talking about here?? VBA editor or list/combo box?

Give some real examples.

 

[gblack]

I am talking about intellisense... not a list combobox. What I meant was intellisense usually gives you a dropdown menue to choose from as you're writting your code.

Mine does this as well, but then disappears before I can even hit a key.

So yes I am talking about the VBA edit section where you write your VB code.

As I write my code Intellisense sees fit to notallowmetousespaces. This is a weird thing and I don't know why it is doing this, but my thought is something is continually running in the background (denoted by my flickering title).

The title says: Microsoft Visual Basic - [Name of Database] - [Name of Form (code)]

however the [Name of Form (code)] part keeps flcikering back and forth... it's too fast to read what it flickers to, but it it continually doing it...

That's about as well as I can explain it.

Thanks,
Gary

 

[vbaInet]

Hit the RESET sub menu which is under RUN menu.

Also, create a new db shell and import all your objects into that.

 

[gblack]

Great ideas! I will try them.

 

[gblack]

Unfortunately... neither worked

 

[vbaInet]

Never seen this problem and I think it may just be your Access:

1. Take a not of all the references you have
2. Untick the boxes and OK
3. Debug > Compile
4. Tick the relevant boxes again
5. Debug and compile.

If that doesn't work, then I would advise to get a different copy of Access, run your db on there and see if it works as expected.

Also, try reinstalling your Access.

 

[Khalid_Afridi]

I think your forms have somewhere timer on them and that is open and causing this problem.

This happened with me, whenever I open the code between halfway of my forms running, so it happens. I always close all the forms and then open the desire form only in design mode, not in running state.

try it out.

 

[gblack]

Yeah that must be it... I do have a timers on several forms... And I thought that might have been the issue, so I took the timer off the form I was working in and I still had the problem, so then I thought maybe not... but now that you mention you were having the same issues because of timers, that's probably the answer...

Thanks for everyone's comments! They are much appreciated.
-Gary

 

[Khalid_Afridi]

Yeah that must be it... I do have a timers on several forms... And I thought that might have been the issue......

Thanks for everyone's comments! They are much appreciated.
-Gary

You are welcome, I hope you got that works!

 

[ScribeGuy]

I had same problem. It's timers. I'm no expert but I'm suspicious of timers. I only use one becuase I want current time on the user's dashboard. Is there a better way to add current 'real' time to a form? You'd think it would be an easy no-brain add-in for Access - like the pop-up calendar.