Search results for query: *

Have a number of databases that generate formatted emails in outlook. Client has just installed Titus Labs for email classification. Emails default to Internal settings but I need to automated the process of changing the classification to confidential. Has anyone come across this before or...

Hi, I'm using Access 2007 and have a module that creates a ftp script at runtime and then executes a .bat file passing in the name of the script to run. The .bat file looks like ftp -s:{script file} {server name} The ftp script looks like {Username} {Password} cd {destination on server}...

Hi, I have been using the below code successfully for a while in Access 2003, however I'm unable to get it to run in 2007 (Code example has been cut down to save space) Function Zip(fPath, ToAttach As String) Dim oApp As Object Dim Attach As Variant Dim i As Integer CreateZip (fPath)...

Probably missing the obvious here, but here goes. I need to build a routine that will build an email in Outlook from Access 2003 based on numerous recordsets. In Lotus Notes it easy ' After setting up the mail with objNotesRTF .AddNewLine 1 .AppendText "Line 1" .AddNewLIne 1...

HI, Been using an old version of Excel and use the following code to loop through the files in a folder and process them in the order they were last modified. Wtih Application.FileSearch .NewSearch .LookIn = "C:\Test\" .FileType = msoFileTypeAllFiles If...

I have been advised that one of my databases needs to be amended to pull it's data from a SOA interface. Having never heard of, let alone used, this before I have a couple of questions. 1. Can this be done 2. If yes, how? Any advise/code/clues where to look would be greatly appreciated on...

I'm trying to pass multiple command lines from Access using Shell I can change the directory using the following strShell = "cd /d H:\{Full FilePath} This then leaces the command line window open with the following {Full FilePath}> My question is: How can I now pass another command to the...

I'm using Access 2000 I'm trying to add data to a table and I'm getting the following error message which I have never come up against before and it's got me stumped. Run-time error '3802' 'Error evaluating CHECK constraint' This happens if I try to add data via a Query, Executing a SQL...

Has anyone had the following problem or know the solution. Everything has been working fine up till today. I can no longer copy and paste from one workbook to another. If I select cells in one workbook the paste icon is available, but as soon as I move to another workbook and select the...

Just a quick question that I hope someone can help with. I'm using Access 2000 and Lotus Notes 6.5 I'm creating emails from code which isn't a problem and I'm also able to control how the recipient views data such as who sent the email and the return address once the email has been opened using...

I have an access db (2000) which is used for sending emails via Lotus Notes. I'm building a string of email address from a recordset based on a table. When passing the string (SendTo) to Lotus notes using objNotesDoc.ReplaceItemValue "SendTo", SendTo The string is being cut short. However...

I'm using the ASCII value of characters to navigate an excel spreadsheet i.e. ' i is a long that relates to row number .ActiveSheet.Range(chr(65) & i).select My problem is I need to merge a number of cells on a given row dependant on data in another sheet. I'm fine for columns A to Z but...

Have done a search but found nothing yet. I have a matrix table and a recordset based on this table. Is there a way of having a blank form and in the on load event doing the following based on the results of the recordset. 1. Adding a control to the form 2. Bind the control to a field in a...

I know this has been done before nut I can not find the original thread. Using DoCmd.TransferSpreadsheet you can output the results of a query to an Excel Spreadsheet. However, is there a way to output the results of 2 querys to different worksheets in the same workbook? Thanks Mike

Was wondering if anyone knows if it is possible, in VBA, to take a file and zip it using the FileSystemObject perhaps???? Thanks

I have a function that creates an Excel spreadsheet, from Access 2000, which is working fine. However I need to pass a formula to a specific cell. I'm using the following code where balSrt is the first rown and balEnd is the last cell in the range. .offset(irow,icol).formulaR1C1 = "=SUM(D" &...

Hi, I'm Hoping someone can help. I'm using Access 2000 and have a form with a embedded web browser that will be used to download a file. The code used to navigate to the webpage and enter the required details is as follows Private Sub Form_Load() Dim IE As Object Dim URL As String Set IE =...

Hi, I've built a module in Access 2000 which generates emails in Notes 6.5.5 The emails are currently being created in the users draft folder as they require checking prior to sending. My question is how do I get them to be generated in the drafts folder of a group mailbox that the user has...

I have a module in Access (2000) that is building an email in Lotus Notes (ver 6.5) but I'm having a couple of problems. 1. The email is being produced in the draft folder of the user who is logged into to Notes on the PC. The requirement is for the email to be produced in the draft folder of a...

I have a form with an embedded Microsoft Web Browser Active X Control (calledWebBrowser) The browser will load the required site but I'm having problems entering a value to a control on the webpage. Code Below: Dim strURL As String Dim IE As Object strURL = "Website Address" Set IE...