New call-to-action
Results 1 to 6 of 6

Thread: Open window/form of existing field in browse

  1. #1
    Member
    Real Name
    Jack DeBoer
    Join Date
    Oct 2006
    Location
    Houston, TX
    Posts
    457

    Default Open window/form of existing field in browse

    Wish I had a good description of what I am wanting to do so I could do a search on how to do the following.

    I have a browse of child records with a number of fields. I have one field in the browse that is aprox. 200 character long. When I have a line selected I want to open a window (form or dialog) of just that one field. What I am wanting to do is like a memo field in a browse. You can click on an icon and the memo opens up in it's own window.

    Thanks in advance

  2. #2
    "Certified" Alphaholic Stan Mathews's Avatar
    Real Name
    Stan Mathews
    Join Date
    Apr 2000
    Location
    Bowling Green, KY
    Posts
    25,119

    Default Re: Open window/form of existing field in browse

    Quote Originally Posted by turbojack View Post
    When I have a line selected I want to open a window (form or dialog) of just that one field.
    Ain't gonna happen. You have to code some event to open something to display the field contents in another browse (of the one field), xdialog, or whatever. There is no "row selected" event. You will have to use an existing event.

    Events for Browse Objects

    The browse object triggers the following events:

    Note : Placing a browse on a form creates the browse object. There are no events for stand alone browse windows, only browse objects on forms.

    Event Name
    Occurs When

    OnExit
    When the browse object is exited. This will occur after the form that encloses the browse object is closed.

    OnInit
    When the browse object is created. This will occur after the form that encloses the browse object is instantiated.

    OnFetch
    When the browse is re-synchronized (i.e. when Alpha Five fetches a record). Whenever the user navigates to a new row in the browse, this event and the OnRowChange event will fire. However, the OnFetch event will also fire if the browse is re-synchronized without navigating to a new row.

    CanRowChange
    Just before you navigate to a new row.

    OnRowChange
    When you navigate to a new row in the browse.

    OnRowDblClick
    When you double click on a row selector. If the browse object is read only, then this event will fire if you double click within the row.

    CanArrive
    Before the browse object on the form gets focus.

    CanDepart
    Before the browse object on the form can loose focus.

    OnArrive
    After the browse object on the form has got focus.

    OnDepart
    After the browse object on the form has lost focus.
    Onrowchange or onfetch seem the most likely candidates unless you want to educate the users to understand they should double click to see the field contents and code the onrowdblclick.
    Last edited by Stan Mathews; 10-17-2007 at 03:40 PM.

  3. #3
    Member
    Real Name
    Jack DeBoer
    Join Date
    Oct 2006
    Location
    Houston, TX
    Posts
    457

    Default Re: Open window/form of existing field in browse

    I guess I did not explain good enough. Here is a database showing what I am wanting to do. Open form one. When you go to records in the browse you can not read everthing that is under description. I want to push the button to open up window showing what is in the field. As you can see when you press the button a form comes up with the first record but when you highlight the second row and press the button the first row still shows. As I was typing this I think what I am wanting to do is do a filter to get the record number that equals the record the browse has higlighted.

    If you go to the memo field and click on the field the memo window opens. I am just wanting some similar to that for character field.

  4. #4
    Member
    Real Name
    Jack DeBoer
    Join Date
    Oct 2006
    Location
    Houston, TX
    Posts
    457

    Default Re: Open window/form of existing field in browse

    Here is my crude working copy. I guess when you get stumped when you start to write about it you then look at in in a different way.

  5. #5
    "Certified" Alphaholic Tim Kiebert's Avatar
    Real Name
    Tim Kiebert
    Join Date
    Jul 2004
    Location
    Geelong, Victoria, Australia
    Posts
    2,785

    Default Re: Open window/form of existing field in browse

    Jack,

    How about some thing like this, using a button right in the browse row.

    Go to form1x. Then desc column properties->'Other' tab -> then 'Edit Display Format'

    The code for the button is found by going to the events for the browse. It is in the event called events. I put in three different options to try by commenting or uncommenting the lines of code.
    Last edited by Tim Kiebert; 10-18-2007 at 12:48 AM. Reason: Correction to sample and pic
    Tim Kiebert
    Eagle Creek Citrus
    A complex system that does not work is invariably found to have evolved from a simpler system that worked just fine.

  6. #6
    Member
    Real Name
    Jack DeBoer
    Join Date
    Oct 2006
    Location
    Houston, TX
    Posts
    457

    Default Re: Open window/form of existing field in browse

    I like your example alot better then what I had. Your code is less bulky that what I had. Thanks

Similar Threads

  1. Browse view while form still open, Possible?
    By Beltronics in forum Alpha Five Version 8
    Replies: 1
    Last Post: 08-14-2007, 01:37 PM
  2. New or existing Internet Explorer window
    By Bill Parker in forum Code Archive
    Replies: 2
    Last Post: 03-22-2006, 01:01 PM
  3. Open a form in Browse
    By Stewart Spiers in forum Alpha Five Version 5
    Replies: 4
    Last Post: 02-03-2005, 04:22 PM
  4. Open browse on form
    By Raheel Ahmed in forum Alpha Five Version 5
    Replies: 1
    Last Post: 07-26-2004, 08:57 AM
  5. Open record from browse INTO a Form ..
    By Rich Williams in forum Alpha Five Version 4
    Replies: 6
    Last Post: 05-17-2000, 05:38 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •