Search results

  1. R

    Solved Type Mismatch in Expression / Invalid Procedure Call

    Greetings, This one has me stumped! I have a database with a memo/long text field and in this field there are a bunch of time stamps and some text (for example, "2022-04-15 0945 In Production"). I have successfully extracted the time stamp in a query (using "Mid([Status],InStr([Status],"In...
  2. R

    VBA Where condition when the field itself is a variable

    This one always gets me in a bind & I can't seem to find the answer anywhere... I would like to open a report where the field in the record source is a variable. The following works fine where the field is boolean: DoCmd.OpenReport "rptReport", acViewPreview, , "[StringFieldName] = -1" I...
  3. R

    Solved Build a Filtstr from ListView Multiselection

    I have a form that has both an Access Listview and Treeview & have successfully coded it so that I can drag & drop a single item from the listview onto a treeview node. However, I am struggling with dropping multiple items from the listview onto the treeview node. In dissecting the VBA in the...
  4. R

    Referencing a Control 2 Levels Deep in Navigation Forms

    I am struggling to refer to a control that is buried within 2 navigation forms. I have searched everywhere and tried different solutions but to no avail. This is the structure: Top Form = "Main" Navigation Subform = "NavSubForm" 2nd Navigation Subform = "TabSubForm" Form holding the control =...
  5. R

    Listview with Currency Column

    After hours of searching on my own for a solution, I have given up & hope that someone can help. I'm just an average VBA person and new to generating the ActiveX Listview and Treeview, but have so far managed to create a form with a Treeview list and an Listview where I can drag items from the...
Top Bottom