Search results

  1. A

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

    so how you replace one line of code with two lines using mz-tools. I have just downloaded it. it can find multiline. It cannot replace multiple lines. thanks!
  2. 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...
  3. A

    Access Pivot Additional Columns

    those columns are added by the pivot table as an additional grouping for all date fields. they are not part of the underlying query or table. I need to a method or an an option to turn them off.
  4. 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
  5. A

    Continuous Form Stored Proc Combo Box

    Thanks here is what I did .. Placed a bound combobox on the form with all of the choices available. This would be my display combo. Then placee another BOUND combo box for the field I wanted edited. This is the combo with all choices for the employee only (filtered) I made sure the edit combo...
  6. 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...
  7. 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"...
  8. 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