[AccessD] Compile from the command line

Jim Dettman jimdettman at verizon.net
Fri Sep 3 07:17:05 CDT 2010


  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




More information about the AccessD mailing list