A dream: What I do miss about Access.

[KitaYama]

I'm a novice Access user and my dreams are not as necessary as most of you, but well I do miss some functionalities being added to Access.
I know guys in control don't hear us, no matter how loud we shout. After all it took them more than 20 years to add a decent sql editor (which still is not decent).
I also am aware these are only dreams and will never come true, but at least mentioning my expectations here, can be a relief for me. I can say I asked for it, nobody answered.

I think Access can be better with these options:

1. Search utility for vba project window
   When you have a large project with hundreds of forms, reports, modules, .... it's a pain to find a specific object in the tree. A search box like navigation bar can help a lot.
2. An option for hiding Type column from Locals window
   If I'm debugging a code, I know my variable data types. The Type column takes one third of the width of Locals window, and every time I'm debugging, I have to drag and minimize it to be able to see Value column better (specially for variables holding sql statement or strings). Frequently I have to add a Debug.Print to see the actual value that is not fit in the width of Value column.
3. Being able to delete alias from query design
   When I inherit a database, or open a query that I've written long ago and uses alias for tables, and it has a complicated sql, It's more understandable to see the actual table names instead of a one letter alias. I prefer to see tblOrders.RegisteredOn rather than o.RegisteredOn. Some of you may have a intel core I15 brain and don't need it, but still I think clicking a table in a query design view and deleting the alias in property sheet, should revert the actual table name, instead of an error.
4. Having a way to list all functions in a project and search through them
   At present, I use a table for this purpose. Any time I add a sub/function, I have to add it to a table to be able to track it.
   When you want to add a functionality to your database, you write a new code that certainly calls some functions. You remember a lot of your functions, but my money is on nobody remembers a function he/she has written 10 years ago. So mostly we end up having duplicate functions that do the same task. I know your suggestion would be use a meaningful function name, but still there's a good possibility to end up functions doing similar tasks in a database with thousands and thousands of lines of code.
5. Keyword highlighting in vbe
   Clicking a keyword/variable..... , highlights all instances of the keyword in current function/sub. Even an application as simple as notepad++ can do it. why not Access?

What do you need to be added to current functionality of Access?

 

[theDBguy]

Not sure if this helps with number 4, but if I remember the name of a function I created a long time ago but not sure if I already put it in the current database, what I do is type its name in the Immediate Window and then hit Shift+F2 to quickly find it.

 

[KitaYama]

but if I remember the name of a function

That is my problem right there. That's a big IF.
The problem is one may have forgotten he's written a function with similar or exact same functionality several years ago.

A while back, I wrote a function to zip and add a password to a drawing and send it by mail. For this task, I wrote a function to find where the drawing is saved based on several rules to be able to zip it.
It was only days later that I found I had a function with a slightly different name to find the saved drawing on server.

 

[MajP]

I create a lot of standard modules and application specific. Example
MdlFormUtilities
MdlRelinkUtilities
MdlApplicationUtilities
...
Then if I know the procedure deals with form manipulation I simply type "MdlFormUtilities." And use intellisense.

 

[MajP]

@KitaYama
Do you use MZtools, rubberduck, or any Other Vbide addins?

 

[KitaYama]

@KitaYama
Do you use MZtools, rubberduck, or any Other Vbide addins?

Only MZtools

 

[Galaxiom]

It isn't hard to write a sub to read the VBA to list all the functions in a project and write them to a table. The parameter names and their datatypes could be included as fields.

Every Access developer should get the free V-tools plugin. Total Deep Search is incredibly useful an has a Replace function that goes many places where the Access Search doesn't look.

 

[KitaYama]

Every Access developer should get the free V-tools plugin.

The following form is what I have at present.
I can type a word in the combo, and press enter. All the functions that contains the keyword in their name or purpose are shown.
In bellow screen shot, I've searched for Drawing and can see a list of functions I have. From there, I can check if I need a new function or use something I already have.
If I search the project for Drawing keyword with MZ-Tools, I receive 1,828 hits. That doesn't help much.
Does V-Tools has an option to search only for functions/Subs names?

 

[Edgar_]

Take a look at Twin Basic. You could create an Add-In that helps with some of those. However, I do certainly believe the VBE is outdated as hell.

What do you need to be added to current functionality of Access?

VBE
> Code folding: collapsing blocks of code
> Multi cursor: editing multiple parts of the code simultaneously with the same keystrokes
> Listing methods in the debuggers
> Code completion
> Ctrl + Click to go to the definition

And more