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 Westi 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: *

  1. Deb2004

    Access and Outlook

    PicMac - you rock!!! Thank you! Now I can get to work transferring those fields. Wish me luck!
  2. Deb2004

    Access and Outlook

    Thank you so much for responding Ron and Piz! I appreciate your input. I am now having trouble with this: Dim oOutlook As Outlook.Application Dim oNs As Outlook.NameSpace, oFldr As Outlook.MAPIFolder Dim omessage As Object I have similar code, but it is not connecting Access to Outlook. It...
  3. Deb2004

    Access and Outlook

    Is there a way to import the body of an Outlook email into an Access table? As email is in html, is it possible to capture data and link it to a table? I would appreciate help!
  4. Deb2004

    Using SQL Query to create a RecordSet

    Thank you Thank you Thank you! I appreciate all suggestions. It was a data type mismatch. Debra
  5. Deb2004

    Using SQL Query to create a RecordSet

    Hi Zion7, Thank you for responding. I tried adding the (), then changed the Dim statement to DAO.Database. The value of db is still nothing. I have added Microsoft DAO Object 3.6 Library to the references. I don't know what else to do... I appreciate any and all suggestions!
  6. Deb2004

    Using SQL Query to create a RecordSet

    When I checked the variable values in debug mode, the sql value is correct, but there is no value for db - nothing (nada) pops up. Consequently, the value for rs is "Nothing". Do you know why? BTW, thank you for your quick response.
  7. Deb2004

    Using SQL Query to create a RecordSet

    I have used the following code in other apps successfully. It is not working in the present app. I don't know why. Are there any suggestions? Private Sub Form_Current() Dim db As Database 'declare a variable that points to the database Dim rs As DAO.Recordset 'declare a variable that...

Part and Inventory Search

Back
Top