Search results

  1. G

    Bring To Front & Send Back Properties using VBA

    Good Evening In the database I am attaching there is the form Form1 on which there are several fields with hours. The request is to be able to define the Properties Bring To Front & Send Back via VBA when and if I click on the Text0 field. I am providing an example of the request and I will...
  2. G

    Load Web Calendar into an access form

    Hi, Is there any possibility to load a web calendar within an access form with the possibility the data being entered into table? Thanks in advance
  3. G

    Sync the Scroll Bar between subforms

    Good morning, i Ιs there a way to synchronize the forms scrolling bar between them? For example when I scroll in any of the 3 forms to do the same? I attached a sample db in order to understand exactly Thanks
  4. G

    First Date of the Week

    Hi, how can find each first date of the current week using vba? For example today is 25/03/2023 i need to take the result of 20/03/2023
  5. G

    Split date in day, month and year inside query

    I need a query so to split the date 18/01/2023 to day=18 , month=01 and year=2023 within query. Can anyone help?
  6. G

    Fill the listbox only with file name

    Hi, I found the following code here in the our forum (special thanks to the writer thedbguy) buti'm trying to modify them in order to fill the Listbox only with file name without the path. Following is the code and i will be glad if someone can explain to me how can i do it. Public Function...
  7. G

    Error in a line of vba code

    Hello, I'm trying to create a function so to copy from master folder another subfolder into C:\Program Files (x86) but i have some errors. First of all following is the function Public Function CopyFolderAndSetPermissions(ByVal sourceFolder As String, ByVal targetFolder As String, ByVal...
  8. G

    C:\Program Files (x86)\MyApp full permission using vba

    Hi, is there a way to give full permission to my C:\Program Files (x86)\MyApp full permission using vba? I'm asking this because i don't want the user to see what i'm doing during the installation on PC thanks
  9. 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?
  10. 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 =...
  11. 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...
  12. 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...
  13. 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...
  14. G

    Strange problem with equation inside vba module

    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 *...
  15. G

    Running vba code external file

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

    DCount with True/False criteria

    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)
  17. G

    Public Const

    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 =...
  18. G

    New IE (internet explorer)

    Hi, Does anyone know if the new internet explorer (IE) control is ready to use into Ms Access applications? If so, can i use it within my Ms Access Pro Plus 2016 version or i must upgrade my pack to newest? Thanks
  19. G

    Change Regional Settings Language

    Hi, is it possible to change the administrative system language using vba? Attached is the photo on exactly what i mean
  20. G

    Enable Macro and ActiveX settings

    Hi all Is there a way to enable the Macro settings and ActiveX in Ms Access using vba? Thanks in advance
Top Bottom