Search results

I don´t want to remove the filter, I want: 1) form on load: show me all records, but the "taxes"; 2) when I enter something in the search bar: only show me the entered value (if exists, otherwise, no results); 3) when I click over the "clean" button: show me all records but the "taxes", as in...

Hi everybody, hope you are doing fine. I have a continuous form based on table "INCOMES" that shows all the payments received, which mediums can be (field "PMNT_MEDIUM"): - check - transfer - taxes - cash Table "INCOMES" is filled using another form, but in this particular form I just want to...

Paul, you pointed me the answer: it happened that the second form (GASTOS_EDITAR), in the ID field, I had changed its name to "editar_id"; but the control origin pointed to the real name in the table: "ID_GASTO". So I changed it back to "ID_GASTO" and it worked... thanks so much for the...

I am sure I did, just in case: continuous form: "04 - GASTOS_BUSQUEDA" con form id: "Gastid" button that triggers the other form open: "btn_editgs" new form: "GASTOS_EDITAR" new form id field: "editar_id" so the code should be fine as is: DoCmd.OpenForm "GASTOS_EDITAR", , , "editar_id = " &...

Thank you for your response, but I am afraid still does not work. I set it up like this: DoCmd.OpenForm "GASTOS_EDITAR", , , "editar_id = " & Me.Gastid it asks me to enter parameter value for field "editar_id", and no matter if I enter the number manually, it opens the form but all blank, no...

That worked! thanks so much for the prompt response, Paul :)

Hi everyone this is Rod, I have a continuous form in which I put a command button for each record called "detail". I would like to click on the "detail" button and make it open another form containing all (and only) the info on this record. At first I refused to use an "id" to link both forms...

Hi everyone this is Rod, I am using MS Access 2007. I would like to display a report based on the table called "expenses", filtered by: - "from" (datefrom field) and "to" (dateto field) date on "payment date" field; - multiple criteria on same field called "payment method" (I would like to...

Hi everyone this is Rod. Hope I can contribute to the inquiries people post in this forum; hope you can help me too. Pleased to meet you all.