Recent content by kes

  1. K

    report attachment

    hi, I've an access file I created which issue a report. in the report I have a picture attachment, but it's really small in PDF output. is there any way to present it as a picture with a link that once pressed on open the image in a full size view? thanks for the helpers!
  2. K

    open a form with filtered criteria

    thanks! thanks! thanks! the changing to MM/DD/YYYY worked like a charm!
  3. K

    open a form with filtered criteria

    Hi, I'm trying to open a form with filtered criteria using this code: DoCmd.OpenForm "Edit_Mission", acNormal, , "[Report_Date]=# " & Format(Me.Date, "dd\/mm\/yyyy") & "# And [Supporter_Name]='" & Me.Supporter & "'" it used to work on access 2010 but now on access 2013 I get a blank form...
  4. K

    filter form with mulitple conditions

    Hi, I want to open a filter form with mulitple conditions.one of them is a date condition. I'm using access 2013 and the code below: DoCmd.OpenForm "Edit_Mission", acNormal, , "[Report_Date]= " & Me.Date & " And [Supporter_Name]='" & Me.Supporter & "'" it's opens the form but with no data. I...
  5. K

    access 2013 wizard

    hi, does anybody knows how can I use package wizard for access 2013?
  6. K

    access runtime

    any one knows?
  7. K

    missing operator on a delete query

    thanks!!! worked!
  8. K

    missing operator on a delete query

    hi, I'm trying to find a solution for this without success... I bet is rather simple and I'm missing it... I have this code: CurrentDb.Execute "DELETE FROM Type WHERE Project_ID =" & Me.Project_ID & " & AND (Type = '" & Me.Txt_Type & "')" and I'm getting this error message: Syntax...
  9. K

    report in the email body

    done that... it's highlights the strRep...
  10. K

    access runtime

    hi, I am using SharePoint 2010 lists as my tables in my access file. the users sometimes have no access to the sharepoint and I want them to sync their tables to sharepoint later once they do have access to the web. I have no problem doing it on the regular access file, but when I'm using the...
  11. K

    report in the email body

    no one knows?
  12. K

    report in the email body

    yes. I'm sorry, didn't know how to do that... now I know :) I get it on the strRep part: vMsg = "Site:" & Me.Customer_Name & vbCrLf & "Report:" & strRep
  13. K

    report in the email body

    yes the summary is the reportI want to send. but I geterror type mismatch... any idea?
  14. K

    report in the email body

    hi all, I have a report that I'm attavhing to an email in a button click. now I've been asked to also add the report to the email body. I've tried several ways but none of them seems to work. please see below my none working code: Private Sub Command64_Click() On Error GoTo Err Dim message As...
  15. K

    display email before sending it

    working! thanks!
Back
Top Bottom