Re: Macros with runtime

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Rick (anonymous_at_discussions.microsoft.com)
Date: 06/18/04 

Date: Fri, 18 Jun 2004 14:32:11 -0700

Steve,

My bad. Just realized I did not have the "c:\Program
Files\Microsoft Office\Office\MSACCESS.EXE in the command
line. It was just C:\CCS\CCSFront.mdb /x AutoUpdateN which
was opening the db but not running the macro. When I added
c:\Program Files\Microsoft Office\ART\Office\MSACCESS.EXE
it works (I don't know why my set up program installed
MSACCESS in ART, but anyway that fixed it. Thanks.

>-----Original Message-----
>Rick,
>
>Hmmm. Can't think of what's happening here. What does
the macro do?
>
>According to my understanding, it would be unusual to
have the Access
>Runtime files in c:\Program Files\Microsoft
Office\Office\.
>
>--
>Steve Schapel, Microsoft Access MVP
>
>
>Rick wrote:
>> Steve,
>>
>> It is opening the database and the start up form, but
not
>> running the macro. Here's the command line:
>> "c:\Program Files\Microsoft Office\Office\MSACCESS.EXE"
>> C:\CCS\CCSFront.mdb /x AutoUpdateN
>>
>> Thanks.
>>
>> Rick
>>
>>>-----Original Message-----
>>>Rick,
>>>
>>>I know of no reason why the fact of Runtime would
affect
>>
>> the functioning
>>
>>>of the macro. Is your command line actually opening
the
>>
>> database? And
>>
>>>I presume you are using the /x macro switch in the
>>
>> command line?
>>
>>>--
>>>Steve Schapel, Microsoft Access MVP
>>>
>>>
>>>Rick wrote:
>>>
>>>>When I open my database at night, with windows
>>
>> scheduler
>>
>>>>to perform some procedures I use a comand line which
>>
>> runs
>>
>>>>a macro upon opening. During normal hours I open it
>>>>without running the macro.
>>>>I just tried opening with the command line from a
>>
>> computer
>>
>>>>using Runtime Access and the macro did not run. Should
>>>>Runtime be able to run a macro from a command line
>>
>> prompt?
>>
>>>>Or is there another way to run that macro (or the code
>>
>> it
>>
>>>>actuall running) from a command line?
>>>>I don't want to run the procedure when I open the
>>
>> database
>>
>>>>normally.
>>>>
>>>>Thanks.
>>>>
>>>>Rick
>>>>
>>>
>>>.
>>>
>.
>

Relevant Pages

  • Re: Form doesnt open
    ... There isn't enough memory to perform this operation. ... If you now remove that command button and save the form, ... Have you tried creating a new empty database, ... and then opening the form from the ...
    (comp.databases.ms-access)
  • Re: Calling access with parameters
    ... You can pass parameters by using the /cmd switch when opening the database. ... This specifies that what follows on the command line is the value that will ...
    (microsoft.public.access.modulesdaovba)
  • Re: Form @ Opening of db
    ... JHL wrote: ... >How do I stop a form page with command buttons from opening when accessing a ...
    (microsoft.public.access.forms)
  • Re: Macros with runtime
    ... It is opening the database and the start up form, ... running the macro. ... Is your command line actually opening the ...
    (microsoft.public.access.macros)
  • Re: Logging users
    ... Rick B wrote: ... by opening a form with the database. ...
    (microsoft.public.access.security)