Results 1 to 2 of 2

Thread: Email Data Access Form

  1. #1
    Join Date
    Feb 2009
    Posts
    4

    Email Data Access Form

    Having an issue with emailing data out of an access from. Everything comes across to the email message except for one field. That field is a Unique Identifier, it just displays ?????

    Here is the code

    varTo = Me.email

    stSubject = ":: Help Desk Case - UPDATE ::"

    stText = "Your help desk issue has been closed." & Chr$(13) & _
    "Case ID: " & Me.CaseID & Chr$(13) & _
    "Date Opened: " & Me.DateOpened & Chr$(13) & _
    "Date Completed: " & Me.DateCompleted & Chr$(13) & _
    "Issue: " & Me.DescriptionofIssue & Chr$(13) & _


    Any help is greatly appreciated.

  2. #2
    Join Date
    Mar 2006
    Location
    Oklahoma City, OK
    Posts
    184
    Which line of code has the field you are referring to?

    I would recommend that you post ALL of the code for the sub/function/event.
    Boyd Trimmell aka HiTech Coach
    Microsoft MVP - Access Expert
    [SIGPIC][/SIGPIC]
    Office Programming 25+ years as a Software Developer specializing in:
    Business Process Management
    Accounting/Inventory Control
    Customer Relations Management (CRM)
    Electronic Data Interchange (EDI)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •