Writing Code to a module automatically

[ricwat]

When a database is opened for the first time I want to be able to write a new global constant variable to a module. If after a time no one uses the database I want to remove this variable. I want the whole process to be VBA and linked to a startup form.<br>
<br>
Is this possile?

 

[bitbrain]

Interesting idea.<br>
<br>
From what I can tell, Access hides source VBA code. There are a couple of system tables that refer to modules but I have not been able to figure out how to use them. It would be nice if you could access & update the system tables through code.<br>
<br>
With VB5 you could potentially edit the .BAS text file through code...<br>
<br>
I would suggest re-thinking your problem. Maybe you should have a table of system variables. Your start-up form could read the table & set global variables as necessary.