Recent content by Lawrenceiow

I have posted this question in MSDN office.developer.web.components and so far have not got a solution, I hope someone here can help instead. I am using Access 2003 (11.6566.6568) SP2 - Office Web Components (10.0.0.6765) I have a pivot table built using "Create data access page in Design...

I use PDF995 which has an ini file in the C:\Program Files\ folder. The ini file contains the path of where the PDF is to be saved. In vb I wrote a script which uses Write# to create my own version of the ini file which includes the path and filename of the PDF. I the used vb as per...

Hozer, I've created a 'website' that runs off a CD. When I set it up it was pulling data from Access tables on one of our network drives so the path OWC had was y:\mis\db.mdb To get it to pull the data from the CD instead I just edited the HTML using Notepad and searched for db.mdb and then...

Thanks for you suggestion Martin, however the "replace" function is not listed in the expression builder otherwise I would have tried that already. Any other ideas?

I have an Access2000 table with over 100,000 records and one of the fields is a text field which might contain a date entry. However, the database where the information comes from uses dots instead of slashes in dates (eg 01.01.2001 instead of 01/01/2001). So I need to replace each dot with a...