Recent content by vertus

I thought I could get help on Access+VBA here. It seems I misunderstood the specifics of this community. This account can be deleted. Thank you for your time.

Can you show me an example code, please? ChatGPT proposes me the following but I'm in doubt: Sub UpdateForms() Dim frm As Form For Each frm In Forms Dim rs As Recordset Set rs = frm.RecordsetClone ' Create a copy of the form's recordset rs.Requery ' Requery the...

Thanks a lot for the hints. I decided to add a script that checks all forms, and Requery them. Unfortunately, it means that the selected lines in Spreadsheet Forms are reset also, but let it be a compromise for now.

Yep, I'd be happy to start this project from scratch and use a totally different setup. But I can't do this at the moment.

0. I have 2 tables Stuff and Contracts. 1. I have Query that joins 2 tables. It creates a table where there is added info about contracts only to those stuff members who have open contracts. The query is like this: SELECT Stuff.*, contracts.term, contracts.date_start...

So, I'm a digital product designer, and not a dev at all. For reasons beyond my control, I have to work with and develop a small handmade hr accounting system based on MS Access. I'm happy to find this community. I hope to get some help here.