Search results

The function below is written using VBA The purpose of the function is to open an external database see the line Set dB = OpenDatabase Then it changes its connection string for the tables and queries in that database the connection string is dsn-less string; see the line strNewConnectString =...

This is my code to open an external database. I open the external file fine. I just need to update the connection string for all objects in the external file? this code is inherited from ADP projects and it was pretty simple. You can replace strAdpFile with strACCDBFile. thanks! Function...

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...

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

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...

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"...

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...