Search results

Thanks for the info pr2-eugin The suggestion for DCount sounds good to me so I implemented this into the database which works perfectly!

Thanks for the quick replies! Elizabath, you gave me a new idea how I could do this more easily using an existing query I build. The function I am currently using is: If lstLinkCategory.Value = "Components" And lstLinkToCategory.Value = "Products" Then...

Hello again, I would like to make a DLookup that check 2 criteria in two different columns in the same table. The reason to use a DLookup is that I would like to check if two parts already have been linked together. The user therefore selects two values in to different comboboxes (lstLinkPart...

The SELECT DISTINCT solves the problem. Thanks you very much :D !

I made a new field where both values are combined into one field. I think that by using vba I can get it to work. Thank you for your reply!

I will make a sample of for this case in the coming days. Thanks for your reply!

Thanks for you time Plog! Yes, all given tables are required. No more no less. At the moment there is only sample data in the database. The query should check in all the link tables (which are linking the components to other categories) which components are entered. After these components have...

Is it possible to make a formula in access that could show from and to which status it goes in one field?

I attached the input and output to this post. I hope one of you could generate the output as shown in the excel file. Thanks in advance!

This is done in order to make difference between systematic layers. For example a computer exists of multiple components such as the motherboard. These components subsequently consist of other components, called sub components, such as resistors and IC's.

I would like to show all linked components (once) in a query. With inner joins (option 2 when double clicking on a relationship line), it shows all linked components but with duplicates. When selecting option 1 (only include rows where the joined field from both tables are equal) I only get 1...

I am quite curious about a SQL solution, especially if you say it could be a better solution. I have have a follow up question about the queries which you designed because I would like to make difference between the values calculated in the IsRefSourcesChanged and IsRefEstAvailableChanged...

I already have a complete Relation Schematic for my database. Therefore I do not know what I should change in the design in order to fix my problem, personally I do not think that changing the design of my tables and relationships would solve my question. Isn't it possible to solve this problem...

Mihail, you're a genius! Such a simple but very effective solution:D. Love it As for now, it does everything I want. Thank you therefore!

Sorry for keeping you waiting and thank you very much Mihail for all the help! This weekend I didn't get any change to get on the computer, which is why I didn't get a change to test it and get back to you. Today, I will get back to you regarding this subject.

CazB, Thanks for the quick reply! Yes these tables are related with each other but with a relationship table in between. I attached a screenshot of a part of the table relationship related to this question.

I was wondering how to calculate all records that have not yet been linked to other records. For example: I have 1 Product, which is linked with multiple components which is subsequently linked to subcomponents. All these types can be linked to Alternate Parts. In order to reduce redundant...

Mihail, thanks :D! I hope you are able to find a possibility, or get a slight idea of where I should start to solve this. The reason why I used text as PK in both tables is due to the fact that many Part Numbers contain text. Thereby is this a guaranteed unique value, The only other option...

Thanks for your quick reply Mihail! Sorry for the missing information on my part. I did as you asked and attached the file to this post. The only issue I found during this process was that I could not select save as as a access 2003 version in access 2013 but only one which is compatible with...

Hi, I hope I post this in the correct section of the forum, forgive me if not. I would like to ask for some advice because I'm don't know how to implement a functionality into my access database. The related tables required for this functionality can be found as an attachment. When the...