Search results

  1. A

    calling a VBA procedure whose name is contained in a variable

    Regarding being scary is an individual thing. There are numerous situations where scripts are generated at run time and executed without the user knowing anyting about it. SQL Server also generates numerous scripts which are modifiable manually. Are we forgetting that computers today can write...
  2. A

    calling a VBA procedure whose name is contained in a variable

    Thanks All Application.Run seems to meet my current needs. The procedure or function mentioned by me is in a Module and not a stored procedure in SQL Server. However, I am struggling with another requirement where the user enters the VBA code in a text box on Access Form and this code is to...
  3. A

    calling a VBA procedure whose name is contained in a variable

    My Access adp application generates vba scripts (reading Excel worksheet and updating SQL server tables) and adds the generated scripts to a Module. The procedure names are stored in a table. I need to call these procedures on demand. :) I could easily do this in Visual Foxpro using foxpro's...
  4. A

    SQL Server Connection String - Access adp project

    Thanks SQL Hell. As pointed out by you, I have removed "Integrated Security=SSPI" from the connection string and it is now working. The database authentication is through SQL server and not through Windows. Ashok
  5. A

    SQL Server Connection String - Access adp project

    The following VBA code that connects to SQL Server in an Access adp project works without any problem on my computer but does not work on another user's computer. CurrentProject.CloseConnection ConStr = "Provider=sqloledb;Data Source=UK009125D\SQLExpress;Integrated Security=SSPI;Initial...
View older results
Back
Top Bottom