Search results

Sure

Do you know how to connect it with a drop down bar? Where I can pick the NM Value that should be the criteria ?

It worked!!!! Thank you very much, @bob fitz . You just saved my day :D Appreciate it!

What does Subform1.form mean? Is it the Name of the form i want the filter button on?

The query is called Test1 and the Sub form is called Test1-Unterformular

Does it matter if the subform is a query?

@Gasman I hadn't the exact Code, but i'm 100% sure that i did it onclick! @bob fitz so it worked for you?

Yes

I wrote it in the VBA Code of button "Filter 1".

Private Sub Filter1() Me.Filter = "NM = 'ZN'" Me.FilterOn = True End Sub I've to admit that i'm not very confident with vba in Access.

Good morning guys, I would like to have the form filtered using a button. For example, if I press filter 1, NM should be filtered to ZN.(Form.png) I've read many threads but couldn't get it to work... May some of you guys can help me. Appreciate it! Best regards Georg

Thank you CJ! I'm really sorry for the misunderstanding. I appreciate your help. I think my Access skills are not good enough to create something like that because I'm a newbie.

Thank you guys for your help but I don't mean the tipical filter. In Germany this(Picture) is also called a Filter but i think ist more like a select.I can pick the data that I want and the rest will be hidden. I think that there is no way to get it to my report?

I tried the DoCmd.OpenReport method but I won't work.(you can see it on Code.png) It always prints the full form data not the datas that I've filtered.

Good morning guys, I've my form where I get my data from my query. on the form I set a filter to select my wanted data(red circle). Is it possible to get the filter to my report that I can print it ? Printing forms is just annoying and it Looks Pretty ugly. Or are there other ways to get the...

Appreciate your help. The transferspreadsheet method worked pretty good. Have a nice Weekend guys (Y)

Good morning guys, I want to Import datasets from Excel into my Access database. The Image Shows how my Excel Sheet Looks like. Every month I want to Import the amounts per car-type in my Access table. The Excel sheet never changes. Is it possible to write a macro or something like that to...

That would work, but I don't know how to import a single Dataset. When I import it's Always the complete table.

Just to try it. There are plenty more cells to import. :(

Good morning guys, I want to Import single cells from my Excel doc to my Access db. Every week I get a excel doc with numbers that I've to add in the Access database. That I can Import every week the datasets. I've to Import cell(8,1) from worksheet Table_iut at the end of my Access table...