Excel VBA to Access VBA

[ivandgreat]

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" & wsPT.Cells(Rows.Count, "C").End(xlUp).Row), 0, 1)


For k = LBound(idA) To UBound(idA)
For t = LBound(idB) To UBound(idB)
If idA(k, 1) = idB(t, 1) Then
.
.

End If
Next
Loop

any one could help me on this.

br,

[Missinglinq]

This is like taking a story, written in Swahili, to a an Irish pub and saying "Could someone translate this into Gaelic for me?"

While most people here have a passing knowledge of Excel, I suspect that very few have an extensive enough knowledge of Excel VBA to be able to directly 'translate' this to Access VBA for you. If you could give us an idea, in plain English (no Swahili, or Gaelic, for that matter!) of what you're trying to accomplish, we'd be happy to try and assist you!

Linq ;0)>

[ivandgreat]

This is like taking a story, written in Swahili, to a an Irish pub and saying "Could someone translate this into Gaelic for me?"

While most people here have a passing knowledge of Excel, I suspect that very few have an extensive enough knowledge of Excel VBA to be able to directly 'translate' this to Access VBA for you. If you could give us an idea, in plain English (no Swahili, or Gaelic, for that matter!) of what you're trying to accomplish, we'd be happy to try and assist you!

Linq ;0)>

Actually, i have a table in access that i wanted to compute based on two fields and have it in different output. But i don't know how and where to start.

[Missinglinq]

Actually, i have a table in access that i wanted to compute based on two fields and have it in different output. But i don't know how and where to start.

Unless you can explain what you mean by "i wanted to compute based on two fields and have it in different output," nobody here is going to be able to help you.

Linq ;0)>

[ivandgreat]

Unless you can explain what you mean by "i wanted to compute based on two fields and have it in different output," nobody here is going to be able to help you.

Linq ;0)>

Hi, i just uploaded the sample files i have.

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 it, after search it will lookup the adjacent "NE" again and loop until nothing found. example. In item 1, 2100 will found one item in field "FE" which is in item 4, the adjacent "NE" is ID 2002, this ID will search the value @ field "FE" so it has two with "NE" 2001 and 2200, these two IDs will do the same until found nothing. All found ID will be recorded on different table which is called table "Ouput".
- The table "Output" is only the result of the logic mentioned above.
- Other field @ table "Output" is part of the loop that were computed like field "To2G Capacity" and "To3G Capacity" is only adding all field values @ "NE 2G" and "NE 3G" (@ table "Input") related to the IDs recorded @ table "Output" field "DepID_Current".

Hope you could help me on this.

br,
ivan

[ivandgreat]

Hi,

Good day! Could anyone help me on this. Thanks!