Search results

Thank you guys I'll try it all :D Have a nice Weekend !

Hi there, I want to add Usergroups like admin and viewer to my db. Admin can everything and Viewer can only view not edit. Is it possible to sperate them by Microsoft User? When an admin opens the db he can see everything. Viewer only sees the opened form (menu). the Navigation is not visible...

@bob fitz do you know how to solve it?

It's the same db form frm_all. We/You added the filter for Kategorie,gruppe,Schulung and Schulungsname. Now I want to Combine them. Like first select just a gruppe and that add the other filter like Schulungen so i only get the results for the gruppe and Schulung. Problem is that I can't use...

I'm really soryy but it's me again :D Is it possible to combine multiple filter?

So I wanted to make some screenshots for you and now it works… I don't get it haven't edit anything....

Sorry macro was the wrong word. When I start my db and press one of those Buttons it triggers the error. Which line causes the error is not shown.

Hi guys, everytime I start my db and want to start a macro this error pops up: "You have selected the expression ~ on click ~ as the setting for the event property. This printed caused an error. Object or class do not support this set of Events". My solution at the Moment is to switch to the...

Thank you, it work's perfect! Do you know why I can't select/click the checkboxes in the listbox? EDIT: nevermind I got it :)

hey guys, I want to filter my listbox via a Combo box.I tried it with Private Sub Kombinationsfeld85_Click() Me!Liste83.RowSource = "SELECT Abfrage1.ID, Abfrage1.Nachname, Abfrage1.Vorname, Abfrage1.GrpName FROM Abfrage1 ORDER BY Abfrage1.Nachname WHERE Abfrage1.GrpName = '" &...

Thank you @arnelgp ! I found my mistake. The source of my "nächster Termin" in my subform was wrong…. Have a nice week guys. No more Questions from me Best regards georg

And Maybe one of you guys know why qry_all.NächsterTermin is #Name? after I use a filter

I'm sorry but both don't work. Maybe it's easier when you see it :D It's frm_all again

Okay, I got a new Question :D Private Sub Kontrollkästchen21_AfterUpdate() Me!sf_qry_all.Form.Filter = "Nächster Termin = '" <= Date +30 "" Me!sf_qry_all.Form.FilterOn = True Me.Kombinationsfeld6 = Null End Sub I want to filter my Nächster Termin(Next Date). I only want the Dates that...

Everybody knows that germans are rough :D

Thank you very much bob! Everything work's perfect! So my main difference was the column Code part? Yeah, I should work on my names for tables,queries and forms 😂 You're Right my main language is german. I appreciate that compliment. So the english class was worth it. 😂 Sometimes it's hard to...

Thank you! frm_all and frm_qry_all are the main parts. The filter on frm_all "Kategorie" works but the others don't. Just can't figure out why...

Just for my understanding: -sfTabelle1 is the subform? - I tried it on my main DB changed the sfTabelle1 to my subform changed the cmbTabelle1 to my method Name changed the Column name but it don't work :/ Is there a difference when there are relationships between tables?

Sorry,I've been ill the last days. That's excactly what I was looking for! Thank you very much Bob!!! You helped me a lot. Best regards Georg

It's just an example database to try some things. Will there be a difference if they've a relationship?