Search results

Oh yes! That worked perfectly. Never thought that! Thanks Pat!

Hey Pat, it's me again. Just wondering something, if you with the batch scheme you shared you had wanted to make a comparison of the performance for each step between all the batches, how would you do it? I was trying to do something like that, filtering through the Process FK and the Step FK...

Yes, the process it's really complex to explain it, only by analyzing it a lot I'm starting to come with a relational map, but it's taking more effort than I thought it could.

I'm glad you said that the app added empty records for the steps, because that is what I was thinking you made. It's the only doable approach I found. Although is gonna be a lot of coding to let the app know when add an specific set of steps for a batch. Now I'm kinda stuck with a prior part...

Oh, I guess you are having quite a trip over the memory lane :) Thanks for the tips, it's really helping me!

Oh, if you had a sample without data, just the basic layout would be fantastic, Im somewhat puzzled and wanted to see how you tracked the actual columns of that batch card. Its like the lack of a solid work structure that I have found here it's what it's making it harder to define all the...

Oh, its great then, now I think it's possible to do what I was trying, even if the manufacturing process do vary a lot from one product to another. Thanks Pat, your help it has been really useful.

I think you have sparked something for me with that image you added. Just to be curious, the "actual" column was to be filled manually (on pen) or it could be completed on access too? What I'm looking is to track for every batch of the different products those values, but have in mind that for...

It's mostly something like that, on a related Industry also (pharma). Here they are not giving so much thought to the ingredients (for now at least, I already see them coming asking for that too!), but for now they are looking more to each step on the process and all the recorded variables. So...

I'm sailing on a travel that I think I'm not experienced enough to do, so I came here expecting some guidance because after a lot of research on internet, came with few ideas. I have been tasked with developing a database to track the production history of different items. The main problem is...

Lately I came for you looking for help and then even before you post something an idea comes to my head that mostly solves a problem that has been bugging me for hours. This forum is magical.

Oh, yes, I know its seems non-normalized, but I made it that way because those fields are reserved for people that are leading a project and at the moment. The thing is that some times the same name can appear on field 1 or others on field 2, I was looking for a way to see every register that...

Hi, I have a Table that has two fields that can contain similar data. Let's call them "Name 1" and "Name 2". I was thinking on making a Query that search for a name on either of those two fields, but I can't make it work. The closest I came to achieving this was using this expression Expr1...

Just to update it, I solved the problem I was having, but ended doing it by populating a text box with the results from a query instead of using a subreport.

Im using onload

Hi, I am having some trouble with coding a reference to a textbox on the footer. I just want the textbox to display any text that is between "" When I load the main report. The code is something like this Me.rpt_subrelind.txt_srobs = "text" But it keeps giving different errors like: 438 But...

Oh, I see the problem, thanks DBguy, I think I can go alone from here!

Yeah, I'm using this to check the code before using in the real db. thanks In advance

Still, it's giving me error 13, I tried it on an empty database query but it still is giving error 13.

I just did it and its giving me error 13. I tried writing numbers directly but it's also giving me error 13