Search results

I think I have an idea that may work. It's very simple. A normal table and only a few line of code. I will see if I can put up a sample database.

In my case it's not possible. I will think over it again to see if I can find a way, but at present I don't see any possible way to use attributes. Thanks for the suggestion though.

You mean if I have 10 similar products I have to write 100 records to the junction table? A similar to B A similar to C A similar to D A similar to E ..... B similar to C B similar to D B similar to E ..... C similar to B C similar to D C similar to E ....... If I misunderstood your suggestion...

I'd already posted a new help request before readying your comment. You can have an eye on it if you're interested: https://www.access-programmers.co.uk/forums/threads/relations-between-products-similar-products.331164/

This is a branch of This thread. My case seems to be slightly different from the mentioned one. Hence, I thought a new thread may prevent over lapping comments and problems. I have a product table. Currently 48895 records. And of course increasingly in a daily basis. Some products are similar...

To prevent mixing different scenarios,, I'll explain my situation in a new thread. Thanks.

Well, I was talking about the real world I live in (my profession). I'm glad to see there are different real worlds than mine. :)

@MajP In our business, we have a problem similar to OP's, but I always was too lazy to start working on it. Now that I see you're trying to show your solution, I'd like to point something out. (Even if what your last sample database is not what I'm looking for, I thought it may give me some...

Much appreciated. I think I'm OK with my questions. Thanks.

From two unbound combo boxes in 3 different forms. The same function will be executed from different forms. Thanks.

@plog Million thanks for the correction. Works perfect. It seems that I have the answer to my first question. Now I'll be waiting to see if anyone can advice on my second question : How to open this query in vba for a different duration of dates. Thanks again

I'm receiving a Quantity Enter Parameter Value when I try to open your query. I tried to replace [Quantity] with [QuantityOfSum], I received a "Subqueries can not be used in the expression" Error. I tried to replace [Quantity] with Sum([CounterTo]-[CounterFrom]), I receive a syntax error...

I have 2 major problems with your solution. The query will be called from different forms. So I can not bind it to a specific form. Even if I go this root, the query opens without error. But when I want to access its recordset, I receive the same error. The following line gives me "Too few...

This is a part of a simplified relationship in a database. I need a query that shows Machine name, ProductNo, ProductName, ProcessNo, Count of manufactured parts and the total time used for manufacturing, during a specified date interval. The only way I could reach this result, was to write 2...

No offence but it seems that it's you who don't understand. OP is not in the navy and his client is not the most strict organization in the world. So, the reply to his question SHOULD not be navy based, and I think few people care that how navy manage their computers. You have never purchased a...

We purchased an out of box accounting solution a while back. During install process, it installed sql server express, then the main application was installed. Sql server is locked and none of our admins are able to access the database or tables. We can install another instance of server if we...

Simply turned off the auto update option. Is this enough?

I haven't updated since 2304. I really hate the height of title bar in recent updates. It takes too much space for no special reason and I couldn't find a way to change its height. Thanks for reporting this to MS.

I don't have "Sql View" in my context menu from navigation pane, no matter the mentioned option is ticked or not. (Microsoft 365)

I'm at home. Tomorrow I'll try your registry workaround and will report back. thanks.