Search results for query: *

I recently installed IIS 5.1 on a Windows XP SP2 computer. Everything worked fine. I then installed ASP.NET and had a number of problems which forced me to fix the DCOM and reinstall. Finally ASP.NET works and IIS works, with one exception. When I create a Virtual Directory through IIS in a...

A user here imported hundreds of Outlook contacts with an email address of "[No email address found]". I am trying to use VBA to delete the bad email addresses. I below is simple code which should delete the email address from an open contact (a test before running it against the entire...

When I tried this it objected to the parenthesis in "SET (ClientAccountMapping.InvoiceCode)='RBK'" Oddly enough, I did not receive a syntax error concerning the (ClientAccountMapping.InvoiceCode)in the WHERE section.

I recently wrote a simple Outlook macro for a group of users at my firm who need particular text added to any email message they send to the group. I gave them custom signatures because the text needed to be formatted when using RTF or HTML without loosing the formatting of the existing body...

If your outlook security is set to high did you sign the code? I run into that problem whenever I go to a new computer. Good luck! Melissa

I'm not sure I understand your question correctly but I think you want a separate sub or function which accepts the button name as criteria. private sub Button1_Click() RunMyQuery "button1" end sub private sub Button2_Click() RunMyQuery "button2" end sub private sub RunMyQuery(byVal...

I did something similar recently that may be of help to you. I needed the data from all of the excel documents in a directory to be appended to a table in my Access database. The code below links a named range in an excel document to Access. From there I ran an append query which already...

Try this dim wbk as Workbook for each wbk in application.workbooks if wbk.fullname = "c:\abc.xls" then wbk.activate exit for end if next wbk

This is just a quick fix but you need to name the new logo "Icon" Since this is a one-shot deal I would open a blank worksheet, put the new logo in it and run this code Sub nameshape() ActiveSheet.Shapes(1).Name = "Icon" End Sub Then delete the old logo from your form, copy the new logo...

Your search criteria should be adjusted so that you are searching for French in the file name not in the file text/properties: .FileName = "*French*.doc" .TextOrProperty = ""

Try this: "=SUMIF('Sheet1'!C[-1],RC[-1],'Sheet1'!C[0])"

We used to have this problem with an Excel solution. I ended up writing to the C: drive then using a BAT file to move the files to the server. The problem only occurred on Windows 2000 / Office 2000 setups. It did not exist on Windows 98 / Office 97 setups and I have not seen the problem...

You could open open your stored procedure using a recordset, then use the recordset with the OutputTo. Sub Example() Dim db As DAO.Database Dim rs As DAO.Recordset Dim rsdesc As DAO.Recordset Set db = CurrentDb Set rs = db.OpenRecordset("SELECT [mytable].field1 " & _...

Ignore this thread - we finally found our solution!

We are attempting to use the custom installation wizard from an administrative installation point to deploy Office XP to a few hundred machines. We have all of the settings working but the options to add a registry settings and to copy template files to the local machine during the installation...

In your code do you have a resolveall? Dim mlItem as Object 'mail message ... mlItem.Recipients.ResolveAll mlItem.Send

I think you want sSQL = "Parameters TempGroup String; Select Location, MEASUREMENT from Table1 Where Location = tempgroup ORDER BY MEASUREMENT" to be sSQL = "Parameters TempGroup String; Select Location, MEASUREMENT from Table1 Where Location = '" & TempGroup & "' ORDER...

Thanks CubeE101. I have gone through enough of these files to answer my initial questions - where to put the Dot files and how to get the macros to work without warnings, especially the ones that access the Outlook address book. It is all just a bit overwhelming compared to the simplicity of...

objWD.ActiveDocument.MailMerge.Fields.Add Range:=Selection.Range, Name:="STU_FNM1" ... objWD.ActiveDocument.MailMerge.Fields.Add Range:=Selection.Range, Name:="STU_SURN" In the above two lines of code 'Range:=Selection.Range' should be 'Range:=objWD.Selection.Range'

I would appreciate any suggestions on best practices or things to watch for with this upgrade, specifically with regard to macros. My firm has been working in Word 97 for a number of years now and we have created a number of custom macros over the years, shared throughout the firm by putting...