Search results

Thank you, I have modified the code, added a report and it now works. I enclose the db with the code in case anyone needs it. Thanks again

I thank you, but the problem remains: the items are filtered correctly, in the sense that if I select the checkbox in the mask, the items with the selected checkbox appear in the report that opens, and vice versa, but the same report always opens. To explain further, the correct result should...

Thank you. Now the code works, in the sense that the report is filtered by both the two combination boxes and the checkbox, but the same report always opens as a file, even though the data of the two are different in the sense that they correspond to the two reports. Where am I going wrong?

Good evening everyone, as you see corresponding thread in Forms and Vba, your help has enabled me to filter a subform with 2 combined drop-down boxes and a checkbox and subsequently open a report. Now I would like to add a feature: if the checkbox is selected, clicking the button opens Report 1...

Everything perfect, THANK YOU!

It works perfectly! Thank you very much. I'll try to ask you for some more help if you can: after applying the filters I would like to open a report, I have created a button on which, on the click event, I enter the same code, but I get an error, maybe this is not the procedure? Thanks again

@arnelgp: First of all, thank you for your availability. It seems to me, however, that it still doesn't work: try selecting the record ‘A.D.3_...Dischi da Competizione’ from the cboSceltaSottoCategorie, in the cboSceltaTipo you have ‘Dischi da gara’ and ‘Dischi da gara 2’, if I select ‘Dischi da...

Ho ristretto di nuovo il db, lo allego

In the first attempt to send it I forgot to compact the db, I attach the screenshot of the new link from which to download the db. Thank you

I have eliminated as much useless data as possible for the purposes of this filtering research that I am doing, I hope it is sufficient. Thanks for your time. I inserted the file on WeTransfer but after inserting the link here on the forum I cannot send, I do not remember how I did it last year...

Even if I add square brackets to the subform name, when I select an item from the first combo box the subform becomes completely empty.

@cheekybuddha I checked the name of the subform control and it is Prodotti_Attrezzature_Atletica; after changing the code like this: Private Sub FiltraSottomaschera() Dim strfiltro As String strfiltro = "" ' Filtro per SottoCategorie If Not IsNull(Me.cboSceltaSottoCategorie)...

@arnelgp: maybe I don't understand the question, but the filter on cboSceltaTipo is not this: ' Filter for Product Type If Not IsNull(Me.cboSceltaTipo) Then strfiltro = strfiltro & "IDTipoProdotto = " & Me.cboSceltaTipo & " AND " End If

@cheekybuddha I changed the filter name as you indicated, but the result does not change; @CJ_London: I inserted in the sub FilterSubform Debug.Print strfiltro and in the immediate window this appeared: IDSottoCategorie = 348 AND IDSottoCategorie = 348 AND IDTipoProdotto = 113 AND...

Good morning everyone, I would like to filter a form with a datasheet subform with two cascading combo boxes and a checkbox. The form is called "SottoCategorie_Attrezzature_Atetica", the subform smProdotti_Attrezzature_Atetica; in the header of the form I inserted the two combo boxes and the...

Good morning everyone, I need some help to be able to create reports containing images. I have a form containing a subform; on the form there are two combo boxes that filter the data from the query on which the subform is based. Also on the form I have a button that creates the report and so far...

@MajP @Mark_ I have carefully studied the screenshots posted by MajP with the changes to the tables and it seems so complicated that I think I would almost be quicker to build the whole db from scratch. The question you ask, Mark, makes a lot of sense, if I think about MajP's warning about the...

Good morning everyone, I apologise for my silence, I was away for a few days and could not deal with the problem for which I asked for your help. I will now take up your comments

Soprattutto, ho il terrore di modificare una struttura che sembra funzionare perché ho paura di non sapere come gestire le conseguenze di questi cambiamenti. Utilizzo solo questo database, con esso gestisco i prodotti, il catalogo (infatti la richiesta della visualizzazione dell'immagine con cui...

Thanks MajP for helping me try to trace the error back to Access abc. Looking at your screenshots I wondered why you leave the tbProductsSubCategories table ‘isolated’, when I created it (with the intention of creating a join table) it had seemed the most correct choice to hold together the...