Recent content by biofaku

  1. B

    Creating a query to find differences

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

    Creating a query to find differences

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

    Creating a query to find differences

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

    Error #5 after compact and repairing

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

    Error #5 after compact and repairing

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

    Error #5 after compact and repairing

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

    Error #5 after compact and repairing

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

    Error #5 after compact and repairing

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

    Error #5 after compact and repairing

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

    Error #5 after compact and repairing

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

    Error #5 after compact and repairing

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

    Making reference to a group object and using it on a subform

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

    Making reference to a group object and using it on a subform

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

    Is Access the right solution?

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

    Designing a batch production record database

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