Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2002
    Location
    Mpls/St.Paul area
    Posts
    303

    Unanswered: Get the field description.

    This stems from DAO to ADO conversion.

    Goal: get the field description from the field which is the control source for a control on the form.


    On my forms, I capture keystrokes, and I have on OnExit and onEnter function for each control. These functions will let me know what control is current. This is used when the user presses a command button that effects the current control (in reality, the control that used to have the focus a second ago).

    gctlPrevious.SetFocus............................. .....'Set focus to previous control
    Set ctl = Screen.ActiveControl.......................'The active control is set
    Set dbsCurrent = CurrentDb()........................'Old DAO method
    Set rstCRF = frmCRF.RecordsetClone...............'recordset is created giving me the table
    Set fld = rstCRF.Fields(ctl.ControlSource).....;...'fld is set.
    myFieldDescription = fld.Properties("Description").....'I get my table description for the field.

    How do I do this in ADO? I can figure out the control, the controlsource, and the table, but what syntax do I use to refer to the description of the field?
    John
    This is the day the Lord has made, I will rejoice and be glad in it.

  2. #2
    Join Date
    Jun 2002
    Location
    Mpls/St.Paul area
    Posts
    303
    Anyone?
    John
    This is the day the Lord has made, I will rejoice and be glad in it.

Posting Permissions

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