Search results

  1. R

    Using a "frozen" recordsert?

    Because it is real. These numbers correspond to real places, and it is necessary to know whether it is full or empty. The samples are identical, but you have to be able to distinguish between the one at 1 or at 3. That the samples are identical is not so strange, if you think of any mass...
  2. R

    Using a "frozen" recordsert?

    Thank you very much for your comprehensive reply, I really appreciate the time you have taken. I had no preconceived ideas on how to fix this. I considered that solution because I thought the ones you mention (form with subform) wouldn't give the desired result (= I did not know how to do it...
  3. R

    Using a "frozen" recordsert?

    Thanks MajP. I read the chat "Close form without record?" As far as I understood, the BeforeUpdate event is used to validate only a record. Regarding the transaction method, well, I agree with you, it could work but I would like to try something easier, even reducing the features for the user...
  4. R

    Using a "frozen" recordsert?

    I am sorry if I did not make myself clear. That code you wrote is for avoiding to add more than five samples, but that point should be already solved when open the form, with a recordsource of the 5 samples fitting the contitions. There will be no posibility to add a 6th sample.
  5. R

    Using a "frozen" recordsert?

    arnelgp, thanks for your suggestion of using transactions. I don't know much about it, I am now looking for how to use it. In principle it is about to execute at the same time two SQL queries? (like in a currency transaction). But here I have only one at a time, Insert or Delete. What I do not...
  6. R

    Using a "frozen" recordsert?

    Thanks for your reply. Then you suggest that I must control the SampleNumber in BeforeUpdate event in the form. Whit this I can limit the record source of the form and avoid wrong additions, but I cannot see how to avoid to update the table with the right additions.
  7. R

    Using a "frozen" recordsert?

    Sorry, when IDNumber = X, I meant IDSample = X
  8. R

    Using a "frozen" recordsert?

    For a serie of some limitations among some fields in records (=samples) in a table called TbSamples, I need to insert the samples inside in groups of five, not one at each time, but all the empty samples inside that group. I can select the empty samples in TbSamples in a group of five with some...
  9. R

    Right design to avoid duplicate table almost identical

    Hi Gemma, thank you for your remarks: "One question first, are coins homogenous, or are they distinct" - All coins are distinct and unique. I need to know specifically where each coin is. Inside TbCoins there will be fields to make each coin unique. "Can a coin be loose, or is it always...
  10. R

    Right design to avoid duplicate table almost identical

    Ok, thanks! I will do it that way, only needed to add some fields in TbBox and not duplicate a whole table for coins. Thank you very much again.
  11. R

    Right design to avoid duplicate table almost identical

    No problem, thank you anyway.
  12. R

    Right design to avoid duplicate table almost identical

    You are very fast answering!! Thanks a lot! Isladogs, sorry if this not the best way, but let's say that to provide my actual project would be difficult... Plog, thanks for your answer. You suggest to put all the coins which are not in a box in a fake box? Only in one fake box? But then that...
  13. R

    Right design to avoid duplicate table almost identical

    Hi, Before creating a database that I think it will be complicated I have a question about design and normalization. Please let me explain it with a simple example. I hope it is not too naive for you. Here we go: I keep coins in suitcases inside several rooms. For this distribution the tables...
  14. R

    SELECT...WHERE from SQL to VBA

    Ok, the rowsource for Combo 2 is in AfterUpdate in Combo 14. Now it works! This part is solved, thank you very much!! Fast and straight to the problem.
  15. R

    SELECT...WHERE from SQL to VBA

    Sorry, in the After_Update event of Combo14 should I put what? Refresh Combo2? All the code is in the Click event in one Button in the same Form. The RowSource of combo2 is in a simple query (the previous SQL). After some actions in the database (too long to explain), the rowsource has been...
  16. R

    SELECT...WHERE from SQL to VBA

    OK!! The code works great, thanks! Now the SQL sentence is correct! THANKS! But now I have a different problem. This code will be in a buttom in the Form, and when I click the code starts, but the combo 14 is empty (which is right); so combo2 is empty too. If before clicking in the buttom, I...
  17. R

    SELECT...WHERE from SQL to VBA

    Sorry, my fault when copying. Actually there are no space: MySql = "SELECT TABLE.IDName, TABLE.Surname FROM TABLE " & _ "WHERE TABLE.Surname = '" & Me.Combo148 & "*' " & _ "ORDER BY TABLE.Surname" & ";" In summary, If Combo14 is empty: Combo2: A123, A145, B222, etc. If Combo 14 has, e.g: "B"...
  18. R

    SELECT...WHERE from SQL to VBA

    In the Immediate Window: SELECT TABLE.IDName, TABLE.Surname FROM TABLE WHERE TABLE.Surname = '*' ORDER BY TABLE.Surname;
  19. R

    SELECT...WHERE from SQL to VBA

    Hi Minty, thanks , but it does not work. This is what I wrote: MySql = "SELECT TABLE.IDName, TABLE.Surname FROM TABLE " & _ "WHERE TABLE.Surname = ' " & Me.Combo14 & " * ' " & _ "ORDER BY TABLE.Surname" & ";" And then, what I need is to change the RowSource of combo 2: Me.Combo2.RowSource =...
  20. R

    SELECT...WHERE from SQL to VBA

    Sorry, but yes, I need it (I just posted the key problem, this is part of something bigger). Anyway, could you write that SQL in VBA? Is it possible?
Top Bottom