Recent content by victorlindh

Thanks. I have encountered a slight problem. I am trying to filter using your expressions WHERE >=DateValue(Now()) AND <=DateAdd("s",-1,DateAdd("d",1,[StartOfDay]))

Thanks. Works perfectly

I want to use in a query. Apparently it is not working. Thanks in advance.

How do I apply this code? StartDate: GetCurrentDayDates()(0) EndDate: GetCurrentDayDates()(1)

How do I call this function to calculate your start and end dates for the current day. Kindly look at the attached database

I am defeated. Kindly please assist me.

Hi. If i may ask what is Maschere?

Thanks for this. Working on it now💪💪💪💪

Kindly please assist me with an example. This is the best approach. Thanks in advance.

Hi everyone. I am making school database. I am defeated on how to show only active data. For example we have 3 terms in a year. I want to hide data for previous years for example in 2025 term 3 to be shown and hide for previous years and terms. I wish when the form(FORM4) is opened, the user...

Use the database in post #17

Hi everyone. I have an access application. I am trying to deploy using vb script. How do I start. Is there any sample database? Please assist.

Thanks. What about in case of a tie in all subjects? E.g 1. Subject 1 -70 2. Subject 2-- 70 3. Subject 3- 70 4. Subject 4- 70 5. Subject 5- 70 6. Subject 6-70 7. Subject 7-70 8. Subject 8-70 9. Subject 9-70 10. Subject 10- 70 Will I use the same query? Thanks so much.

Thanks so much

Hello everyone. I am new in ms access. I am trying to make Students database for entering marks for Subjects done. I would really appreciate if someone helps me to make a query or function which will only select best 7 performed Subjects out of all subjects done. Example. The following students...