Search results

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!

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...

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, 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!

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!

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...