Please give me this answer.

A

Andy Couch - UK Access User Group

Wizards are a good way to get started using a feature in Access which you may
not use often, or are about to use for the first time. However, with some
experience you will often find that it is quicker simply to make a copy of
something, and change it rather than use a wizard.

As an example if you are creating a set of reports, you will probably be
quicker to make a copy of the report and then customise the report changing
the data source.

The beauty of Access is it allows you to do things in so many different
ways, which you find changes as you gain more experience with using the
product.

I personaly don't tend to use the wizards, but I often use the expression
builder.

So in summary it is down to you, there is not hard and fast rule here.
 
B

Brendan Reynolds

The wizards are a diverse bunch. Some are much better than others. The
report label wizard does a good job. If you're printing to standard labels,
it can be a big time saver. Many of the command button wizards, on the other
hand, produce very poor code, using unreadable 'DoMenuItem' syntax that has
been obsolete since the release of Access 97.

There's no 'one-size-fits-all' answer to this question. I would never use
the above-mentioned command button wizards. But to someone who is not a
professional developer and does not wish to learn VBA, who just wants to
knock together a quick-and-dirty throwaway tool for their own one-off use,
then even the poorest of the command button wizards may be a timer saver.
 
Top