Bypassing default switchboard under condition

[TomH]

Hi all.

We're looking to start sending auto-generated emails that will act as notifications when certain updates are made in a multi-layer approval process. In other words, a submitter makes a requisition request, his manager must approve or deny, then the VP, then the budget team. On each of these steps, we want an email to be sent to the next person in the chain saying that the previous step has been completed.

I can design the email... what I don't have are the email addresses, and most likely can't get them from any reasonable source in the company's data warehouses. So.... what I'd like to do is set up a table of User_ID, which they use to sign in with and we capture for display on screen, and the email address. THEN... and this is the important part... I want to bypass the normal switchboard at sign-in IF the email adress for that user is NULL. A screen would come up before the switchboard asking for the email and, once completed, that form would disappear and the user would be shown the normal switchboard. Once they have entered their email address, they wouldn't see the form asking for the email ever again.

It seems like a simple problem, but I have been having real problems conceiving what is necessary to get this done.

Any help is greatly appreciated.

 

[DreamOn]

Hi Tom

I dont have access in front of me to test this, but you could try to put this on the onload event on the switchboard...

If IsNull(DLookup("emailfieldname","tablename", "UserID = UserID")) Then
DoCmd.openform "customformforenteremail",,,"UserID = UserID"
end if

There maybe some mistakes in this coding as i cannot test it right now, but this should give you an idea.

-Dream

 

[gemma-the-husky]

I would say you need an autoexec function and no set startup form, or a different "splash" startup form that opens before the switchboard

do these checks in there, and then open the switchboard.

that's probably easier than trying to put it all in the switchboard open event.


create a MACRO called AUTOEXEC. set this to run your new function. This will be called first in your app.

 

[TomH]

Great ideas guys. Thanks. This should get me started.