Search results

Thank you Pat Hartman, the code I want to execute contains some more stuff not only changing links. I've checked the databases provided by thedbGuy, thanks for this. But the code is stored under the new opened database db1. I have the code in the original database and want to execute this...

Thank you so far. Let me describe my issue. I got a database with a procedure I want to run in another database. It still doesn't work. I don't know the issue. I'm using Access 2013,maybe that's the issue??? Can I open a table in the new opened database, as a simple test? Thank you.

Hello Gasman, unfortunately I get the same error message: Run-Time error 2517 Procedure Test couldn't be found by Microsoft Access. I'm getting desparate, shouldn't be so difficult to open another database and run a program :(

I get the error message: Run-Time error 2517 Procedure Test couldn't be found by Microsoft Access. I have a Sub routine called Public Sub Test().

Hi Lightwave, my playground is a little restricted here. Any idea how to start a module in another Access database? Thanks. Rgds, Ben

Hi All, I just learned that it's not allowed to use vb scripts and batch files in our company. How can I open another database and run the original module code there? I tried this,without success: https://bytes.com/topic/access/answers/900155-how-run-procedure-database-code-another-db...

Hi, thanks for the suggestion. Unfortunately there are 100s of databases. Somehow I would like to open them up subsequently and run the same code. I tried to start at first one database running a bat file with: Start "folder/XX.mdb" Didn't work out. TA-1012 cihazımdan Tapatalk kullanılarak...

Hi guys, can someone help me out? Following issue: Wanna open all Access databases under one specific folder and run the same VBA code. The code is ready, the only thing for me is to find out how to start Access from a bat file and run the same code for all databases. The background is that...

Hi guys, thank you for your help. I used following now it works: Sub IterateAllModules() Dim vnt As Variant Dim x As Integer Dim s As String Dim mdl As Module With CurrentProject For Each vnt In .AllModules s = vnt.Name Set mdl =...

Hello arnelgp, unfortunately this doesn't work. I only need to replace a certain portion of a line not the complete one. And I need to go through all modules. Thanks. Rgds Ben

Hi, you're right, just corrected. I was searching for String X. Rgds, Ben

Hi all, I got following issue: Want to replace a string in my VBA code. Tried this one, however it doesn't replace the string: Public Sub ttt() Dim vbComp As VBComponent Dim mdl As CodeModule Dim i As Integer Dim lin As Variant For Each vbComp In...

Hello, I try to execute following subquery: DoCmd.RunSQL "SELECT DISTINCT Q_PRICES.Material, Q_PRICES.Product_Class INTO TEST " & _ "FROM Q_PRICES " & _ "WHERE " & _ "(SELECT Q_PRICES.Material " & _ "FROM Q_PRICES " & _ "WHERE...

Allright I will try to create a new database. Thank you all.

Yes this Form is selected and still exists. A closing macro doesn't exist.

Dear all, I got a curious issue here: Set up a pop up form under Options\Current Database\Display Form TEST For some days it doesn't show anymore this TEST form when I open the database. Is there anything I have to change? Do I have to delete this TEST form and create a new one? Thanks...

Thanks spikepl, I found the solution, it was based on the DSUM. Now I sum up over the right values and get the expected result. Thanks.

With Debug.Print b I get the right number 0.23. I tried also to use " & b & ",but that doesn't work out...

Hi all, I got the following problem. This code doesn't calculate the exact value: Sub TEST() Dim strSQL As String Dim b As Double DoCmd.SetWarnings False b = DLookup("MC", "COMMON_DISTRIBUTION", "YEAR = 2015") strSQL = "Update TNS_HIST Set [TNS_in_TRY] = " & _ "...

Hi all, is there a way to create some sort of an EXE or BATCH file in any Windows Explorer folder, that executes me a specific Excel Macro? My problem is that I got several files split up by Departments, updated every day. So far I have to open each file and update the format. It would make...