Help needed in the functions

[kavya]

Hi all,

I am working on the project which is split to front end and back end databse. There are some public functions in the general module section, which I see are mentioned no where except in the module they are created. My question is since they are not called anywhere will the functions do what they have to when just the database is run, for eg if you run a report or work on a query.
Please help me in this regard.

Thanks a lot in advance

 

[DougP]

A Public function can only be used in the .MDB or .MDE where it is. It can be used in any form or other function or query or report.
It cannot be used or called in another .MDB or .MDE
DougP, MCP

Visit my WEB site

http://www.barcodeone.com

to see how Bar-codes can help you be more productive

 

[MichaelRed]

Doug,

Not quite. But it probably isn't the best suggestion for novices. Look up "references" in HELP. You can use functions from any/all/every referenced MDB file you can find and reference.

I generally keep many of the (Common?) functions in a seperate (code only) database and reference it.


MichaelRed
redmsp@erols.com

There is never time to do it right but there is always time to do it over

 

[scking]

kavya,

I believe your question is slightly different from what the responses answered. As I understand it you are claiming that functions are not referenced from within any other modules within the database. Be aware they could be called from queries, forms, etc. My shortcut to determine whether a function is called is to compile all functions and ensure that they compile without error, then, using a copy of the database, CUT the function from the module and try to recompile. If it successfully recompiles you can be assured that the function is NOT called anywhere from within the database.

The second part of your question, will the functions work if they are called, is more complex. The answer is, it depends. Depends on how they are called, with what data, and from where, what permissions they have, etc. etc.

I suggest that, if you have any functions that you need to be assured work, that you test each one using the debug window and breakpoints. Call the function from the debug (immediate) window and examine its operation at each step to ensure the results will be satisfactory.

General Guidelines:
-Use F9 to toggle a breakpoint on and off.
-Use F8 to take a single line step.
-Hold the cursor over variables and examine their contents.
-Examine the output of the function.
-Ensure it has error trapping.
-If it is then called by another function then run that function to verify that they output can be properly processed by that function.

Steve King