Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: kriehn16
  • Content: Threads
  • Order by date
  1. kriehn16

    SQL Join Query in Access

    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...
  2. kriehn16

    "The item has been moved or deleted" error when using sent property

    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...
  3. kriehn16

    Problem using wild card characters

    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...
  4. kriehn16

    Problem opening a recordset

    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)'...
  5. kriehn16

    INSERT INTO syntax error

    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...
  6. kriehn16

    How to Make a Connection in DAO

    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...

Part and Inventory Search

Back
Top