Search results

  1. G

    Get the last dataset

    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
  2. G

    Print form/report with filter

    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...
  3. G

    Button visible false

    Good Morning guys, I've a form with a Password request. I want to make a button on a other form invisible until someone wrote the Right Password. I tried it with Forms!frm_all!Befehl23.Visible = false And an if with Forms!frm_all!Befehl23.Visible = true may someone can help :) best regards...
  4. G

    Search/Filter ListBox

    Hi there, I want to filter my listbox via a search. Private Sub Befehl100_Click() xx = InputBox("Name eingeben") Me!Liste85.RowSource = "SELECT tbl_Mitarbeiter.ID, tbl_Mitarbeiter.Nachname, tbl_Mitarbeiter.Vorname, tbl_Gruppe.GrpName, tbl_Mitarbeiter.ID FROM tbl_Gruppe INNER JOIN tbl_Mitarbeiter...
  5. G

    database User

    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...
  6. G

    Macro don't work at start

    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...
  7. G

    Listbox filter via Combo box

    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 = '" &...
  8. G

    form filter via vba/macro

    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
  9. G

    Filter from form to report

    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...
  10. G

    Import Excel Data to Access

    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...
  11. G

    Import single Cells from excel

    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...
  12. G

    Combobox

    Hi there, is it possible to select all datasets in a Combo box? That I don't have to select every single dataset.
  13. G

    Unter form with Max

    Hi there, I've build a form where I can pick an Identity number in the Dropdown menu to get all events of that person. It works perfect, but I've realized that it shows really every event. Every Event is categorized. My Problem is that is just want the latest event for each category for that...
  14. G

    Latest Date per product

    HI guys, I want a query where I can see the product and the latest date. Is this possible? Can someone help ? Best regards Georg
  15. G

    SQL If /Else

    Good morning, I've 3 tables (tbl_Medical, tbl_Employee & reference table tbl_EmpMed). fMedical in tbl_Medical is the standard frequency of each medical examination but they can be personalized if there is a need. Frequency in tbl_Emplyee is the personalized frequency for each Employee. My goal...
  16. G

    Form to search and edit datasets

    Hello again, I want to build a form that is like a query but I can edit the queried data sets. Should be like: type in the ID of the product you want to edit. Shows me every product with the ID and I can edit the price of the product. Any ideads? Best regards Georg
  17. G

    automatic data set creation

    Hi there, I've 3 tables (tbl_all, tbl_students, and tbl_tests) I want a database to check if the students have done their Tests. The amount in tbl_students shows how often the students have to do their Tests per year. So my Goal is to create a form where I can select the Student and the test...
  18. G

    chart + button

    Hi there, does someone know if it's possible to link the circled(dia.jpg) with other Charts. So if I click on the circled Name a new Chart opens. Maybe someone of you got an idea.
  19. G

    Chart value cut

    Hi there, I have a problem with my Chart. Sometimes the value is to big and my line goes out of the Chart. Does somebody know how to cut my value if ist bigger than 1,5? So if it's 1,6 it will be cut to 1,5. In Excel it's (X1 > 1,5;1,5;X1) Best regards Georg
  20. G

    sum + name

    Hi there, I got a query that sums all set values and actual values of every Business ratio. But I can't select the names of my Business ratios. Maybe someone got an idea how to get both ? Everytime I want to select the name I get a warning that my aggregation function won't work with the name...
Top Bottom