Recent content by Accessing

I'm not sure, but I think that he means that you could do a joined query instead of a table to avoid using Lookup. When you set a recordset variable it doesn't need to be a table, it can be an SQL instruction as well. So, for instance, you could do: Set rs3 = db.OpenRecordset("SELECT...

I believe you have to do the following: 1) Open the subforms and make both subs (Form_AfterDelConfirm and Form_BeforeUpdate) PUBLIC subs. If you don't make them public you can't call them from another form, not even if you include them as subforms there. 2) Get the proper name of the child...

I'm sorry, I didn't state what I wanted to do because I didn't think it mattered much. The fact was, I couldn't do anything, since I couldn't get the dll to work at all. I found out that the dll that people used wasn't the one distributed with 7-zip, but a custom dll that you can download in a...

So I'm trying to use the 7-zip32.dll to perform operations on files from Access rather than through the command line. But I can't get it to work, no matter what I try. The error is always the same: Run-time error '453': Can't find DLL entry point SevenZipOpenArchive in 7-zip32.dll This is the...

I realize that this is an old post and all, but this is still one of the first results when you search Google on how to do this and I came to an answer that satisfied me through this thread. I used the function in that link from rosettacode.org that pr2-eugin posted and tested it; seems to...