Search results

This is perfect. Thank you so much :)

I changed the line of code as you suggested. Now, it says I have a "Type Mismatch".

This is the code I'm trying to use. Option Compare Database Public Function DeptEmails(ByVal DeptName As String) As Object Const adOpenStatic = 3 Const adUseClient = 3 Dim DomainDN As Object Dim someName As String Dim ADConn As Object 'ADODB Connection Dim rs As Object...

Does anyone have any ideas on this one? As it stands now, I have to delete the header row once the query results are pasted into the new program. I would really like to eliminate this step if at all possible.

I apologize, I thought I was using the code you provided. I changed mine to match yours exactly. Now, I am getting a new error message. The error message is "Object doesn't support this property or method". When I click on Debug, it highlights this line of code: .Source = "SELECT mail FROM...

I'm afraid, it still doesn't like the line that reads Set DomainDN = CreateObject("ldap:\\rootDSE"). I am still getting the same error message and it highlights this line of code.

I set the DomainDN as an Object instead of a string and I added the word Set in front of the "DomainDN =" line. However, I'm still getting the same error message and it is still highlighting the same line of code.

I'm getting an error that says "Active X can't create object". When I click on Debug, it highlights the line of code that reads: DomainDN = CreateObject("ldap:\\rootDSE").Get("defaultNamingContext")

That works perfectly. Thank you.

I currently have two forms. One being my main form and the other being a pop-up form to update e-mail addresses. On my main form, I have a button that is currently programmed to generate several e-mails. Before those e-mails are generated, I would like the pop-up form to appear asking for any...

I have a couple questions regarding the code provided here. I just tried to add it to my database, but received an error message that it couldn't create the object. Is there a reference that needs to be added so that this will work? Also, is it possible to use wild cards when the function is...

I found code at this website that is supposed to determine if a specific program is running on your computer. I have a couple questions about the code here. One, when I run it just the way it is and call it in the immediate window with the ?fIsAppRunning("word") command, it tells me "True"...

I found the following code to copy the results of a query to the clipboard. DoCmd.OpenQuery "DataLoadTemp_qry", acViewNormal, acEdit DoCmd.SelectObject acQuery, "DataLoadTemp_qry" DoCmd.RunCommand acCmdSelectAllRecords RunCommand acCmdCopy DoCmd.Close acQuery, "DataLoadTemp_qry", acSaveNo It...

Is there a way to program the database to open a program called DataLoad (located at "C:\Program Files\DataLoad\DataLoad.exe") and then paste the results of a query in it? The DataLoad program opens and looks very similar to an Excel spreadsheet with the focus in the upper left hand corner. I...

Thank you for the advice. It works great :).

Okay, I got it to work, as long as I don't try to rename the file. I would really like to rename the file though, do you have any suggestions?

Thank you very much for the code. I've added it as a module to my database. However, I am having a little trouble getting it to work. This is the call statement that I tried: Call Outlook_FileAtchmt("FW: Cycle Count for Bin 143607489 ", "\\C:\MY DOCUMENTS\" & sSubjectLn & ".xls") Have I done...

How would you solve that?

In my table, BIN is formatted as Text with a limit of 50 characters. I declared my variable BinName as String. I thought that was the same. Is it?

Is there a way to program Access to look in a specific folder in Outlook, find the message with attachments, open those attachments, and pull the updated information from the spreadsheet to the database? I know this is asking a lot, but I figured if anyone knew how to accomplish this, they...