Recent content by Noruen

  1. N

    Can't figure out proper junction(?) table structure to connect 3 tables with different relationships

    @plog interesting idea! However as some Events are simply not related to any LogBook, it means no Car involved… but it is worth a thought. @Pat Hartman i agree! But can you more clearly describe how would you change/propose my design? It may be completely fucked up, thats why I'm here.
  2. N

    Can't figure out proper junction(?) table structure to connect 3 tables with different relationships

    @cheekybuddha they are, but consider you have many Transactions in Event but also many LogBook records in Event. How do I know which transaction belongs to which LogBook record? @Pat Hartman TransactionID_FK in LogBook do not allow to assign many transactions to one LogBook record. So this is...
  3. N

    Can't figure out proper junction(?) table structure to connect 3 tables with different relationships

    That won't work as then I would not know to exactly what transaction LogBook record belogs to.
  4. N

    Can't figure out proper junction(?) table structure to connect 3 tables with different relationships

    LogBook contains CarID, Odometer value, Destination and other attributes. For example I can put Fuel costs as Transaction and link them with LogBook record. And in discussed cenario, to also link both Trans-LogBook to Event “Vacation” for example. So that is the difference. I will try to put...
  5. N

    Can't figure out proper junction(?) table structure to connect 3 tables with different relationships

    Hi! another year, another problem :) I have three tables related to this issue: - Transactions - LogBook - Events Now: - Each Transaction can belong to just one Event - Each LogBook can belong to just one Event - Each Event can have many Transactions and many LogBook records assigned -...
  6. N

    Passed Form's property "gone empty" between Property LET and GET

    @ebs17 Thanks! you saved me! So the problem is the property is not immediately available after the form loads. I tested your approach and it work now. Amazing, thanks a lot!
  7. N

    Passed Form's property "gone empty" between Property LET and GET

    @arnelgp sure, but I know that when I pass frm.OpenArgsAlt = “something”, new instance will get that value in LET property, however after that it is lost, for some reason :/
  8. N

    Passed Form's property "gone empty" between Property LET and GET

    @arnelgp o_O so simple... and I spent half a day trying to solve it... Thanks! Anyway... do you have any idea why code above didn't work?
  9. N

    Passed Form's property "gone empty" between Property LET and GET

    Sure! I have forms that i use to search IDs for another form. Like Search Category, Search Vendor, etc. Now I use DoCmd.OpenForm ... , "Field:cboCategoryID;Form:frmExampleForm" (OpenArgs): i parse OpenArgs string to use target form and field to pass searched value, like...
  10. N

    Passed Form's property "gone empty" between Property LET and GET

    Hi! I'm trying to create by-pass of OpenArgs for my form as I want to use form instances and OpenArgs is read-only + new instances cannot be created using DoCmd.OpenForm. I have read through various forums how to pass this alternative OpenArgs to new form instance so I created in Form's module...
  11. N

    Denormalized database: update adjacent records

    Thanks a lot @MajP ! I see this is probably only solution, really. I was thinking a lot about @Pat Hartman 's idea to do it in Report, but it is convenient for just monthly report. I will download your example and analyze it. Anyway thanks again for your time! :)
  12. N

    Denormalized database: update adjacent records

    Ah, I will try to answer all of your questions :) 1) @MajP I have currently up to 20 k records but it increases every month by approx. 100. 2) @Pat Hartman I know it is bad so that is the reason I'm trying to find another solution, but... 2b) @Pat Hartman each record has also another columen...
  13. N

    Denormalized database: update adjacent records

    Yes, I also imdexed Odometer and it helped a little. Mentioned query is correlated. SELECT current.Odometer - (SELECT Max(previous.Odometer) FROM tblLog As previous WHERE previous.Car_id = current.Car_id AND prevoius.Odometer <...
  14. N

    Denormalized database: update adjacent records

    Hi gentlemens, I suppose you will kill me for question regarding denormalized DB, but only you can help me. I have table where I store Car log book: id Date car_id Odometer (absolute value) 1 12.10.2022 1 10 000 etc Now, as is probably evident, I store odometer values as absolute...
Top Bottom