yeah sorry, probably didn't explain quite well enough, i can't have multiple selections and queries doing stuff.
scenario: defining a bus route. user chooses a route all bus stops are displayed in mapinfo access asks for first stop user finds stop in mapinfo and clicks access updates data in table/form based on user-click access asks for next stop repeat until dead. so essentially i want a tool which sends the currently selected object's data to an access table. thanks ash -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 30 July 2002 9:37 PM To: Simmonds, Ashley (PTB) Subject: Re: MI-L Access Callback I see several ways of solving your problem with no additional programming. Of course I may not fully understand your question. Therefore I have a few questions / observations and then a solution / course of action. Can you select your subset of features using a query? If so you can then browse the selection. From there you can either save a copy of the "Selection" table as an Access Database. You could also, with the browser window open and active, select "Edit" then "Copy." Then open Microsoft Excel and paste the contents of the clipboard into the first cell. Your selection set will magically appear. You can then easily import this table into Access. If you can not select all of your records using a query, you can still add to the selection set by holding down the shift key while panning around selecting features. The problem here being that at any moment you could loose your selection and have to start over. Anyway, once you have your records selected exporting them is easy. Patrick J. Phillips GIS Developer, City of Orlando, FL -----Original Message----- From: Simmonds, Ashley (PTB) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 30 July 2002 5:52 PM To: 'Mapinfo List (E-mail)' Subject: MI-L Access Callback hiya, i'm sure this has been covered before, but probly not to my precise requirement. i would like to know if there is a (relatively easy) way to set up mapinfo to pass the data of something which has been clicked on in the map window to MS Access. this is more than likely not going to be an ongoing application, just something which i would like to do right now for the sake of avoiding the need to switch apps, click a spot, select the data, copy the data, switch to access, select the destination, then paste the data, repeat until dead. i have around 7000 points (hopefully a max of 1000 or so which require this) and once it's done it's done. if this can be implemented solely through VB/Access then that would be good as i don't have mapbasic. i can do some integrated mapping if that's required, it's just i don't want to spend too long designing the interface and stuff seeing it's a once off thing. i figure if it can't be done directly with the mapinfo window, then a custom tool would be necessary, and if that's the case then would it be possible to see an example so i can hit the ground running. this is my theory... run mapinfo as window in access load workspace make relevant table selectable pan zoom doo daa if custom tool.click then collect data from selected object send data to recordset.id do other stuff end if i have enough ability to run mapinfo within access and can figure out the loading of tables and stuff, but i don't have much experience with tools, all i've needed to do so far is pan and zoom, so i would basically just need an outline of how to define and use a custom tool. gramercy ash
--------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 2273
