Search results

Thanks plog for replying, the fields type is not important, it's a sample database and only relationships is important for me. Indeed, we are a Concrete Laboratory, we have many projects (building, apartment, dam,..) in our city or different city. we test all sections (Foundation...

As I said Section fields in tblSection is not unique. because projects has common sections for example "Foundation"or "Column" section, but the combination of "section name" and "project code" in tblSection is unique.

Hi all, I'm confused by the relationships between 3 tables. I have 3 tables include "Project name","Section","Samples", that every Project has several sections and every section has several samples. like this: (this example for 2 project) The first table (projects) and the second table...

Thank you June7, but it gives this error after run the code: Dim graphExp As Object Set graphExp = Me.Graph0 graphExp.Export "C:\Graph.jpg", "jpg"

Hi everyone, I created a graph by a query on a form and now it shows only the graph, How can I print the graph or form, or export to pdf?? (Horizontally) Thanks in advanced.

Thank you so much.

No, it's a dlookup field based on another bound field : Text28 Control source : =DLookUp("UnitName","tbl_Units"," UnitCode = '" & [UnitCode] & "'") [UnitCode] is a bound field on the subform and I'm using dlookup in Text28 to call unit name on subform. now my problem is that filter on subform...

Form is bounded and there are several fields, but one of the fields is unbouned (Text28)

The unbounded field name on the subform is Text28 .

Hi all, I'm trying to filter subform by a combobox on main form, but the field on subform is unbounded control.(Dlookup from another table) Private Sub txtBranch_AfterUpdate() With Me .Child01.Form.Filter = "[Text28] LIKE '" & Nz(.txtBranch, "*") & "'" .Child01.Form.FilterOn =...

Thanks a lot arnelgp, That's what I want. is there a way to do that without extract?

Hi, that's a good idea, but I don't know how I can do that. do you have a sample file or code? Is there a way to do that without extracting the images like OLE object ??

Thank you arnelgp, I have another question about image, is it possible to set image of form background from attachment fields? I want to set 10 images to background of a form so that the images changes by user. the simple way is that the images called from a folder, but I don't want to use any...

Hi every one, I would like to use css3 hover for image in access because it's difficult to assign hover to image on access form. is it possible or has someone sample file of my request? Thanks in advanced.

Hi theDBguy, Thank your very much, sorry I didn't see your link, I thought that's an ads. that was very helpful and I used it in my project.

Thank you @Isaac , but that's not what I want, Stop Days is a calculation field on subform, actually I don't need it. I need to calculate sum of stop days between two dates. like this : @Isaac. your right. it would easier if each record stored single day, but it's difficult to enter single day...

Hi all, I have a table and it contains of stop dates of our equipment, the dates specify that which days the equipment was failure and not working. the below image is showing total days of equipment downtime is 45. Now I need to know sum days of downtime based on two dates. for example : I...

No I haven't seen sample files of microsoft, but my problem has been resolved by pbaldy code.

Your way worked fine, thank you very much.