Recent content by HaydenMB

Hi, I have the following code from VBA that loops through all documents in a mail database and extracts all the attachments from them. The only problem is I have to make sure that I do not detacth any files that have a certain email address. Does anybody know how I can extract the email...

Hi, I am a real Newbie to developing with Notes an would really love someones help. I have been doing some VBA script in Access to access a Notes Mail Databaseloop through them and check to see if they have an attachments and then detatch them. I have got as far as to open the database, loop...

Automated Detacthments From Notes via VBA Hi, I am a real Newbie to developing with Notes an would really love someones help. I have been doing some VBA script in Access to access a Notes Mail Databaseloop through them and check to see if they have an attachments and then detatch them. I...

Hi, thanks for the advice I managed to solve the problem with the following two lines of code... Set doc = vw.GetDocumentByKey(strNotesID) doc.Remove (True) Cheers, Hayden

Hi, I have an Access DBase that records all our European shipments that exports the data to a Notes DBase that has a Web application built ontot hat. Currenty we have to export the data from Access, delete the current Notes data before replacing it with the new output. But I have replaced...

Hi, I have an Access DBase that records all our European shipments that exports the data to a Notes DBase that has a Web application built ontot hat. Currenty we have to export the data from Access, delete the current Notes data before replacing it with the new output. But I have replaced...

Hi, I have some code that opens up our Electronic Advice Notes (These are prettyr much excel spreadsheets our suppliers edit and return) but I am having a few problems selecting different WorkSheets. The suppliers will group 5 sheets into one workbok and rename them - Although the spreadsheets...

Thanx soooooo much, you are a God!!!! cheers, Hayden

Hi, I have some code written that creates and Excel Application, copies 3 recordsets (Each is a seperate report) into 3 different worksheets. The code works fine the first time i run it but if I try to run the code again without closing the database i get a error message "91 - Object...

Hi, I have some code written that creates and Excel Application, copies 3 recordsets (Each is a seperate report) into 3 different worksheets. The code works fine the first time i run it but if I try to run the code again without closing the database i get a error message "91 - Object...

Hi, I have written some code that takes a template spreadsheet, populates it with required data and then automatically emails it to the Supplier. The problem I have is that if the user has another excel spreadsheet open it always uses this as the template and not the file. What I would like...

Hi, I have a database that exports a recordset into a spreadsheet and I need to lock the cells that I have copied the recordset into. I can lock the cells but I don't know how I select the range of the copied recordset to lock the cells. The number of records that is pasted into the...

Hi, I have written some code that opend up a template spreadsheet file and then sends data to the spreadsheet for every consignment within a recordset. I intend to send this spreadsheet/advice note out to the relevant suppliers (This has not been added to the code example below) for them to...

Thanks Cheerio, that worked great Hayden

Hi, I have some code written that creates an excel application, formats the page and copies in a recordset from my db which works fine. But now I want to add additional recordset at the bottom of the spreadsheet but I do not know how to do the xlDown function in Access VBA. As the recorsets I...