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!

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?

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

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

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

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

Hi, I have a vba code for opening a form with mulitple conditions for opening a form displaying a specific record, but I'm getting a blank form as result. this is the code I'm using: DoCmd.OpenForm "Edit_Mission", acNormal, , "[Report_Date]= " & Me.Date & " And [Supporter_Name]='" &...

hi, I have 1 table with one to many relationship to other two tables (added a picture). I thought on creating a form with subform to enter the data, but the problem is that I need first to enter into the supporters table and to the Serial numbers table before entering the Error table... that's...

hi, I have a form which have a sub form. in the sub form I have a the direct table to update data on it. example: the form has the name of the project and the subform the name of one of the items of the same project and the table present the documents for the particular item. the users have the...

Hi all, I have an old program with ade file extension and I would like to add some filters in one of the forms but I don't have design view or layout view option. :confused: what can I do?

Hi all, Is it possible to receive an email when a row added to a specipic table? thanks in advance Karin.

Hi all, I'm trying to export a task list from SharePoint that will be a linked table to my DB. the problem is that the field "Assigned to" is extracted as a number and not a text, therefore I can't do a join to another table using this field. is anyone know what causing this or how I can fix...

Hi all, I'm trying to create a query inside VBA code. the problem is that my query is a select query and therefore I can't use RunSQL :( I tried to work around it withbut had no luck... this is the code: strSql = "SELECT '" & Me.number & "' ,Karin.[subject] " & "From Karin " & "WHERE '" &...

hi, I'm using access 2010. how should I share the access file I created that will be the best way? there are 20 users that need to add/edit/view the data. I read in some places that I need to do share on options and some said that I need to split the file to data and front file. what is the...

hi, I have a question and I will try to simplify it as much as I can. I have a form(form1) that the user is entering data into the table through it and another form(form2) that include a text box to select user and a query based table that shows the data accroding to the text box. for some...

hi, I have 2 list box. one bound to a table and one unbound presenting the values that i added to the table. i have an add button that add the values to the table and the unbound list to present them. I'm having trouble with the remove button. I want the button to remove the item from list2(the...

hi, I have a list box on a form and I would like the user to have the possibilty to add another item not from the list into the table using a command button. how can I do that? thanks for the helpers!