[AccessD] Compile from the command line

  Tid bits here, tid bits there...check out web sites, read white papers,
talk to other developers, etc.  And the CompuServe days were great when
product support was there; got the inside scoop on a lot of things<g>. 

Jim.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Friday, September 03, 2010 7:50 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Compile from the command line

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.
> 
> 
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com