Search results

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!

It's made for a huge data collecting project. We collect survey responses from four different areas. (the questions are the same for all four areas) So my idea was to use the same form because the structure is the same all of the forms and the tables too.

Hy, I have a Main form with tabcontrol, + a "data form" and some tables. Is there any option to use the same "data form" on the tabs but with different tables? Thanks!

That You can see is the subform1's scroll bar. There are three vertical scroll bars- one for each subform but those aren't on the picture. (There are horizontal scroll bars too but those aren't on the picture)

I hope this will help: First I select a tab on layer1 then select a tab on layer2 then fill the form on layer 3. I deleted the 1x1 textbox from all layers so now everything is in default. When I click on a tab on any layer the focus goes to the subform on the next layer so I can't see the...

Hy, Currently I try to build a database with tons of forms. There are 3 level with subforms and the subforms contains tabs. My problem is setting the focus on the subforms to see the tabs on top . I've made the trick with the 0x0 size textbox and the tab order. It works fine with one subform...