Search results

Yay! thanks! @@identity worked just like that, I thought that it was gonna take something more because I was expecting to need to give it more instructions than that, but it was just that easy. Thanks to all! :D

Thanks to all, I have been working with those functions but with no success so far. Can anyone share a more detailed example of how should I implement it? Thanks again

Gonna take a look at that Thank you very much Minty!

Hi GPGeorge! Yes, I supposed that something like that was happening, thanks for confirming it. What we finally did was updating first and then moving to .lastmodified, I think is working but Im worried that sometimes might come with wrong values for PK

Hi cheekybuddha! By doing that I now get the value of PK from the first record of the table but not the value of the PK of the record that I was just adding. Thanks for your idea :D

Hello there! I am moving the backend of my access db to SQL Server and I found an issue that Im not able to solve. When I run this code: Dim db As DAO.Database Dim rs As DAO.Recordset Dim rs2 As DAO.Recordset Dim Form As Integer Set db = CurrentDb Set rs =...

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.