Automatic Compiling

[Frank Wagner]

I have a software package that I've developed for schools using Access 2000,
and is distributed using the Sage distribution package.

I've recently made changes to the database, so when it is opened, it copies
one of two possible forms to a usable name depending upon the resolution of
the computer on which it is being used. The problem I have is that this
copying causes the database to need to be recompiled. Is there any way that
the database can be recompiled automatically using a statement that comes
right after the copy statement? If there is, would this also work with a
runtime version of the database.

Any help would be appreciated.

Thanks

 

[Dale Fye]

Why not just include both versions of the form, but displays the version
that is appropriate for the screen resolution. Then you could compile it
before packaging it.

 

[pddxxx]

I think this undocumented statement will compile your code

SysCmd 504, 16483 'save and compile code

.... but I wouldn't recommend using this in a production application.

FYI there are third-party form scaling solutions available that might
help:

A shareware version of a form rescaling module I wrote called
ShrinkerStretcher is available at this web site: http://www.peterssoftware.com/ss.htm

There's a form resizer at http://www.jamiessoftware.tk/resizeform/rf_jump.html
..

Another one: http://sourceforge.net/projects/modscaleform

The Access Developer's Handbook has form resizing code included:
http://www.amazon.com/exec/obidos/ISBN=0782119417/107-8064361-7403703

Hope this helps,

Peter De Baets
Peter's Software - Microsoft Access Tools for Developers
http://www.peterssoftware.com

 

[Frank Wagner]

Thanks for your suggestion. I've figured out how to change the form selected
based on the resolution without recompiling
--
Frank Wagner
(e-mail address removed)

Why not just include both versions of the form, but displays the version
that is appropriate for the screen resolution. Then you could compile it
before packaging it.

 

[Frank Wagner]

Peter:

Thanks. I've copied down the references you supplied.

Based on Dale's suggestion, I've figured out a way to select different forms
based on the resolution of the computer being used but the overall problem of
scaling form to fit different computers remains. This should help.