One way to transfer Info from MI to Access:
1. Print the chosen objects id (some id also used in access) to a textfile. 2. Use a DDE from MI to start a VBA macro in Access. 3. Get the Access macro to read the text file. 4. With the id's now in Access, you can update your form. I havent found a way with clean DDE from MI to Access, but must use a text file. The other way: Access to MI is easy with MapBasics RemoteMsgHandler Jakob ------------------------------------------------------------------------------------------------ Jakob Lanstorp, M.Sc., Computing Geologist Kampsax A/S - GIS Software & Solutions Rugaardsvej 55, DK-5000 Odense, Denmark Tel: +45 6313 5013, dir:+45 6313 5011, fax: +45 6313 5090 Mailto:[EMAIL PROTECTED] - http://www.kampsax.dk Authorized MapInfo Partner & Distributor in Denmark and Norway. ------------------------------------------------------------------------------------------------ See Denmark from above on: http://www.kortal.dk "Lawley, Russell S" <[EMAIL PROTECTED]> Til: "'[EMAIL PROTECTED]'" Sendt af: <[EMAIL PROTECTED]> [EMAIL PROTECTED] cc: onsmag.com Vedr.: MI-L Microsoft access and mapinfo 12-03-02 11:20 Besvar venligst til "Lawley, Russell S" Hi, I need some advice. I need a simple and fool proof way of interactively using Mapinfo and MS access. I can think of several ways of doing what i want (click on a mapinfo map object, up pops an access form with my data), but I am also aware that there are right and wrong ways of going about this, particularly with the range of access, mapinfo and windows versions flying around at the moment. The last Mapinfo-Access tool i write was over 4 years ago (and it certainly doesnt want to work now). If any of you can can give me some advice on simple coding and 'pitfalls' i'd be very grateful.. will sum regards Russell Lawley British Geoogical Survey ********************************************************************* This e-mail message, and any files transmitted with it, are confidential and intended solely for the use of the addressee. If this message was not addressed to you, you have received it in error and any copying, distribution or other use of any part of it is strictly prohibited. Any views or opinions presented are solely those of the sender and do not necessarily represent those of the British Geological Survey. The security of e-mail communication cannot be guaranteed and the BGS accepts no liability for claims arising as a result of the use of this medium to transmit messages from or to the BGS. The BGS cannot accept any responsibility for viruses, so please scan all attachments. http://www.bgs.ac.uk ********************************************************************* _______________________________________________________________________ List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MapInfo-L" in the message body. _______________________________________________________________________ List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MapInfo-L" in the message body.
