Search results

  1. P

    Attack on Israel

    GIVE BACK THE HOSTAGES!!!!!!!!!!!!!!!!!!!!!!!!!!!! DUH!!!!!!!!!!!!!!!!!!!!!! STOP LOBBING BOMBS AT ISRAELI CIVILIANS!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! DUH!!!!!!!!!!!!!!!!! DISARM!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! DUH!!!!!!!!!!!!!!!!!!! STOP TRYING TO KILL ALL THE JEWS...
  2. P

    Attack on Israel

    Why are you always 100% ready to believe the worst of Israel but you cannot see at all what the terrorists do to Israeli citizens and even to their own citizens? This reeks of antisemitism. Review your history. Try not to use Wikipedia. WHEN in all of human history has the attacked country...
  3. P

    Solved Changed relationships has stopped a form working

    It is helpful for those who find this thread later to describe your solution. To handle the change in relationships, you should use a subform for the new m-m relationship and the main form for the original single table.
  4. P

    Solved Changed relationships has stopped a form working

    Usually it is called a junction table because it "joins" two 1-m relationships. There is no natural way to create a m-m relationship.
  5. P

    Solved Changed relationships has stopped a form working

    correct but each side of it is 1-m and it can produce many records which will be multiplied by the number of records produced by the other 1-m join. So if join 1 produces 3 records and join 2 produces 2 records, the resultset will be 5 6 records. Sorry, corrected typo.
  6. P

    Open a form and insert data SQL

    Nope. The best way is to use validation to ensure that all required data is entered. Make sure you set the required property to yes at the table level and leave the default as null (NOT zero) unless you actually have a specific default. Also make sure that allow Zero Length strings is set to...
  7. P

    Solved How to include line sequence in MS Access Line details table

    Generating empty records is just plain wrong and if you had proper validation would fail. Here is a sample that shows how to generate two types of sequence numbers. It also included code to renumber simple sequences. You need to define in your mind whether this is just a visual or if you need...
  8. P

    Open a form and insert data SQL

    Dirtying a record with code before a user types anything into the new record will almost certainly lead to bad data being saved. Since the defaults are fixed, just add them to the table so they are applied to new records. OR add them to the form controls. If you must write unnecessary code...
  9. P

    Attack on Israel

    I can't wait to hear your answer. Then we can discuss the actual meaning of terrorist.
  10. P

    Off Topic

    And they weren't trying to get the crowd to riot.
  11. P

    Attack on Israel

    Read the ENTIRE sentence. That is how English works or are you changing that also? If you answer YES to that question, then I called you something.
  12. P

    Solved Changed relationships has stopped a form working

    Not according to the schema.
  13. P

    Attack on Israel

    I didn't call you anything. You need to read the entire sentence. Did those women deserve the atrocity that was levied on them? Come on, defend the terrorists for us. Tell us why attacking a music festival where there wasn't a soldier in sight was right and good because the Jews deserved it...
  14. P

    Solved Changed relationships has stopped a form working

    It has two parallel relationships. The tables in the query are not hierarchal since each of the 1-m relationships can produce more than one row, the query is a Cartesian Product. The third relationship is a "lookup" so that isn't a problem.
  15. P

    Off Topic

    Looks like a bunch of crazed rioters too me but I don't see any boxes of Nike's or burning cop cars.
  16. P

    Attack on Israel

    Ignorance is bliss. Don't ever take your head out of you know where. I find it terrifying that you are so committed to a lie that you don't know that the Israelis left Gaza more than 20 years ago. They even dug up their dead so the Palestinians couldn't desecrate their graves because that's...
  17. P

    Attack on Israel

    Apparently, terrorist is yet another word that the left has coopted. Only whites can be racists and now only Jews can be terrorists. Please don't open your eyes to see what Hamas actually did on Oct 7th - from their very own video BTW, you might have to change your opinion unless of course you...
  18. P

    Attack on Israel

    You really need to get up to speed with reality and real history. Palestine has been independent from Israel since 2004!!! That is more than 20 years. And what have they done with all the billions given to them in aid and cash? They have bought bombs to drop on playgrounds and schools to...
  19. P

    Trump Administration Predictions

    You live in la la land. Let's start with cancelling the President of the United States of America. When that didn't work, you tried to kill him.
  20. P

    Solved Query if Between lower and upper to return lower, returning all records

    No. In one case the join is on MyUCA and in the other it is on Marital Status. The two queries are incorrect. The joins are wrong and you shouldn't have two joins to the same table on different columns. The second query is probably not needed if you fix the first query AND include the...
Back
Top Bottom