Link to home
Start Free TrialLog in
Avatar of timamartin
timamartinFlag for United States of America

asked on

History dialogue in Access 2007

I am using a modified version of the Microsoft Access 2007 Demo. In their demo they have a field that keeps the history of the text field above it. It will time/date stamp it. I copied the form and changed the info in it so that it refers to my page and my fields. Mu problem is that I get an error showing up in the history box on mine. See below.

This code works =ColumnHistory([RecordSource],"Comments","[ID]=" & Nz([ID],0))

This does not =ColumnHistory([RecordSource],"vComments","[ID]=" & Nz([ID],0))

The only thing I changed from one to the next is the field name from which my source info is coming that being vComments.
snap01368.jpg
snap01367.jpg
Avatar of timamartin
timamartin
Flag of United States of America image

ASKER

Here are the property sheets for the above...
snap01372.jpg
snap01371.jpg
Avatar of Rey Obrero (Capricorn1)
can you find out what the function ColumnHistory is doing?
(my guess is that the function is looking for a domain vComments)
Where is the  function defined? I thought it would be in the Visual Basic screen? When I looked there first prior to posting this question I could find no reference to it.
that could be a macro.. (don't have A2007 now so, i can't verify)
I don't see any events defined for either field on either form. No code/macro/functions
where did you get the demo?
don't look for it..

it is a function in A2007

ColumnHistory(TableName, ColumnName, queryString)

it is looking for a ColumnName (vComments)
did you alter the table to have a field called vComments?
Microsoft web site - I started with that and have been modifying it and learning how it works.

I thought this template from Microsoft(R) Office Online might interest you.
"Call tracker"
http://office.microsoft.com/en-us/templates/TC102068791033.aspx?CategoryID=CT101428241033&av=ZAC000&WT.mc_id=42 
see my comment just above your last comment
Yes I did - I added a field in my table for vComments


>> don't look for it..
>> it is a function in A2007

>> ColumnHistory(TableName, ColumnName, queryString)

>> it is looking for a ColumnName (vComments)
>> did you alter the table to have a field called vComments?
ASKER CERTIFIED SOLUTION
Avatar of Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Once again you have saved my boot and taught me a thing or two at the same time!

Thank you again...