Charlotte Foust
cfoust at infostatsystems.com
Thu Nov 6 14:04:12 CST 2003
John, Why don't you just put the generic code you need into a code library and reference that from both your application and your generic process? It sounds like you've got a snake swallowing its tail. Wizards are supposed to be freestanding. They shouldn't call processes in the FE for the very reason you're tripping over. Make the FE use the wizard, not the other way around, or use a code library. Charlotte Foust -----Original Message----- From: John Colby [mailto:jcolby at colbyconsulting.com] Sent: Thursday, November 06, 2003 11:31 AM To: Access Developers discussion and problem solving Subject: RE: [AccessD] running code in a database without referencing the db I have a client where more and more processes need to be run automatically. Basically they need to send (email) reports to various clients automatically, receive reports and process spreadsheet attachments etc. I am trying to design a generic process system where the processes can be table driven. I would like this code to be a referenced wizard such that I have a FE if you will that has code in it that creates these reports and knows how to email them out. It has tables where it places data such as time / date to run the process and what function to call that is the process to run. It starts the wizard which loads the processes and at the correct time runs each process. The problem is that the process code is in the FE. The FE is starting a wizard and thus has to reference the wizard. The wizard has to call a function back in the FE. This is a circular reference and Access doesn't like circular references. I read stuff about circular references ages ago but can't find anything anymore. I vaguely recall something about as long as the modules are divided us such that the calls out and back in don't occur into the same module it could be done. Or I hallucinated that. Not sure which and can't find anything on it anymore. John W. Colby www.colbyconsulting.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Brett Barabash Sent: Thursday, November 06, 2003 2:14 PM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] running code in a database without referencing the db Can you define "without referencing"? Shell, DDE, mental telepathy? -----Original Message----- From: John Colby [mailto:jcolby at colbyconsulting.com] Sent: Thursday, November 06, 2003 12:08 PM To: AccessD Subject: [AccessD] running code in a database without referencing the db Is it possible to call a function in another database without referencing that db? John W. Colby www.colbyconsulting.com _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com