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

the description of the problem was at the beginning of the msg. 1. the routine needs to open an access dB (master) from another access dB (installer) 2. the routine needs to connect the master dB to the corresponding client SQL dB using connection string from input parameters 3. close and save...

Function ChangeACCDBExternalConnection(strACCDBFileFullPath As String, strServerName As String, strDBName As String, Optional strUN As String, Optional strPW As String) As Boolean On Error GoTo Err_Change_ACCDB_External_Connection_String Dim db As DAO.Database Dim tdf As...

Function ChangeACCDBExternalConnection(strAdpFile As String, strServerName As String, strDBName As String, Optional strUN As String, Optional strPW As String) As Boolean Dim strConnect As String On Error GoTo EH: strConnect = strActConn = "DRIVER=SQL Server;SERVER=" & strServerName &...

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

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!

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

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.

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

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

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