Search results

  1. K

    Hide System Tables When Connecting To SQL Server

    A question if you don’t mind. I assume after reconstruction of the password, you should relink the tables too. Am I correct? If yes, then the password can be extracted from An external database by reading the connect string of linked tables. Isn’t that so? Thanks.
  2. K

    Solved Relations between products : Similar Products.

    “Alignment” in our language has too many meanings. I don’t understand what your exact question is. Can you narrow you question? thanks
  3. K

    Solved Relations between products : Similar Products.

    @CJ_London thanks for the details.
  4. K

    Solved Relations between products : Similar Products.

    Never thought of this method. Will give it a try to see if I can replicate it. Don't understand why you need A,A B,A With your explanation, I think having only A (Parent PK) in this additional field is enough and can be used to filter all records that are similar. For example SELECT ProductName...
  5. K

    Solved Relations between products : Similar Products.

    I think we're going in circles. Please see my previous reply. Not everything can be categorized into limited groups. thanks.
  6. K

    Solved Relations between products : Similar Products.

    Similarity is different in different businesses. In a business a pen holder may be similar to a speaker case. The main problem is that, we think within our limited knowledge and it's strange for us to see something outside of the circle. As I said, there's no rule in the similarity between the...
  7. K

    Solved Relations between products : Similar Products.

    @MajP Million thanks for the time you put on this. Last weekend, after I posted the above help request, I came out with a solution that works ( I assume). You may want to see the attached database for a variation that does the same task, but simpler (Maybe) By simpler, I mean if you have 10...
  8. K

    Solved Relations between products : Similar Products.

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

    Solved Relations between products : Similar Products.

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

    Solved Relations between products : Similar Products.

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

    Correlation between two records of the same table

    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/
  12. K

    Solved Relations between products : Similar Products.

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

    Correlation between two records of the same table

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

    Correlation between two records of the same table

    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. :)
  15. K

    Correlation between two records of the same table

    @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...
  16. K

    Solved Need some advice on a Total query

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

    Solved Need some advice on a Total query

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

    Solved Need some advice on a Total query

    @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
  19. K

    Solved Need some advice on a Total query

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

    Solved Need some advice on a Total query

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