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...

First off you need to normalise your database and proceed from there. A typical client/contact database will include the client id in the contact table and does not need the contact id in the client table. Start with a simple client/contact form and ensure it works. The contact form can be a...

Thanks Pat this did it for me. It stops the message coming up just as required As for your warning Sage does not allow updating in this manner so it is perfectly safe. Regards Neil

TransferDatabase method Ok i will have to investigate more here. I think that there is a startup code that runs behind the switchboard form that refreshes all links to the backend dbase. I could be mistaken as i did not design it. But if what you say is correct it must be hidden in there...

TransferDatabase Method I see what you are saying about only asking for log in when you access the linked table. I think however that Access refreshes all links when it starts and so it finds the Sage one and asks you to log in. Even a db with no code in does this if the sage linked table is...

TransferDatabase Method Thanks for the reply. My problem is that if i have the link to the table there on startup it asks all my users to log in to Sage. And sometimes it appears that if they do not have the correct sage permissions (because of security in sage stopping unauthorised users...

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...