Recent content by georg7

Thank you @arnelgp ! Top work as always!!! Have a nice Weekend :)

Thank you @arnelgp it worked ! Do you know how I get a report that Displays the last query? The report don't Shows the single names like in the query..

Hi there, I've a db with table(Tabelle2 mitarbeiter) for all employees and a table(Tabelle1 tname) to save who worked together. Now I want to create a querry that shows only the last dataset. I tried it with Max(ID) and Last(ID). Hopefully someone can help. Best regards Georg

Wish you all the best and stay healthy/safe in those times!

Thank you @Gasman !!!!!!!! Can't thank you enough! You really saved me. Appreciate all your effort !

But how does it filter? I want to select the filter at frm_all :/

I don't get it to work…. Thank you for your effort!!!!!! I really appreciate it!!

I think I'm to dumb…. I can select sf_qry_all with the wizard just the source of all datasets of sf_qry_all (qry_all). Could you edit the db and Show me how it works?

So I'm add a button on form frm_all that opens a report ( "report1"). On Report1 should be a subform of sf_qry_all? I'm sorry that I don't understand everything because english is not my main language... Should it look like that? Private Sub openReport1_Click() If Me.Filter = "" Then...

Everytime I want to print the filtered datasets I'll get all datasets without a filter….

Code is also the same just without some names and logos from the Company. Okay, printing a report would be nice. How do I get a button that prints a rpeort with the filtered data of the form?

@Gasman There is no real difference they both work the same way. This one has just less data of users. @mike60smart It's not my database I've to use it :/ I just edit things that are needed.

Hi there, I want to print my form/table ("frm_all") with the filter I select but it won't work… may somebody have ideas? I tried it with Private Sub Befehl32_Click() DoCmd.OpenForm "Bericht1", acPreview, , Me.Filter End Sub Sometimes it prints with filter and sometimes not. On form "frm_all" I...

Thank you guys for your help! It worked! Appreciate your effort. Best regards georg

It Always says that there is no form with that Name, but ist the form Name XD