Order of Execution

[lespaul]

Can someone please explain the order of execution and the differences between OnCreate, OnActivate and OnIntialize. I realize that OnCreate happens when the application starts, but the others I can't quite grasp the differences.

Thanks! Leslie
landrews@metrocourt.state.nm.us

SELECT * FROM USERS WHERE CLUE > 0
No Rows Returned

 

[mikeEd]

OnActivate occurs whenever you switch to the form. What is OnInitialize an event of?

 

[lespaul]

I guess it's actually FormIntialize. Leslie
landrews@metrocourt.state.nm.us

SELECT * FROM USERS WHERE CLUE > 0
No Rows Returned

 

[mikeEd]

Are you sure? I've never heard of that either.

 

[lespaul]

No I'm not sure! I swear it was there somewhere! Anyway, here's the real problem I'm trying to solve. When my program first opens I want to check if a process has already occurred (I check the database to see if a specific field is marked 'Y'). If the process has already occurred, I need to check a specific directory to see if files exists. If the files exist then a messagebox informs the users that the documents need to be printed. But I don't want it to happen each time the main form is activated. So I tried the FormCreate, except since I have to run a query I get 'Access Violation error'. So I need a procedure that will only run the first time the form is opened for a users. Any suggestions?

THANKS!! Leslie
landrews@metrocourt.state.nm.us

SELECT * FROM USERS WHERE CLUE > 0
No Rows Returned

 

[EricDraven]

You can do this using the forms oncreate procedure. The problem your encountering is probably due to the creation order of your forms. For example, if you perform the check in form1's oncreate procedure, and you are referencing something from say form3, then form 3 has not yet been created so an error is thrown up. Goto Project and View Source to see what order your forms are being created in. Arte Et Labore

 

[lespaul]

Thanks, I just tried moving things around to see if that would solve it. Nice to know that occasionally I have a clue!

Leslie
landrews@metrocourt.state.nm.us

SELECT * FROM USERS WHERE CLUE > 0
No Rows Returned