Recent content by SzymonK

Thank you arnelgp!!!! YOU'RE A STAR!!!! Its works now. Thank You.

Thank you for your help. Unfortunately, for some reason, it opens the form at the first record. I don't know what I'm doing wrong

Thank you very much for all the hints, but unfortunately I still haven't picked up on the problem. Sorry to bother you, but I've only been in Access for 6 months. I'm sorry it's my fault. I have never been able to explain exactly what I mean. So, this is: when the user opens access, The form is...

Hi All I hope you're well How can I wright an expression for the form Event / on load so that I get the following: Load the last saved record in table(TblMainAndPlaner) by a specific SiteId. both these data are in the same table. For example: Load last record where SiteId = 2 If you think...

I'm sorry that I'm bothering you.Is working fine; however, I noticed that I do not necessarily save the last record. The database is in SharePoint, and users have FrontEnd. Many people from different departments will use this form. Is it possible to add something to this macro to show the record...

It works now, thank you very much.

Hi arnelgp. Thanks for reply. DataEntry is setup for No.

Hi All I heve two forms : FormNavigation and Form1 , using for inputting data for day and night shift. I entered the data into the form today, but I closed by accident. After opening the form, access again generated a new record. I would like to open the previous one by pressing button...

Thank You.

Thank You NauticalGent

Hi Members! I have a question about SharePoint. I want to publish a database for various users. If I publish the database, will one of the users be able to: save it on his desktop, make changes in the form so that they are only useful for him and do not affect others? Example: change the...

Hi arnelgp!! Thank you very much!!! Its works perfectly. SzymonK

Thank You jdraw! The shift lasts 12 hours and covers two calendar dates. For example, today, it will be 29/03/2022 6 pm to 30/03/2022 at 6 am. After opening Access, the user has two options (buttons): Day shift (the same calendar day, so it's not a problem) and night shift. While opening and...

I'm working on showing the shift date. The shift starts at 6 pm on one day and ends at 6 am on the next. What formula can I use so that the date does not change at midnight? I used something like this as the default value =DateAdd("d",-0.5,Date()), but it doesn't work for some reason. Please...