Discover-E again

Just had the presentation from Rich Radford et al, and this product looks slick! We’ll check it out with some of the guys that run it, but we are very impressed so far. hoever, as with all these things, you really have to look at what you’ve got and what you need and test the products thoroughly! Needless to say we have had some very good recommendations though! Thanks Rich! http://www.discover-e-legal.com

Martin.

Discover-E

I would be interested to hear anyones feed back on this product. We are about to get a demonstration and wondered if anyone has experience of the company and the support it offers. Also, does anyone have the product?

 Martin.

Tiff images

Why not PDF? Any info welcome!?

We can see the ups and downs of both PDF and tiff format. There are many many reasons for either to be produced. But expense and size don;t seem to be an issue any more. And PDF is a portable standard and has the text embedded… I will try to bring in more resources to this blog regarding our trials and tribulations of TIFFing and some product reviews and what we did instead…..!

 Martin.

Bates Numbers

Access VBA code to work out range of numbers

There was a recent question on the litsupport group about how to make up a range of ‘bates numbers’ e.g.

In two fields you have:
DocID BatesNo
A00001 A00001
A00001 A00002
A00001 A00003
A00001 A00004

And what you actually want is one record stating:
DocID BatesNos
A00001 “A00001, A00002, A00003, A00004″

The only way to do this in Access would be to loop through the record set using VBA. this is a simple bit of code which I have adapted to the situation.

A simple function:

Function BatesRange(firstbates As String, lastbates As String) As String

Dim firstBatesNo As Long
Dim lastBatesNo As Long
Dim prefix As String
Dim i As Long

prefix = Left(firstbates, 1) ‘ gets prefix for bates numbers

firstBatesNo = CLng(Right(firstbates, 5)) ‘converts last 5 digits to a number
lastBatesNo = CLng(Right(lastbates, 5)) ‘converts last 5 digits to number

For i = firstBatesNo To lastBatesNo
BatesRangeTmp = BatesRangeTmp & prefix & Format(i, “00000″) & “;”
Next

BatesRange = BatesRangeTmp
End Function

All you do is pass it your two values for start and end. You can get this by grouping your data in a query by DocID, the displaying the first and last
values of the BatesNo using the standard [First] and [last] grouping functions in a group query. Hope this helps. If you have any questions or want the sample database I created, please email me.