Question Date Stamping Comments - Help (Column History)

[debslucy]

I looked at that link you sent - even downloaded the pipeline database to replicate it but copying the link just does not work.

What does the

Then go to your table and click on the memo field - then change the "append to" property to "Yes" (default is no)
Should work.

mean? do you know how i find this fields?

Thanks
Debs

Hi David
I have attached a screen shot of the form in question and the formula.
Hope this is will make it a bit clearer.
I want to add comments in the top comments box , for them to be recorded and date stamped in the bottom box where the formula is.

Hope this makes a little more sense.
Thanks again
Debs

 

[Jeanette Cunningham]

It has taken a lot of time to confirm that the table from the attached database called Furniture 3 is the only object that can be saved to A2007 format.
No matter what I tried to remove any A2010 properties on the form and report, it would not save as A2007 format.
I have attached the database with the table here for DCrake.

Note, that this db has only 1 table.
The form and report were created from that table using the wizard and had no code apart some embedded macros to save, create new and close.

The data is not normalized - it is still in the spreadsheet setup in the table.
Presumably either excel 2010 or access 2010 make it possible to set up a spreadsheet inside A2010.

I recommend that at least the history for each piece of furniture is split out into a separate table where it will be easy to timestamp and to add new comments.

 

[gemma-the-husky]

is a columnhistory a special multi-value field in A2010?

that's the trouble with these non-relational concepts. You limit yourself into a cul-de-sac. Much better to avoid as many application -specific features as possible.

That's why A2003 (and A97) remain so useable - because in the main, they use standard relational features only

 

[debslucy]

is a columnhistory a special multi-value field in A2010?

that's the trouble with these non-relational concepts. You limit yourself into a cul-de-sac. Much better to avoid as many application -specific features as possible.

That's why A2003 (and A97) remain so useable - because in the main, they use standard relational features only

I really don't know to be honest - i've totally lost the plot on this query.

If fact if any one can write me a program - to include 1 spreadsheet table, 1 form to input the details including a comments box that date stamps the comments entered - i will quite happily pay them - PLEASE - I AM DESPARATE!

 

[Jeanette Cunningham]

Look for an access developer in your area.
Understand that a database with one table and one form is not going to do the things that you need from this data.

Spread sheets can work with one big massive table, aka the 'sheet', but databases are relational - this is what makes them great for storing history and date stamps.

Find a developer in your area and get an idea of what it might cost to build the database. Give them your data and ask for an estimate of the cost.

 

[debslucy]

THANK YOU
I just want to say a massive thankyou for all you help - i have managed to solve the problem thanks to Jeff at Barndata.co.uk - he tweeked my formula and added a macro to make it work - and it does - its amazing i can't wait to show my boss tomorrow.
Thank you all again.
(I do have another question - but i will post a new thread for it!!)

 

[Jeanette Cunningham]

That's a great outcome - thanks for posting back about your success.