[AccessD] Compile from the command line

Gustav

 > Like you and me - followed the thread "How to Compile from code" in January/February 2000.

ROTFL.  Unlike me, he can still remember 2000.  ;)

Does anyone know if the archives are functioning?  I tried a search yesterday and got no result for 
anything searched for.

John W. Colby
www.ColbyConsulting.com


Gustav Brock wrote:
> Hi John
> 
> Like you and me - followed the thread "How to Compile from code" in January/February 2000.
> 
> Note that this command cannot compile the module within it is running - this module has to be compiled earlier.
> 
> /gustav
> 
> 
>>>> jwcolby at colbyconsulting.com 03-09-2010 13:50 >>>
> Cool.  Where do we learn such things?
> 
> John W. Colby
> www.ColbyConsulting.com 
> 
> 
> Jim Dettman wrote:
>> A call to SysCmd(504, 16483) will compile a VBA project.  That coupled with
>> your startup idea should take care of John's problem.
>>
>> Warning:  Syscmd(504,x) is un-documented.  Your mileage may vary.
>>
>> Jim. 
>>
>> -----Original Message-----
>> From: accessd-bounces at databaseadvisors.com 
>> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan
>> Sent: Friday, September 03, 2010 2:55 AM
>> To: Access Developers discussion and problem solving
>> Subject: Re: [AccessD] Compile from the command line
>>
>> Include an Autoexec macro in  your database which calls a startup function.
>> In your startup function include the line.
>>
>> If Command = "Compile" Then Application.Quit
>>
>> Then in your batch file, ue the switch /cmd "Compile"
>>
>> The database will compile itself when the Startup function is loaded and the
>> function will then close the database.
> 
> 
>