Search results for query: *

Hello, I have now also tried following, but it is still not working. The first one runs but there are no records in the query result. The second one does not run and I get a "JOIN expression not supported." message. However, when I remove the "AND c.sales_group = "Investor Owned Util"" line...

I want all the customers. The customers that have placed an order this year and the customers who have not placed an order this year. For the customers that have placed an order this year, I want to show those orders. joker16

Hello, I have two tables that I am trying to run a Left Join on after I have filtered them with a WHERE condition. I want to filter the Customer table to only the records that are in the customer_group "Investor Owned Util". Then I want to filter the Orders table to only the records with a...

I have not been able to find anything yet, but I am still searching. Thank you for looking into this for me and for the links. joker16

Dim email_sent As Boolean It is defined right above the the other definitions at the top of the code. Sorry, I forgot to include it. joker16

Following is my code: Dim objOutlook As Outlook.Application Dim objOutlookMsg As Outlook.MailItem Dim objOutlookRecip As Outlook.Recipient Dim objOutlookAttach As Outlook.Attachment 'Create Outlook session Set objOutlook = CreateObject("Outlook.Application")...

I am trying to verify that an email was sent but when I use the mailitem.sent property I get the following error: "The item has been moved or deleted." I noticed that before I send the email the sent property is "False" but after it is sent it changes to the error above. Does anyone know how to...

I set stdbName in another module. It is the path to my database.

lameid and PHV, Thank you for your help. I put LIKE in place of the equal sign and changed the %s to _s and it works fine now. Thank you, joker16

I am making a program that runs out of Outlook on the front end and uses an Access database as the backend. I have a field in the database that is a test number. It is a 8 digit number set up in the following format ###-###-## The user will know the first 3 digits and the last 2 digits so I...

I am trying to check what type of authorization a user has (which I get from my database) and then based on their authorization I will make a certain button either visible or not. However when I am trying to check the database I get the error: Run-time error '-2417467259(80004005)'...

I have a form that the user fills their information into. Then I want to take that information and put it into a new row on an existing table, however, when I try to run the code I get "syntax error in INSERT INTO statement." I am not sure what I am doing wrong. The date_of_request...

Thanks AceMan1. That works great. I just want to make sure that I have this right. So instead of explicitly opening an external database, can just set db equal to the current database and use the IN clause with the file path? Do I have to set db equal to the current database?

I think UserDataTable is a linked table. I am programming in VBA from Microsoft Outlook 2003 but I need to get my information from tables that are in Access 97. That path is to an Access 97 file and UserDataTable is a table within that file.

I am not sure what line it is on because it doesnt tell me. I have the rest of my code posted below. What I am trying to do is to have a drop down list on a form where the list comes from a column in a table. I think the problem might be in the rest of my code. Sub UserForm_Initialize()...

I changed my code to what is posted above but now I get Run-Time Error '13' Type Mismatch. I checked my references and I have the DAO reference listed as a higher priority than the ActiveX Data Objects Library so I dont think that is the problem. Any Ideas?

I have a reference set up to a DAO library already. I guess my problem then is that I do not know the DAO syntax.

I am writing an application in which the user's frontend is in Microsoft Outlook 2003 and the backend is in Access '97. From my understanding, Access '97 uses DAO and Outlook 2003 uses ADO so when I am trying to make a recordset and connection I have been using DAO. However when I try to run...