Recent content by JQasd

Thanks. it means it can't be done via 1 main table.

Can anyone tell me one thing please. I have a database of material All these materials have certain properties saved in excel sheets and I export it using the Access interface. Please see attached image that there are 3 properties and their sub data types. However, I only want Mechanical...

Please explain in a bit more detail. Thanks for your reply

No, at the moment I have created separate tables and then created reports via them. I want to do it via the main table. Any suggestion?/ How to filter it according to material type Thanks

I want to generate a report that has only titanium in it when titanium is selected. See the List button beside the Material.Basically when a certain material is selected I want the list to generate a report that only gives information about the specific material.

Thanks for your reply. Please find the image attached. Is it possible to use a code that could just filter Titanium when it is selected and so forth.

Can anyone help me with generating a list / report when a certain material is selected in drop down list. Foe example when Aluminium is selected it shows me all the columns with Metal codes of aluminium and other columns relating to it. At the moment, I have made separate tables for each...

Thanks a lot. You have helped me a lot in this database development. be blessed. Can you tell me one thing more please. All these materials have certain properties saved in excel sheets and I export it using the Access interface.Is there any way in the main table I can add that mechanical...

Eliminate repitition in a drop down list Hi there, I have a main table that has various metals with specific metal codes.For example there is a material column such as titanium aluminium etc.And when metals are selected in my drop down list I want another drop down list to populate all the...

There are 10 different reports extracted from their specific queries generated by the main table. For instance, when Aluminium is selected Al-Report is opened. When Steel is selected Steel-Report is opened. They aren't connected to each other

Yes, there is a separate report for each metal.

Hi there , I have a List button that is to open reports whenever a certain metal is selected from the drop down list. Can you guide me how do this by VB coding. Currently, I have used macro which opens the report for Aluminium when it is selected .as the number of metals have increased using...

Thanks . It works alright for me. Thanks alot

Thanks a lot for your reply. Can you tell me where should I put the coding. because the hyperlinks are just in a table column. The report which the user will view generated by that table will have these hyperlinks.

I don't want to simply edit it but give a different name rather than the long path file link. Just like a long link is changed into a small hyperlink text in outlook. Please assist