Search results

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

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

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

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

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.

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

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

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

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!

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

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

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!

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

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

I was watching this, but I'm from Spain, and here the week begins on monday. I couldn't manage to change that. Not critical, but enough to try another way. I guess I'll give it a second look.

Magnificent link, MajP. Thank you very much. It's the kind of tutorials I really enjoy learning from, as you say easy to understand. About that, I do have already a date picker, but I don't know how to proceed from here. I mean, in that form, if I pick a date, it's inserted in the text field...

Hi there, guys. I have a form with several fields from a table. One of them is the date. I'd like to populate this form by clicking in the date control and picking a date from the calendar picker. If the record exists, the form is filled with the data and the operator is able to update the...

¡Buena suerte y mucho ánimo con las lecciones de español! I like Barcelona, but it's full of pickpockets. Be aware! I'm amazed with your blog, I just finished to read the excel entry. Wow, man. It's been mindblowing. It's speaking about ME right now. I have two main tasks in my factory...

Nice place, Rota. My father is from La Línea. Cadiz is one the best regions to live in Spain, fantastic people, so funny and the best of gastronomy. Many thanks to everybody for the warm welcome.