Search results for query: *

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, 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...

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...

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...

Hi, I am trying to create a new routine that creates a new excel workbook and then copies three tables into three different worksheets in the same workbook. The only problem is that I cannot change to other worksheets. I have created the code to open and create the workbook and copy the data...

Hi, i am trying to set up some rules for incoming mails on my lotus notes (Release 5.08) but I cannot find the Rules Folder that the Notes Help describes. I am using a company specific template for Notes which has changes some of the options, views and menus. Does anybody have any idea how I...

Hi, i am trying to set up some rules for incoming mails on my lotus notes (Release 5.08) but I cannot find the Rules Folder that the Notes Help describes. I am using a company specific template for Notes which has changes some of the options, views and menus. Does anybody have any idea how I...

Hi, I have some code that creates emails with attachments via lotus notes but I cannot get it to confirm a delivery reciept. does anybody have any help on how I can get this to work? Here is the code i am using... Public Sub SendNotesMail(Subject As String, Attachment As String, Recipient...

Hello, I am using Accss 2000 and i am using VBA to create a table. I have created the table fine but I would like to know how I assign one of the fields as a primary key and also create indexes. Here is the code I have created for the CreateTable: Sub CreatePFEPTable() Dim tdfNew As...

Hi, I have a sub-routine in a database (Access 2000) that I am working on that automatically sends an email with an attachment via Lotus Notes. The sub-routine works fine if I do not call it from anywhere else but declare the variables within the routine.. I am trying to make the procedure...

Hi, I am trying to export MS Access reports to Adobe ut I haven't hit the jackpot yet! I have looked at some sample code but they are only for Access 2002. I am using Access 2000 which does not have the Application.Printers settings. What I am really trying to achieve is automatically...