User Profile

Collapse

Profile Sidebar

Collapse
Ahmedamer
Ahmedamer
Last Activity: Nov 3 '14, 08:19 PM
Joined: Jan 4 '14
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Ahmedamer
    replied to how to send email from access form via outlook
    in Access
    ok
    i used the the following code to send Email
    i need to add cc and body of message from another record
    Code:
    Private Sub Command88_Click()
   

    Dim stWhere As String       '-- Criteria for DLookup
    Dim varTo As Variant        '-- Address for SendObject
    Dim stText As String        '-- E-mail text
    Dim RecDate As Variant      '-- Rec date for e-mail text
    Dim stSubject As String
    ...
    See more | Go to post
    Last edited by zmbd; Oct 28 '14, 02:54 PM. Reason: [z{placed code tags}]

      Leave a comment:

    • Ahmedamer
      started a topic how to send email from access form via outlook
      in Access

      how to send email from access form via outlook

      what's the required code to send Email from access form and the record be attached?
      to [contractorEmail]
      cc [ContracHolderEm ail]
      See more | Go to post
      Last edited by zmbd; Oct 28 '14, 02:57 PM. Reason: [z{please note> outright requests for code may be deleted, please show your work when asking for help(^_^) }]
      • Ahmedamer
        started a topic How can I generate serial number with prefix from other field
        in Access

        How can I generate serial number with prefix from other field

        I need a auto-number field (with formatting 00000)but with a prefix from other field.
        What is the way to achieve this? Is it possible to do this at table level?

        Thanks

        Regards
        See more | Go to post
        • Ahmedamer
          started a topic How can add one field from query to form?
          in Access

          How can add one field from query to form?

          I prepared form for query but I do not know how to add one field from query to form.
          See more | Go to post
          • Ahmedamer
            replied to The result of iif equation in query appairs 0 and -1
            in Access
            Thank you very much. the problem is solved. but another problem appeared. the following equation gives errors
            Code:
            iif([fieldname]=[result],"yes", "no")
            [fieldname] is yes/no field from table source.
            [result] is a field created in query as the following
            result:
            Code:
            iif([fieldename2]=yes, "yes", "no")
            See more | Go to post
            Last edited by zmbd; Jan 4 '14, 04:08 PM. Reason: [z{placed required code tags - Please do this by using the [CODE/] button}]

              Leave a comment:

            • Ahmedamer
              started a topic The result of iif equation in query appairs 0 and -1
              in Access

              The result of iif equation in query appairs 0 and -1

              After using iif equation in query (access 2013)to add new field, the result is -1 & 0
              the equation is result:
              Code:
              iif([fieldname]=yes, yes, no]
              I want the result to appear yes or no (or check box)
              See more | Go to post
              Last edited by zmbd; Jan 4 '14, 08:02 AM. Reason: [OP{Clarify the situation}][Z{Please use the [CODE/] button to format posted code script and formated text - Please read the FAQ}]
              No activity results to display
              Show More
              Working...