Recent content by urobee

Thanks for the help, You are the best Guys! The final code: Dim app As Access.Application Set app = GetObject("C:\AccessDB\Database2.accdb").Application app.Run "Hello"

Update: I think half of the problem is solved. At this time there is no another instance of Access when I click the button. But this error still not solved: 2485- Cannot find the object 'Hello.' (It would be just a test with a simple msgbox message to check the macro is works fine.) There is...

Unfortunatelly I don't have permission to share parts of the code. The macro name is good. I've tried with a simple msgbox "hello" macro too from a different modul, doesn't work either, I got the error 2485- Cannot find the object 'HelloTest.'

@arnelgp Thanks but it works like my other code. It's open again the Database2 then i got an error: 2485- Cannot find the object 'SecondMacro.' Shouldn't I need to refer somewhere in the code to the form where is the actual "SecondMacro" ? I'm confused :confused:

Hy, I have a database (Database2) which is referenced to an other database (Database1) so I can run macros from Database2 in Database1 just like this: Database1.TestMacro (I use it to open a form and run queries.) So my problem is: I need to run a macro in Database2 but the button which is...

Hy, I have a code that i wanted to use in a query instead of VBA. Please help me to convert it because i always got syntax errors. DLookup("[Name]", "[t_mst_Cells]", "ID = " & DLookup("[CellsID]", "[t_log_MeasLog]", "[ID]=" & TempVars("ID_Meas"))) Thank You Guys!

Thank You arnelgp it works fine!

Hy, I have a table with some columns. I would like to show the name of Category on a label as caption. My actual code is showing the ID of the Category instead of the name of the Category. Me.lbl_Cat.Caption = DLookup("[Category]", "[tbl_TestTable]", "[ID]=20016") Can You help me in this...

You are awesome, thank You!

Hy! I have a table (tbl_temp) with some columns and a query (qry_temp). The query (qry_temp) get data from the table (tbl_temp) based on some criteria. I would like to delete the records of qry_temp from tbl_temp. I've tried to make an SQL but it's delete all of the records from tbl_temp not...

Hy, today I've tried to use your code but i got this error message: "Method or data member not found" and this part is selected: Me.RecodsetClone Access 2010 and here are the activated references:

wow, great! Thank You!

I need the "Temp" table to collect data until it reach 30 records then I make a report and clear the table and start it again. In the "Master" table I collect all the data without clear any records. --------- EDIT: I made an event on close form with macro builder so i was able to add the query...

Hy, I have two table: "Master" and "Temp" The form save the records in to "Temp" table. I made the append Query it works fine when I run it manually. Is there any option to run the append query automatically after form update/or before close to save the records to the "Master" table too? Thanks!

@MajP @Mark_ @theDBguy Thank You Guys!