Recent content by gringope24

  1. G

    Searching in related field

    Thank you for your propositions, but it not fit my expectations of intuitive user interface. I was thinking about two solutions: 1) Combo box which will be filtered dynamically, when you type at least 2-3 characters and combo automatically dropdown to show matches 2) Instead of combo box use...
  2. G

    Searching in related field

    Hi Folks, When the table field is related to another field in another table then mostly the easiest way to choose a value is to use combo box. When there are available five, ten or even few dozens of values to choose, it is no problem with clarity of using the form. The problem arise when I...
  3. G

    Make SUM() return zero instead of null?

    Yeah, I will check It, neverthelss, I thought the most elegant way would be to use CASE NOT EXISTS, but it twisting my mind...😀
  4. G

    Make SUM() return zero instead of null?

    Ok, I made some step forward. I make a query which gives 0 when Employee has no records - below results. But my further concern is how to create a query that will do fallowing thing: If there is no records for the Employee in specific range of date, then Sum Worktime is 0. Now when I give...
  5. G

    Make SUM() return zero instead of null?

    Hello All, I am facing similar problem like swistoni. Generally I want to list all employees whose worktime (in hours) in specific dates is lower than planned. Query works when Employee has register some of his worktime. Unfortunately when Employee has no records within specific dates, then he...
  6. G

    Solved Salary cost for specific date / Valid From issue

    Oh gosh, I realized that by mistake I put 2020 instead of 2021🤔! Thank you for pointing it out! It seamds that query works! Thank you for your proposition. It is another way to do it!
  7. G

    Solved Salary cost for specific date / Valid From issue

    Here: Entered data is for tests purposes only.
  8. G

    Solved Salary cost for specific date / Valid From issue

    Hello Folks, I work on application to keep the worktime of employees and to calculate their costs. Employees have different salaries depend on the date. In below table it is clearly shown: Worktime is keep in separate table I create the below query to list what salaries should be assign to...
  9. G

    Input of Work Time in Unbound Form

    Agree, BUT... the essence of using database and generally digital technology means to me automation of boring activities. In this situation, if employee doesn't add regularly his worktime, then he has to fill the data around 20 times. Using a series option he is able to do it a lot faster. Of...
  10. G

    Input of Work Time in Unbound Form

    Hello to All, I am preparing database application which will be storing worktime of each employees. In the form to add the worktime a prepare 2 options: a) add single worktime to specific date (e.g. 5 hours on 02.08.2021) b) add a series of worktime for range of data (e.g. user input 10 hours...
  11. G

    Insert... ; Select @@identity

    What should I understand as a session? Does below code open a session? Dim db As Database Set db = CurrentDB Does below code open two sessions? Dim db1, db2 As Database Set db1 = CurrentDB Set db2 = CurrentDB
  12. G

    Insert... ; Select @@identity

    Ok, now i found a typo. In my SQL statement i was forcing to find identity in a specific table, which was wrong: Set rs = db.OpenRecordset("Select @@IDENTITY From tblMyTable As LastId;") Instead, I put: Set rs = db.OpenRecordset("Select @@IDENTITY As LastId;") Now it works! Nevertheless...
  13. G

    Insert... ; Select @@identity

    I am facing the same problem as emimarz - rs always return 0. Has anybody figured it out?
  14. G

    Adding a record only after clicking OK button

    Hello folks, the easiest way to add new record seems to be opening a bound a form with a below code and just enter data. DoCmd.OpenForm FormName:="frmAddNewCustomer", DataMode:=acFormAdd But this method creates a new record when just even one field will be filled. I want to create a new...
  15. G

    Continous form vs List Box. Which is faster/better?

    Thanks everybody for discussion. Dear Isaac, thanks you for discription but can you share the some screenshot to visualize your approach? Below I paste the same data presented in different ways. Continous Form: Listbox:
Top Bottom