Macro Find and Replace

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

We use MS Access with a large number of Macros that are very large. The
contain selection criteria to generate individual reports (some of them up to
300). There is no Find and Replace edit capability in Macros, like there is
in other MS Office products. Find and Replace inside Macros would be a great
enhancement.
--
Fred Benson

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...fdc874a5cd5&dg=microsoft.public.access.macros
 
Fred,

The way in which macros are normally used, such a facility would be of
little value. It sounds as if you are "hard-coding" specific data
values into macro Conditions or Arguments, and modifying these as part
of the production operation of your application. If so, there are
almost certainly more efficient ways of doing this, by referring to the
value of form controls, or using domail aggregate functions to return
the required values. Generally, macros are seldom seen or accessed
after the initial design. If you would like to explore this further,
please post back with some specific examples of what you have in mind.
 
I have a macro where I am trying to replace the minutes in a TIME field with
zeros to generate a report showing only the hour. I created a query with a
make table to use in doing this. It works fine with just the normal old find
and replace. I can bring the normal find and replace screen and 00 the
minutes each time the report is run manually but want to build it into the
macro so users don't have perform the replace every time they run a report.
The primary table is retained with the actual time for other purposes.

Rich
 
Rich,

If I understand you correctly, you can use the Format property of the
time control on the report. Set it like this:
hh:00
 
Back
Top