Search results
-
A
Updating Two different tables through one form
Hi Pat; Well, the main purpose of saving the date / time is to have a tracking of the date when a user submits the form (when a user fills out the form and save the data to another table) I was using Now() buy there was a problem with the configuration?? How to use an append query?? I´m new... -
A
Updating Two different tables through one form
Hi Majp; Thanks for your help. Now I have tried with your code but the outcome is still the same. I defined (dim) at the beginning of the event. I even tried defining at the beginning of the query but in the end, was the same outcome. What could be the reason? -
A
Updating Two different tables through one form
thank you June7. Indeed, I have changed to Date() and the time has been removed. So I tried again an now this error message came out: :cry: CurrentDb.Execute "UPDATE GC_Fecha SET Fecha_real = #" & Me.Fecha_real & "# WHERE Event_ID = " & Me.Evento_ID & " AND Status_ID = 1 Which parameters... -
A
Updating Two different tables through one form
I have no idea. It is just an empty text box that has the function Now() as default value and it takes the system date as value. The dots are placed there automatically. Should I use another command / function? Well, my computer has the same dots. Even though I have changed the date /... -
A
Updating Two different tables through one form
CurrentDb.Execute "UPDATE GC_Fecha SET Fecha_real = #" & Me.Fecha_real & "# WHERE Event_ID = " & Me.Evento_ID & " AND Status_ID = 1" I ran the code and this error message came out: I think it is close to be solved since the message actually can read the date :unsure: -
A
Updating Two different tables through one form
I have tried using either Sql query or Recordset but at the moment, none of them have worked :cry: -
A
Updating Two different tables through one form
Hi June7; Thanks for replying back. Actually there are already records on the other table, so I just want to fill the field of date / time I tried to do a SQL query but it also did not work: Since the record already exists, I´m using the Update command. I want to fill out the field... -
A
Updating Two different tables through one form
Hi everyone: Hope you are doing well. I´m reaching out to you through this forum because I´m stuck with this and I need your help. So, I have this form in which the user fill out with all the information required. And when the user clicks on the button, the data table is updated with the...