| Brendan Reynolds 2005-04-22, 8:24 pm |
| You're more likely to get an answer in the macros newsgroup, Rick. There are
only a few people who answer questions about macros, and they're more likely
to see your question there. If you're using a newsreader program such as
Outlook Express, the newsgroup is microsoft.public.access.macros. If you're
using the web-based interface, the URL is
http://www.microsoft.com/office/com...c.access.macros
--
Brendan Reynolds (MVP)
"Rick Patsula" < RickPatsula@discussi
ons.microsoft.com> wrote in message
news:BC82A309-3DAF-415D-B755- 7D403B895ADC@microso
ft.com...
> hi i'm having problems getting the syntax correct in a macro that will
> open a
> report. i want to use the orderby property. i'm using the setvalue method
> in
> a macro. the report is called rpt_project and the field that i want to
> order
> by is lname. here is the syntax i'm using.
> setvalue
> item [Reports]![rpt_proje
ct].[OrderBy]
> expression [Reports]![rpt_proje
ct]![lname]
>
> what am i typing incorrectly in the expression part.
>
> thanks
> rick
>
|