Search results

  1. I

    Filter combobox based on the last end point

    It was on the "IDs" form. Could you please help me on this. I only wanted to filter the last end IDs based on the query "QueryCasID subform" on my form. Ex. if i choose ID "2000", the query will filter on the "Input.Start" field the value of ID 2100, since this is the last point of ID 2000...
  2. I

    Filter combobox based on the last end point

    anyone could help me on this. Thanks!
  3. I

    Filter combobox based on the last end point

    Hello, Good day. I have a table which has a "Start" and "End" fields, and i made a query based on this fields which continues to look up the next points until the last end points. I wanted to filter the last end points on the query table that was related on the combobox value. Anyone could...
  4. I

    Get Folder File List

    Thanks for the code, i will try it. Actually i wanted to list down all files located in my folder, then try to open it when doubled click. What will i add if i wanted to open when double click it? br,
  5. I

    Open Ms Access from Google Earth

    it works fine now. How to have a mark or point when it goes to the long/lat?
  6. I

    Excel VBA to Access VBA

    anybody could help me on this. thanks a lot.
  7. I

    Excel VBA to Access VBA

    It it correct. The flow should be like this, first search the first item in the input table which is ID 2100 will be search @ FE field, (found @ item 4) the adjacent NE is 2002, then this 2002 will be used to search @ FE field (found @ item 3 and 5), this 2 item will be search also @ FE field...
  8. I

    Count Distinct Values in a Table

    anyone help me on this.. Thanks!
  9. I

    Count Distinct Values in a Table

    I have 3 tables in it, i only want to compute an output based on table "Input", the output is in the table "Output". the logic is this, - in table "Input", i have two fields "NE" and "FE". - there is no duplicate ID @ field "NE" - @ field "NE" first lookup the records in field "FE", and record...
  10. I

    Count Distinct Values in a Table

    Actually, my data is like a highway, on some points they meet on a certain points but different paths and also will be on the same highway, that's why I wanted to know each unique points. It is possible to have it as a vba and collects all unique values on each fields and have it in on one text...
  11. I

    Excel VBA to Access VBA

    I attached my access data. I have 3 tables in it, i only want to compute an output based on table "Input", the output is in the table "Output". the logic is this, - in table "Input", i have two fields "NE" and "FE". - there is no duplicate ID @ field "NE" - @ field "NE" first lookup the...
  12. I

    Excel VBA to Access VBA

    Nice to hear that. thanks a lot.
  13. I

    Open Ms Access from Google Earth

    button name "btn_fly_contracts" after clicking it will eventually goes to the long/lat (slowly showing in the GE webbrowser) then it stop and gives the error.
  14. I

    Excel VBA to Access VBA

    I just thought if it is the same as excel. I'm just trying to edit some codes in excel to be on access vba, but unable to do it. That's why maybe it wont work. could you help me how should i work with the fields in the access?
  15. I

    Count Distinct Values in a Table

    Dears, I have a table that consist of 20 fields from a query, i would like to show the unique values from all fields in a text inside the form. And also count that unique values in another text in the same form. How will i do it? br, ivan
  16. I

    Excel VBA to Access VBA

    Actually i wanted to know the size of the array per table field in the access table.
  17. I

    Excel VBA to Access VBA

    Hello, I have the excel vba in my data and i wanted to convert the vba code in access. below is my code that i'm working on from excel vba, idA = Application.Index(wsPT.Range("B2:B" & wsPT.Cells(Rows.Count, "B").End(xlUp).Row), 0, 1) idB = Application.Index(wsPT.Range("C2:C" &...
  18. I

    Excel VBA to Access VBA

    Hello, I have the excel vba in my data and i wanted to convert the vba code in access. below is my code that i'm working on from excel vba, idA = Application.Index(wsPT.Range("B2:B" & wsPT.Cells(Rows.Count, "B").End(xlUp).Row), 0, 1) idB = Application.Index(wsPT.Range("C2:C" &...
  19. I

    Open Ms Access from Google Earth

    actually when loading it shows the whole GE in that form, but when i click it the button it will directly goes to the long/lat but when it reach the point it will show the error "This program cannot display the webpage". Then click the button again it will give the script error with url...
  20. I

    Open Ms Access from Google Earth

    What do you mean link? I have this code below, please take a look.
Back
Top Bottom