Calling a VBA Function

Question

Dear Experts ( Ms Access);

I asking for your help again on how to call a J Street function from a module , I managed to import it together with a macro the way it is in the sample database without errors or error free. Now how do I call it on my login form (Start-up form) , I like using this form because that where the module for checking value date is  see below no warning is required if the subscription period is over:

Private Sub Form_Open(Cancel As Integer)

  if date>= "#10/15/2016#" then

 msgbox("Sorry Evaluation Period Expired")

   DoCmd.quit

Exit sub

End if

End Sub

Assuming now I decide to use on load event below , what name should I use to call the J Street function. Example

Private Sub Form_Load()

Call ???????????????

End Sub

Regards

Chris

Answer 1

Thank you very much sir , you have managed to rescue me from deep water of Atlantic Ocean , the major mistake I making was calling the code wrongly like you pointed out below:

Call jstCheckTableLinks_Full()  exactly this is where the problem was.

Now I have also created a button to facilitate the change of linked BE to another just in case need arises in future as follow:

Call jstCheckTableLinks_Prompt()

Once again thank you so much

Regards

Chris