Re: app.path in access 97 module

Tech-Archive recommends: Speed Up your PC by fixing your registry



Not my idea, just something I picked up from the newsgroups.

In later versions of Access you can use CurrentProject.Path, but that was
new in Access 2000, so won't work in Access 97.

--
Brendan Reynolds (MVP)


"Chris" <Chris@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:792CEF9B-D377-4116-9AD0-976A07E312A9@xxxxxxxxxxxxxxxx
> Thanks
>
> Excellent approach.
>
> "Brendan Reynolds" wrote:
>
>> Left$(CurrentDb.Name, Len(CurrentDb.Name)-Len(Dir(CurrentDb.Name)))
>>
>> --
>> Brendan Reynolds (MVP)
>>
>>
>> "Chris" <Chris@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:A416F2CB-3C25-4911-AF18-86EEB525D5C9@xxxxxxxxxxxxxxxx
>> > Hi,
>> >
>> > In a VBA module in Access97 I want to call a shelled application.
>> >
>> > shell(app.path & "\myapp.exe")
>> >
>> > I can't seem to figure out which reference I will use to provide the
>> > app.path function to me. I get a library or function not found.
>> >
>> > or can I get the application path using application. in someway?
>> >
>> > thanks
>> >
>> > Chris
>> >
>>
>>
>>


.



Relevant Pages

  • Re: How to determine source of opened form
    ... Brendan Reynolds (MVP) ... I have a procedure that I wish to run depending on which form was used ... Prev by Date: ...
    (microsoft.public.access.formscoding)
  • Re: Microsoft Office Word index
    ... Herb Tyson MS MVP ... Please respond in the newsgroups so everyone can follow along. ... Prev by Date: ...
    (microsoft.public.word.pagelayout)
  • Re: Printing on an envelope
    ... Herb Tyson MS MVP ... Please respond in the newsgroups so everyone can follow along. ... > now about 1" from side and about 3/4 inch from top. ... Prev by Date: ...
    (microsoft.public.office.misc)
  • Re: Delivery address will not print on envelopes
    ... Herb Tyson MS MVP ... Please respond in the newsgroups so everyone can follow along. ... the delivery address does not appear on envelopes. ... Prev by Date: ...
    (microsoft.public.word.docmanagement)
  • Re: Removing extra spaces between words
    ... Herb Tyson MS MVP ... Please respond in the newsgroups so everyone can follow along. ... > Is there a way to remove extra spaces between words so there is only one ... Prev by Date: ...
    (microsoft.public.word.docmanagement)