Search results

The correct result is 33,7396 in master excel file with absolutely same equation. I access i get 292,677014..!!!

Good evening I am facing a problem which is really strange and I hope someone to give the answer. Within a VBA Module I have several equations some of them are simple and some more complex. Specifically, I have the following equation: X= 495 / (1.29579 - 0.35004 * (Log(87 + 97 - 32)) + 0.221 *...

Thanks but i think you didn't got the message.! I know all the above you said and i agree but, 1. The database yes it can be downloaded and includes a run setup file. Actually now we have the version 1.0 running on more of 138 users 2. Yes, already the application read parameters from external...

It's not a good idea because of security issues my friend..! The application can be downloaded from users

Good morning, I have an accdb file that will be distributed to some users, In this file there are some parameters (inside the code ) that will change in the future such as Paths, URLs, static IP and others. I would like to find a way so these vba modules to be in some external files so when the...

Could you please give me a sample on how can I do iti ?

I cannot because I don't want anyone can modify the code etc...

Actually I exported all modules from my accdb file into Notepad++ converting them in vba and what I want is after the creation of accde file I need to rum the codes via Notepad++ files

Yes I know that's why I m looking a way to run the code via external file

I hace an accde file and i want to modify the code

Hello, Is it possible to run a vba code from an external file instead of from Access? Thanks in advance

Thanks

Hi, Just a question, How can I write correct the following function below to count only the records which the field [Active]=True? a = DCount("[Patient_id]", "Patient Diseases", "[Patient_id] =" & Forms!MainForm.LogCustID)

Because of poor knowledge of vba programming, could you please give me a quick module solution example on how can i write it correct?

Thank you very much

Basically I try to keep the customer number in memory so that I don't have to mention it in every form like Forms!MainForm.Log|CustID

I want to keep the Customer ID each time i change it

The MainForm is always opened

First of all thank you very much, but, is that possible to be done using my code?

Hi, Just a quick question, in order to hold the How can i write the Public Const Function in order to keep each time the new [LogCustID] from the MainForm? Already i tried the following without results Option Compare Database Option Explicit Public Const cLoggedCustID As String =...