Search results

  1. S

    Unlocking Subform

    I would like to unlock my subform via my VBA code but I am getting an error message: Application Defined or Object Defined Error. My code: Forms!frmMain.Form.sbfrmCVOption3.Form.Locked = False I would appreciate any suggestions on how to unlock my subform. Thank you.
  2. S

    Data Type Mismatch in Crit Expression

    I have a field in my query titled "Exposure" with a criteria of "HFA". No problem running the query. However, I needed to get more out of my output and changed "Exposure" to "Exposure: DLookUp("exposure","tblReviewDetail","[tblReviewDetail].[ReviewName]='" & Replace(tblCusip!ReviewName," ' ","...
  3. S

    Sql (in VBA) syntax

    I am scratching my head on this syntax. I am declaring strType to be one of three options. Then the variable strType will factor into the embedded query: strSQL. I would appreciate any assistance in this syntax issue. TY. Dim strType As String If strType = "Single Family" Then strType...
  4. S

    Series Collection Chart Problem

    I am attempting to setup a chart that allows the user some ability to customize their view. The problem is that I am not to familiar with the SeriesCollection command and I suspect that I am not using it correctly. To set the stage: upon startup, the chart (located at...
Back
Top Bottom