Search results
14 mar 2016 · The AutoExec macro is a macro named AutoExec which runs when you start your Access app. You can use the RunCode macro function to call your VBA function (it does have to be a function and not a sub). This way you can (re)link your table before the form is even opened. answered May 6, 2014 at 15:43. Brad.
17 cze 2021 · The problem is with the "Open" command". I get a runtime error 80040e4d Error on login for the user 'XXXX'. I looked at a stack link with similar issue which unfortunately didn't help either: VBA Runtime Error when connection to SQL Database.
19 sie 2021 · I have always been successful in connecting my VBA solutions in MS Access as a client to my company’s SQL Server, but I struggled for a long time to figure out how to connect to a SQL Server Express LocalDB instance on my personal computer until now.
20 sty 2022 · I am using VBA to try and connect to SQL server. Here is the code: Sub GetDataFromADO () 'Declare variables' Set mConn = New ADODB.Connection. Set mRS = New ADODB.Recordset. Dim strSQL As String. 'Open Connection'
12 maj 2019 · First you need to declare three variables: Dim c As ADODB.ConnectionDim rs As ADODB.RecordsetDim connectionstring As String. First variable is needed to create a database connection, second is used for creating a recorset and the third is used for a connection string.
This is a VBA macro in Microsoft Excel that uses the ADODB library to connect to a SQL Server database and insert data from a range of cells in the worksheet into a table named “Product” in the database.
17 lut 2012 · For your setup, it sounds like all you need to use is the server name. On the other hand, if you have a named instance (for example, multiple instances of SQL Server on one PC), the FOLDER might be an instance name such as COMP1\SERVER2.