ms access column history

Question

i am using column history to record history of notes in database, i works when i type or make any changes manually, however if i update the data by update query, then it donot get recorded in column history.

Please advise how to correct ar let me know alternate of columnhistory.

Answer 1

Hi harrysmind,

>> however if i update the data by update query, then it do not get recorded in column history.

Would you please share more details about this? I can't reproduce this behavior on my computer. I created a table with a field whose type is Hyperlink. 

After run an update query like below, both the previous value and the latest value have been recorded in the column history.

Have a nice day.

---

Yoyo Jiang[MSFT]
MSDN Community Support | Feedback to us
Develop and promote your apps in Windows Store
Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Answer 2

Thank you Yoyo,

i will rephrase my question again.

so, i am using column history to record changes in a column.

so when i make any changes in manually by typing, it get recorded and show's the history.

however i also have a Form so i want to update muliple records which will be typed in the form, so i am using update query where update to [Forms]![Form1]![Text1]

so i get the following error. The Microsoft office engine does not recognise 'Forms]![Form1]![Text 1' as valid field or expression.

pleae advise, 



Answer 3

i am using column history to record changes in a column.

so when i make any changes in manually by typing, it get recorded and show's the history.

however i also have a Form so i want to update muliple records which will be typed in the form, so i am using update query where update to [Forms]![Form1]![Text1]

so i get the following error. The Microsoft office engine does not recognise 'Forms]![Form1]![Text 1' as valid field or expression.

pleae advise, 



Answer 4

What's the actual SQL of your update query?

---

Doug Steele, Microsoft Access MVP
http://www.AccessMVP.com/djsteele (no e-mails, please!)
Co-author Access Solutions — Tips, Tricks, and Secrets from Microsoft Access MVPs (ISBN 978-0-470-59168-0)

Answer 5

Hi harrysmind,

Have you got any update for this issue?

Good day.

---

Yoyo Jiang[MSFT]
MSDN Community Support | Feedback to us
Develop and promote your apps in Windows Store
Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Answer 6

Sorry for the late response. I have gone on a vocation recently.

>> The Microsoft office engine does not recognise 'Forms]![Form1]![Text 1' as valid field or expression.

For the problem, would you please show us the query? It seems there exists typo in the update query.

Good day.

---

Yoyo Jiang[MSFT]
MSDN Community Support | Feedback to us
Develop and promote your apps in Windows Store
Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Answer 7

The SQL for update query is is 

UPDATE dump SET dump.Comments = [Forms]![UPDATE F]![comments];

Please advise...

Answer 8

The SQL for update query is is 

UPDATE dump SET dump.Comments = [Forms]![UPDATE F]![comments];

Please advise...

Answer 9

By any chance is the comments control on a subform on a form? The syntax for referring to controls on subforms is different. See Refer to Form and Subform properties and controls at "The Access Web" for details.

---

Doug Steele, Microsoft Access MVP
http://www.AccessMVP.com/djsteele (no e-mails, please!)
Co-author Access Solutions — Tips, Tricks, and Secrets from Microsoft Access MVPs (ISBN 978-0-470-59168-0)

Answer 10

Hi harrysmind,

You may check this thread to see if it helps:

The same parameters to be used in three separate queries

It provides information about how to create parameters for query.

Good day.

---

Yoyo Jiang[MSFT]
MSDN Community Support | Feedback to us
Develop and promote your apps in Windows Store
Please remember to mark the replies as answers if they help and unmark them if they provide no help.