Search results

  1. G

    Solved Calculate the last date of each current year

    Hi and thnaks for your help but, im getting error when o run the code as following Dim dtLastDate As Date dtLastDate = DateSerial(Year(Date, 12, 31)) MsgBox dtLastDate
  2. G

    Solved Calculate the last date of each current year

    Good Evening, I'm trying to figure out how to automatically calculate the last date of each current year. For example if we are in 2023 I should find the result 31/12/2023 or if we are in 2024 the result 31/12/2024 (the same result coincides) Any idea?
  3. G

    Solved Permission denied to copy

    I'm the Owner of the pc, its my personal pc
  4. G

    Solved Permission denied to copy

    Its my personal PC
  5. G

    Solved Permission denied to copy

    Yes its my personal PC
  6. G

    Solved Permission denied to copy

    Hi, i'm trying to copy from desktop to C:\Program Files (x86) using vba but i cannot because of the limited permission. I found the following code in a forum. Any idea? Public Sub CopyMasterFolder() Dim FSO As Object Dim FromPath As String Dim ToPath As String FromPath =...
  7. G

    Check dates between .txt File and DB

    Good Evening, I have two dates, date A = 01/01/2023 and date B = 12/12/2022. I would like to break into it 1. Days (ie for A =01 and B=12) 2. Months (A=01 and B=12) 3. Year (A=2023 and B=2022) The issue is There is an external .txt file which include the first date (A) and I have the B date...
  8. G

    Getting the value from another function

    its the same...the issue its not that.....The problem is how can i get this result from another public function
  9. G

    Getting the value from another function

    Hi, how can i get the value from another public function in the following example? Public Function GetValuesFromForm() As Boolean Dim X As String Dim y As String If 100+10=110 then x=True Else x=False End if GetValuesFromForm=X y=GetValuesFromForm() End Function I tried into another...
  10. G

    Refer to X String from another public function or form

    wHERE YOU WAS ALL THIS TIME?? :-)) THANKS A LOT
  11. G

    Refer to X String from another public function or form

    Already are split...! I just want to refer to just one String of them from another form, routine or function...! How?
  12. G

    Refer to X String from another public function or form

    As I suspected, I probably haven't made it clear what the problem is From an external server in the company, I receive data as a string from a Postgres table. I get this data through a service (java scripts) and it is in real time. I call the service through a module (ReadServerData) and I get...
  13. G

    Refer to X String from another public function or form

    because i'm getting values bu running external service from Postgres
  14. G

    Refer to X String from another public function or form

    Make it Global or a TempVar How can i do it Global? Its about 30 fields..so i thing TempVar for each maybe its not good idea
  15. G

    Refer to X String from another public function or form

    I have a Public Function like the example below. X is a String inside the function and takes value from a field in a form. The question is how can I refer to String X through another function or through a another form? I want to use another function to refer to the result of X in...
  16. G

    Strange problem with equation inside vba module

    Yes, i changed them as following x = 495 / (1.29579 - 0.35004 * (Log(Wst + Hps - Nec) / Log(10)) + 0.221 * (Log(167) / Log(10))) - 450 which Wst As Integer [Waist]=87 Hps As Integer [Hips]=97 and Nec As Integer [Neck]=32
  17. G

    Strange problem with equation inside vba module

    Good morning, the problem was solved simply by changing the string fields to Integer as numeric and now it is correct. However, to be honest, I have never encountered anything similar in my 10 years of experience with access In any case, thanks for the interest
  18. G

    Strange problem with equation inside vba module

    Any idea theDBguy
  19. G

    Strange problem with equation inside vba module

    if i put directly the numbers of 87 + 97 - 32 the result is correct 33,73
  20. G

    Strange problem with equation inside vba module

    Hi CarlettoFed and thanks. You are right with your modification i get the correct result but, the original equation is x = 495 / (1.29579 - 0.35004 * (Log(Wst + Hps - Nec) / Log(10)) + 0.221 * (Log(167) / Log(10))) - 450 which Wst is a string from field [Waist]=87 Hps is a string from field...
Back
Top Bottom