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