Search results

Thanks everyone for the input! bastanu that worked perfectly! Thanks a lot!

Hi plog, thanks for your input. I'm sorry if I have not expressed myself well, and I think the example was confusing because I used numbers on the column Item. What I'm trying to do is a query that gets the values on the column Item that are not in common with the Client column. The value on...

Hi, I'm trying to create a query that allows me to find the differences between values inside a same table. Let's suppose I have this table: Client Item A 1 A 2 A 3 B 1 B 2 B 4 The query should return only these results: Client Item A 3 B 4 I tried using WHERE NOT IN...

Yes, I have compiled it, but it doesn't show any error at all right now. Nevertheless, if I click compact and repair, it messes all.

I don't know, I think if that was a solution, the code should work on a different pc, right? Or maybe because the references are messed up on this PC then are messed on any other PC? By the way, the error just prompted without clicking compact & repair... But I had a good amount of crashes on...

I tried that, but after all, it ended up the same. Removed all the references except visual basic for applications and Microsoft access 16.0 Object Library. After saving, exiting vba editor and access, then opening all again and reinstating the references, the error persisted. No reference was...

It depends, on some cases the code works just fine. On others it looks to another problem that should not appear, like this: Set drs = Me.Recordset Giving me error 13. Again, this code worked perfectly before compact & repair

Hi Isaac. I am thinking this is a case of corruption because before using "compact and repairing" the client worked as intended. It was only after compacting and repairing that the error started appearing. It's not on one specific line, it's on every line that includes a select case, more...

Well, tried to compile, recompile but still the error is happening. If I use a backup and copy all the content doesn't happen... But At the moment that I press compact and repair, it just goes all over again giving me error 5 for the most dumb select case you can find. It even happens with...

Thanks guys, gonna check those links and come back to tell you how went

Hi, I just found an error on my db and was looking for some advice. I was working on my forms, looking to improve some things, when by mere accident I clicked the compact & repair button. After that, the welcome form started giving me error #5. Looking through, the problem was the Select case...

Oh, I forgot to mention that the subreport is based on a crosstab query. arnelgp, when I linked master/child fileds it showed me this error "You can't use a pass through query or a non-fixed column" Edit: Just sorted it out, I needed to add the columns names on the query, didn't knew that one...

I am making a report that has it's results filtered using groups. I was trying to use the value from the textbox on the group's header to filter a subreport that is attached on the group's footer. The script was wrote on the Onload event of the subreport, and worked on the report's view, but...

Maybe using Access but storing the data on SQL Server? Then you could pick up the data from power apps too. If you need to validate that flow of work it might be a headache, but it could work. I tried something like that with Sharepoint, and worked almost perfectly.

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