Quote:


You put the code that you want executed when the button is pressed in the on element entry area for  the command button.

See top of page 66 in user manual.

Hope this helps  

Can you explain what you mean by load a macro under program control?

Quote:


Jerry,

I am pretty sure nothing will work in search mode. You will have to be in a record. The Lanticans will correct me if I am wrong.

If I understand correctly what you would like to have is a screen with command buttons that act as your menu. I have not yet tried this but I am sure there are pobably numerous methods to accomplish this. The one that pops into my mind first (this does not mean its correct  ) would be to create a form with one element and all of your command buttons. Put a unique word in that element in 1 record (this will always be your starting point)You could use the start up switch that runs a macro that searches for the 1 unique word in the element. The element can be hidden somewhere on your form. With this setup when someone logs in it would bring up the record so you will not be in search mode and then you can control things with Sbasic from command buttons.

This is just a quick thought hopefully to help get you started.

There are many others out here on the forum that will probably have additional thoughts. In the mean time use the forum search button to search on the word macro. There are many previous posts that discuss these issues.

Thanks for the ideas.  I am making progress.   I open the menu form in Add Data mode.  I can place commands such as CloseCommandArea(1) behind the button and it works.  I have tried every level of @SelectTreeItem and cannot get it to work from a command button. The complete path is
C:\Sesame\data\tracker\tracker!Forms!Add Data!TrackerMain!MainMenu 
Has anyone gotten @SelectTreeItem to work from a command button.  If so, please tell me where to start in the above path.

This is on a sub menu to return to the main menu.

I have also tried a macro.  I have gotten to the point where when I click the button, the macro loads, but does not run.  After it loads, I can click Macro and Playback and it does what I need. 

Any suggestions would be greatly appreciated.

Jerry

Jerry prehaps you misunderstood what I said in the e-mail

@SelectTreeItem() requires the entire path to the button

so in Customers.db to open Search update Countries the code would be
-
success = @SelectTreeItem("COUNTRIES and Cities!Forms!Search/Update!Countries!Countries")
-

and to open Search Update Cities the code would be
-
success = @SelectTreeItem("COUNTRIES and Cities!Forms!Search/Update!Countries!Cities!Cities")
-

I apoligize for the misunderstanding. When I said Application Name I meant Application Title which is displayed as the first folder in the Application menu in Sesame.

Thanks for the clarification.  It will be tonight before I will be able to try it.  I have three sites that are wanting their applicatons migrated from Q&A and they all use extensive menus that were developed in Q&A macros and they want the same type interface.

Any clues on the @macro problem I am having where it will load the macro, but not run it?  If I hit F2 it runs and does what I expect.  Some of those menu entries will need to use macros to accomplish what they are expecting.

Thanks so much for your help.

Jerry

I did put the complete path.  If I leave .mac off, it says that it cannot open the macro.  When I specify the complete path, the macro name appears in the field above indicating that it has loaded, but it does not run.  If I click Menu; Playback it runs and does what I expected.  I can also press F2 and in it will work at least the first time.  It always works by selecting Menu;playback, but does not execute when the Command Button is selected.

Jerry

This is a two level menu system.  The lower level menu is in control in Add Data mode.  When I click the menu button, nothing changes except that the button changes colors for a fraction of a second and the Macro name appears in the box above indicating that was loaded.  When I click Menu and then Playback, the current form closes and the main menu is reloaded.

The macro consisted of : "Close Add Data; Select main menu form; enter"

These forms are all in the same database if that makes a difference.

Jerry