Search results

Frankly, I didn't understand it. I'm trying to find someone to help me with the code VBA 😞

Is there another way without using dLookup() ?

yes, I know that . The problem is that I'm not the one to work on it. People will work on it, all they know is typing on the Word program

I will definitely tell them to do (TIT.db) in Section D. I will go home and any mistake no one calls me because I am with my family. :giggle: (y)

Indeed, this is what I want to present a message. I didn't use (On Error Resume Next) so I don't want to hide the message VBA but show another similar message to the user... The user doesn't understand messages VBA maybe he accidentally didn't add the target database in Partition D

You are wonderful isladogs

I think my idea did not reach. I want to hide the message vba and instead show another message stating that the target database does not exist . I can use On Error Resume Next But the message alternative is what I want

Thanks MajP the code didn't work

thank you my dear friend Gasman for replying . yes, I know that. I know it's not in section D so I removed it. What I want is . message stating that the file does not exist.

welcome all . I have a button that runs an update query and then relays the data to the db destination somewhere else. When db is not present I get an error message in (VBA) . What I want to show me another message that the interface database does not exist. Thanks for the help in advance...

Thank you very much dear @arnelgp

Ok sir, Thank you very much it worked great :giggle: (y)

Yes, I now understand what you mean by opening Access as an administrator. Yes, this option does not appear to me when I click the right mouse button. I also know the work of the shift key. But I don't see the option to open Access as administrator Now I understand what you mean:):rolleyes:

Do not delete posts. But I deleted a code that could be dangerous to the registry file. Someone from the members might try it and thus destroy their computer system Perhaps someone else thought of protecting his database through many things. But I think that you and many friends here in the...

No, I did not open Access as administrator or edit the HKCR registry hive. Frankly, I don't know how to edit the HKCR registry hive

BTW - do use a different registry key value in the ral db just in case one of your end users ever reads this thread : OK @isladogs ;) :ROFLMAO: I will ask UncleThe_Doc_Man to delete the topic permanently hahaha

To make sure that the other part of the code in the database containing the tables was accepted by the computer

Just my friend, have a look at the code. Where is the error?

Hello all I try to execute this code, but the message does not appear and confirms that the key exists. Please help. Thanks >>>AZ Private Sub Command2_Click() Dim MN As Long Dim DN As Long Dim EE As Long Dim APW1 As Variant Dim UPW2 As Variant MN = HKEY_CLASSES_ROOT EE = 1 APW1 = "003" UPW2 =...