SharePoint and Access 2007

  • Thread starter Thread starter Chip
  • Start date Start date
C

Chip

I've migrated my tables to a SharePoint site and with a few edits,
things are
going well. Except one field. I have an unbound text box in my form
that
has its sources listed as

=ColumnHistory([RecordSource],"NOTES","[ID]=" & Nz([ID],0))

Before the migration, it was listing a History of the changes to teh
NOTES
field and doing it well. Now, it does record it anymore. I get
#Error.

When I go to my SharePOint list and Right click and say View Entires,
it
gives me an error. Its recording the data. When put information in
the
notes field, and then go to my SharePoint site, the information is
there.
But its not showing the ColumnHistory on my form like it did nicely
before..

Chip
 
Bring up your table in design mode...take a look close at the "ID" field.
When you upload to SP, you see that another autonumber column is made for
you. (this is causing some pain for me...).

So, you likely have to change it to:
=ColumnHistory([RecordSource],"NOTES","[_ID]=" & Nz([_ID],0))
Click to expand...

In fact, you likely have to run a update on the id column to change it over
to the _id that was generated by SP. And, you could simply put code in the
forms after update to copy the _id field to the ID field.

another better bet would be to rename the _ID column to ID and thus existing
code/queries will not break.

I not re-named columns in SP yet..but I dealing with the _ID right now as am
I making this post!!
 
That makes sense.. I didnt think of that.. I have another issue I
brough up with Super East Mail Merge.. Did you see my posting on
AccessMonster?

Thanks!!
 
Back
Top