Search results

I have an after update event on an email field set as a hyperlink. It has a default value of mailto: and a user enters the email address. The after update event is supposed to check that mailto: exists and if not to add it. However the fileds can end up with different contents as shown below...

I am trying to dynamically link to a table in Sage Line 50. When i use DoCmd.TransferDatabase acLink, "ODBC Database", "ODBC;DSN=SageLine50v9", , "INVOICE", "INVOICE" It works but asks the user to choose a unique record identifier. I would like to do this automatically. Is there a way...