Search results for query: *

Thanks... I've had problems with ghost breakpoints before and couldn't understand why M*cr*s*ft didn't have anything on their support page. Mike

Thank-you for all your help. When I converted the database from Access97 to Access2K the Microsoft ActiveX Data Objects 2.5 Library was not a reference. I have added it as a reference and placed it at the bottom of the checked list. The SQL statement now runs without a hitch... Mike [2thumbsup]

Thank-you for all your help. When I converted the database from Access97 to Access2K the Microsoft ActiveX Data Objects 2.5 Library was not a reference. I have added it as a reference and placed it at the bottom of the checked list. The SQL statement now runs without a hitch... Mike [2thumbsup]

Thanks... I'll try that on Monday. Mike[thumbsup2]

Here they are. None of them come up as missing. Visual Basic for Applications Microsoft Access 9.0 Object Library Microsoft DAO 3.6 Object Library Microsoft Visual Basic for Applications Extensibility 5.3 Microsoft Common Dialog Control 6.0 (SP3) Microsoft Forms 2.0 Object Library Microsoft...

Thanks. Microsoft Visual Basic for Applications Extensibility 5.3 is the last checked item in the list. I have tried unchecking and checking it again and the same error still exists. Mike

This was done from within VB... Mike

I use this in my code all the time...When an email is too much. Shell "net send " & strUsername & " " & strMessage, vbNormalNoFocus It has always worked for me... Mike

Thanks... I checked the references and tried unchecking and checking the Microsoft DAO 3.6 Object Library. I still get the same error. This is the error message I am getting: Runtime error '3085': Undefined function 'Left' in expression. Mike

Thanks... I checked the references and Microsoft DAO 3.6 Object Library is the third item in the list under Visual Basic for Applications and Microsoft Access 9.0 Object Library... This is the error message I am getting: Runtime error '3085': Undefined function 'Left' in expression. Mike

I used a RunSQL statement like the following in Access97, but Access2K does not like the Left and Right functions? It says they don't exists... Is there a replacement or am I going crazy? Docmd.RunSQL "SELECT [EN], (Left([EN],6) & Right([EN],4)) AS ESMA INTO [New Table] FROM [Old...

I used a RunSQL statement like the following in Access97, but Access2K does not like the Left and Right functions? It says they don't exists... Is there a replacement or am I going crazy? Docmd.RunSQL "SELECT [EN], (Left([EN],6) & Right([EN],4)) AS ESMA INTO [New Table] FROM [Old...

Unfortunately DDE does not work for Outlook 97, I am not sure about 98,2K,XP though? Maybe check the Microsoft Knowledgebase http://support.microsoft.com

When looking at mail messages in my Sent Items, I can see the reply time and the received time. I have successfully been able to return the received time but am unable to find a propery for the reply time. Is there any way in VBA to accomplish this?

I'm not sure how to change it programatically, however the Microsoft Exchange program can do this for you: From Start|Run: exchng32 Hope this helps...

Just a suggestion... Use the common dialog controls. Check out the Access link on the following page: http://www.geocities.com/bondm007 That way they can also choose there own filename as well. Hope this helps.

You can shell to a system command and instruct Access to wait for that command to finish before continuing... The code is at: http://www.geocities.com/bondm007 Hope this helps....

All the code for making Access wait for the "System" command to finished was posted at: http://www.geocities.com/bondm007 Thanks...

How did you connect to Excel? Through: Dim xlApp as Excel.Application Dim xlWBook as Excel.Workbook Set xlWBook = GetObject("C:\File.xls") Set xlApp = xlWBook.Parent xlWBook.Save xlWBook.Close If xlApp.Workbooks.Count = 0 Then xlApp.Quit End If Set xlWBook = Nothing Set...

This is how I'm doing it (it may not be optimized, but it works): Sub chkFilter_Click() ' Check for status of chkFilter If (chkFilter.Value = True) then Me!lstBox.RowSource = "SELECT Status,Field1 " & _ "FROM Table WHERE (Status = 'x')" Else...