Recent content by Colin

I have some HTML (not a web site, but on a CD we distribute to our sales guys) that I would to have interact with an Access Table. Read from one Table, write to another (temporary) table from HTML (and a little JavaScript). There must be a bizillion places where this can be described, I'm just...

Actually, that is perfect. I forgot that the ArcCosine can be expressed in terms of the ArcTangent. Thank you

Is there a function for Arc-Cosine? I see the standard Sin & Cos, and know that VisualBasic has one (I'm trying to compute the distance between two postal codes for a LookUp function)

Thanks. I did get Excel to read the 43,000 records, the problem was importing them into Access 97. Turns out that Access had no problem if it was a *.csv file, but did not like the *.xls format. Someone mentioned that is a bug in Access 97. Thanks again for your attention.

When I import an Excel Spreadsheet of 46,000 lines, the import is always truncated to 16,000 lines. I have a sample database where someone else was able to import all 46,000 ... any ideas on settings, etc?

This is a different take on a previous question. What is the best way to link a table to a JPEG file?

I am creating a product catalog and can link Bitmap files in a table. The problem is that I would rather Link to (smaller) JPEG files, and I keep getting an OLE error, to the effect that I do not have the right driver installed? My guess is that the bitmap structure is native and covered in...