Access（非VBA）宏是否已过时？ [英] Are Access (non-VBA) Macros becoming obsolete ?

问题描述

我之前在一个帖子中发表了这个声明......


宏因为很难维护而变得过时了


JConsulting建议我创建一个关于这个主题的辩论，所以我是:)


我做了这个陈述，因为在设计定制应用程序（我这样做）时我得到的一般反馈IT部门不会使用宏，因为它们在长期维护和数据库的未来维护方面会使生活变得困难。


我从不在应用程序中使用宏并使用vba对所有内容进行编码。这允许我评论所有动作，以便将来维护和开发。


请讨论。


Mary

I made this statement in a thread earlier ...

"Macros are becoming obsolete as they are very difficult to maintain"

JConsulting suggested I create a debate on the subject, so I am :)

I made this statement because when designing bespoke applications (which I do) the general feedback I am getting from IT departments is not to use macros as they make life difficult in terms of long term maintenance and future upkeep of the database.

I never use macros in applications and code everything using vba. This allows me to comment all actions to allow for future maintenance and development.

Discussion please.

Mary

推荐答案

我从来没有学过如何使用宏，但我觉得使用宏和vba会导致比任何事情更混乱。

I never did learn how to use macros but i feel that using both macros and vba would lead to more confusion than anything.

我从来没有学过如何使用宏，但我觉得使用宏和vba会导致更多的混乱。

I never did learn how to use macros but i feel that using both macros and vba would lead to more confusion than anything.

你好玛丽和杰夫，

Imho Macros将永远扮演VBA的第二小提琴，但由于3个主要原因将有自己的小利基：

1.能够在excel和word中使用宏录制器来生成有助于集成和使用自动化对象的工作VBA代码。

2.新手似乎感觉舒服，并且可以比VBA更快更容易地创建宏......并且总会有新手。

3.使用宏比VBA更容易和更好地完成一些事情.....例如... autoexec宏和任务调度.......


我的2美分。


PDB

Hi Mary and Jeff,
Imho Macros will always play second fiddle to VBA, but will have their own little niche for 3 main reasons:
1. the ability to use the macro recorder in excel and word to generate working VBA code that facilitates the integration and use of automation objects.
2. Newbies seem to get comfortable with and can create macros much quicker and easier than VBA......and there will always be newbies.
3. There are some things that are easier and better done with Macros than VBA.....for example...the autoexec macro and task scheduling.......

My 2 cents.

PDB

大家好，

我最近被雇用来使用Access 2007的客户端在数据库上工作。现在......我们'我们都已经听说过有关这个的故事......并且可能会在以后再讨论，但是......

交给我的数据库是创建的d来自M

Hi Everyone,
I''ve recently been hired to work on a database by a client that uses Access 2007. Now...we''ve already all heard of the stories about that...and probably merits another discussion later on, however...
The database that was handed to me was created from one of M

中的一个

这篇关于Access（非VBA）宏是否已过时？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！