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:
What do you need to be added to current functionality of 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:
- 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. - 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. - 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. - 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. - 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?
Last edited: