Search results

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!

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

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

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

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

any one knows?

thanks!!! worked!

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

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

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

no one knows?

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

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

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

working! thanks!

I did an append query as namliam suggested and then an update query to link it to the rest of the tables. works! thanks!

I found 2010 their, but I'm not sure that I understand the method explained their that can be connected to my code. is there a docmd option?

hi, the data comes from a form and from previous data in the table. not sure what do you mean by an approve switch?

hi all, I have theis code below in order to send query through outlook. how can I display the mail and not directly sending it? Private Sub Command64_Click() Dim message As String Dim rs As Recordset Dim vRecipientList As String Dim vMsg As String Dim vSubject As String...

hi, I have two tables : Table 1: Mission_Id , Mission_Type, Customer_Name... Table 2: Supporter_Name, Report_Date, Area, Unit, Issue_Type, Error_Status,Mission_Id I have a form that the users enter data into and send a report each day. I would like that in a click of a button all the data I...