Recent content by HectorGips

  1. H

    How should I change my tables design on this project?

    Many thanks for the explanation, it's more clear now. About that, this how we do now: this spreadsheet is filled by the production manager with the production parameters, printed, and given to the operator. According to the production parameters (blue cells), the worker make the expected...
  2. H

    How should I change my tables design on this project?

    Sorry for my english, it sounds better inside my head. For that I mean where to store the work order info regarding the workers. For every work order I have to attach 1, 2 or 3 workers, and that data needs to be stored somewhere, but I'm not sure where. That's what I tried to do in my previous...
  3. H

    Sure thing, Mike. Already done!

    Sure thing, Mike. Already done!
  4. H

    How should I change my tables design on this project?

    Many thanks for your post. Too much useful info! I'm focused now in the table design part, I'll save your code help for later. Just knowing that it can be done is enough for me now. So regarding this, I think I don't see where store the operators data and why I need to duplicate the work order...
  5. H

    How should I change my tables design on this project?

    Hola de nuevo, guys. I'm at learning process right now. I have a quick question, I'm stuck at some point. I'm trying to adapt the lessons I'm reading to my db from zero. First on paper, having in mind normalization, etc. And there is something that I don't understand and I don't want to...
  6. H

    How should I change my tables design on this project?

    Thanks for the advices. That's my goal, but it's not being easy. That northwind template is clarifying things, but for every solved question, 10 more turn out. I'll come back with my advance asap.
  7. H

    How should I change my tables design on this project?

    Many thanks, so interesting link. It'll be so useful to me.
  8. H

    How should I change my tables design on this project?

    Agree with you. I'm the maintenance manager, and my bosses, knowing that I manage myself with I.T. stuff, asked me about preparing something for record the production process. It's a huge task, but luckily the sales, logistics, etc, aren't involved. Just the manufacturing itself. Raw product...
  9. H

    How should I change my tables design on this project?

    Buenos días to everybody. I'm preparing a db for the production department of my factory, it's an aggregates and gravel factory. Its progress it's now over 75%, but I'm beginning to think that I missed the table design and I'm in time yet to change it. So: -In the factory there are four...
  10. H

    Populate form from date control

    Crystal clear now... So easy again... My next step has to be to learn a little bit (or quite a bit) about this character and "grammar" stuff. Otherwise I'll waste too much time in things like this, a missing quote, a colon or semicolon or whatever. Many thanks for the explanation!
  11. H

    Populate form from date control

    Well, I managed to solve it somehow... I have changed this: strFind = "IdDate = #" & Format(Me.txtIdDate, "MM/DD/YYYY") & "# AND Turno = " & Me.cmboTurno to this: strFind = "IdDate = #" & Format(Me.txtIdDate, "MM/DD/YYYY") & "# AND Turno = " & Chr(34) & Me.cmboTurno & Chr(34) The thing is...
  12. H

    Populate form from date control

    Hi there! It's giving me trouble with the data type after I adapted it to my db. For the shifts, we use letters instead of numbers (M for morning, T for evening, N for night). I made a combo with this letters, and when I run a search it gives me the error 3070, so it's something related to the...
  13. H

    Populate form from date control

    Amazing, MajP. That's just what I need, and so easy to implement. I'm going to adapt your solution to my db, and I'll let you know about the results as soon as posible so we can set the thread as solved. Many thanks!
  14. H

    Populate form from date control

    Works perfecto, man. But I don't manage to understand how it works without a query. Just by referencing in the form that the data origin is the table? No macros, no queries? I need it to advise if a day record is not present, like a day off or a sunday when a production order wasn't made. And...
  15. H

    Populate form from date control

    Sure. The process is this: - The factory manager creates a production order for each day of a week. This creates a new record in the db for each day. It has empty fields so some production data has to be obtained from the production process. - The operator, once every production workday has...
Top Bottom