Thanks Tracy You put me on the right track.
I made the changes and the right click worked fine. The only problem was that the grid was blank. TempPhoneNo cursor was created in the Load of the form with different field name that the tempPhoneNoCursor.dbf which was created by the Select. Only PhoneNo was the same. Changed the field names to EXP_1 etc. and Grid now shows the correct data. I have now got it going to our main Phone Companies Directory Enquiries site and finding the Phone No then adding it to the relative tables. The Client is eating out of my hand at the moment. I could put all of you who have helped, in the Credits on the Help About page, but they would have shut the form down by the time it got to the tenth name. I think hundreds of names would be wasted. /grin Cheers Peter -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Tracy Pearson Sent: 08 September 2010 22:31 To: [email protected] Subject: RE: Right click memus in grids Peter Hart wrote on 2010-09-08: > I run the macro which then > produces a cursor with the fields EXP_1 etc > > The grid is bound to the cursor so I have to reset the Headers and the > column widths etc. > > The grid then show the Details who are either Members, Committee > Members, N.E.C. Members or Private telephone No's > > There are no other Right Click events coded. > Peter, Any code you had in the column, or controls in those columns is gone. This happened because the grid is rebuilt by the default behavior of VFP. Either set the Grid.AllowCellSelection to .F. and call the menu from the grid.rightclick. OR Fix the macro with this: lcFilterText = lcFilterText + " = lcCaption Into Cursor TempPhoneNoCursor Readwrite " &lcFilterText. Select TempPhoneNo Append from DBF("TempPhoneNoCursor") Use in select("TempPhoneNoCursor") Tracy Pearson PowerChurch Software [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/a57fa4cf19531343a2ee11b57db8e3af100...@server.peterhartcomputers.local ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
