Search results

  1. A

    Solved replace one line of code with two using the find and replace tool in ms-access 2010/2021

    I have this line of code in vba currently: Set conn = CurrentProject.Connection I would like to do a global replacement in current project with conn.ConnectionString =extractConnectionStringADOfromOLE conn.OPEN how can i do that using ms-access find and replace tool? I need to...
  2. A

    Access Pivot Additional Columns

    Hi This is Access 2010 and I would like to turn off the underline additional fields added by the pivot form FOR fields of DATE data type
  3. A

    Continuous Form Stored Proc Combo Box

    Hello, I have an Access ADP form. The form is bound to a table1. The fields are displaying fine inside the fields and the combo box. behind the combo box is stored procedure A and the combo box is bound to Field1 . For display purposes it is working fine. For data entry purposes, it's not...
  4. A

    Question visible home tab in a custom ribbon

    Hi, I am using 3 cutom ribbons in an ADP application. I am loading them using: Application.LoadCustomUI rs("RibbonName").VALUE, rs("RibbonXml").VALUE The ribbons are loading fine. On the initial ribbon I am hidding the home tab using the command: <tab idMso="TabHomeAccess" visible="false"...
  5. A

    Refreshing ADP connection

    Hi, I have many buttons in Access ADP that trigger feeding a table with different data. Let's call the table tempTable1. I have 600 buttons that feed the make table with all kinds of data: SELECT * INTO tempTable1 From AnyDataSourceSPViewTable SELECT FIELD1, FIELD7 into temptable1 from...
Top Bottom