timamartin
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([RecordSour ce],"Comme nts","[ID] =" & Nz([ID],0))
This does not =ColumnHistory([RecordSour ce],"vComm ents","[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
This code works =ColumnHistory([RecordSour
This does not =ColumnHistory([RecordSour
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
can you find out what the function ColumnHistory is doing?
(my guess is that the function is looking for a domain vComments)
(my guess is that the function is looking for a domain vComments)
ASKER
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)
ASKER
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?
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
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
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
ASKER
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?
>> 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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Once again you have saved my boot and taught me a thing or two at the same time!
Thank you again...
Thank you again...
ASKER
snap01372.jpg
snap01371.jpg