Recent content by Lojita

Thanks all for the help, but what can I do? I do need some info of this three tables and need to update some fields in TRABALHADORES. :confused:

Hello Dale. Here goes the SQL code for the query: SELECT CONTRATOS.*, TRABALHADORES.*, DELEGACAO.*, TRABALHADORES.FichaAptidao, TRABALHADORES.Consulta FROM (CONTRATOS INNER JOIN TRABALHADORES ON CONTRATOS.[Nº Contrato] = TRABALHADORES.[Nº Contrato]) INNER JOIN DELEGACAO ON...

you have to force the data to be saved. try this. IF Me.Dirty Then Me.Dirty = False Forms![frm_Capex_Submission].[frm_CapexSignatures].Form.Requery This way should work

Morning. This report is based in this query Q_FICHA_APTIDAO and I've tried to open it manually and it's not updatable. What can be done?

Hello again. After reading your posts I tried to modify my code and the error comes in this line: rst.Edit (error 3027 - Database or object read only) Ideas please! :banghead: Thanks

My apologies. The error appears when updating fields (code bellow): Do While ((Not rst2.EOF) And (count <= num_rec)) Do While (Not rst.EOF) If rst2("Nº Contrato") = rst("CONTRATOS.Nº Contrato") Then rst.Edit rst(TRABALHADORES.FichaAptidao) = True rst(TRABALHADORES.datafaptidao) =...

After printing the report the user is asked if it was OK and then starts a procedure. The problem is that it returns an error message "3001". The code is: Private Sub Report_Close() On Error GoTo Err_Report_Close Dim db_contratos As Database Dim rst As Recordset Dim rst2 As Recordset...

Hello. I use Access for many years but recently I had to start using VBA and have some dificulties. I hope that chating with some experienced users in VBA I can make it work. :confused: