Recent content by lateefx

Agree 100% on using VBA code to clean up the data in Access - and I would rather keep the data in Access as well - especially since report creation has become easier in 2007 - but Crystal Reports is still a lot more intuitive and lends itself to better report design - you can also set loads of...

I use iMacros do automate the downloading of data off of some online data services - is there any other tool that you use to do this sort of thing... I'm pulling data based on 100 different search criteria (i.e. different countries, different keywords, etc.) -- and it would take WAY too long to...

Re: ColumnHistory - Can you change the text displayed "i.e.[Version: 12/4/2009 5:20:5 Thanks Bob - I've already done so much customization to this database's forms - I think that default text will have to remain just a little longer. Especially, since I can't think of an easy way to track...

ColumnHistory - Can you change the text displayed "i.e.[Version: 12/4/2009 5:20:56PM] When you use the ColumnHistory method to auto-populate a field in a form - say for a history of comments or notes - is there a way to edit the text that is auto-entered before the actual comment or note...

To learn how this works simply open the SALES PIPELINE Access DB template that is free with Access 2007. You will find on the 'Opportunity Details' form there is is tab called 'Comments' -- this tab has two fields in it...one is 'Comments' and the other is 'History'. 'Comments' is the field...

Check that the memo type field that the history is being pulled from (in your datasheet or query) has the property AppendOnly set to YES.