Recent content by evanark

Thanks! Again I really appreciate your help!

Thanks again! I really appreciate all the help you have given me with this project! Everything works great!

Thanks!! It works like a charm!!. I have one quesition, is there a way to append the database with your code that will leave hopspacing 1 empty on the third record and just populate sysHop2? example below. Just curious, if its too complex I would not worry about it. Overall this is the result...

I was able to get the code to work for existing records that have two systems which performed calculations perfectly when adding a 3rd system. The problem I am having now is how can I get the numbers to auto calucate for accounts that already have 3 or more systems? I tried the following code...

Awesome! I am going to see If I can apply this to existing records! Thanks for you help!

That works great, however can I preven the syshop2 from populating after the third record? Each account can have up to 5 base, the first three are in a different frequency ranage hence calculating base 3 from base 1. the last 2 base are different frequence so they will not interfer with the...

Your method makes more sense.

I figured it out! :)

The code works great! I need to find a way to implement it. I have a way but not sure how to keep it within the account. I thought about creating a field called base number and when the user reaches base 3, the code is executed to subtract the 3rd base from the 1st base. Can I use a auto number...

Thanks that worked! You are awesome!!:D

The null is gone now but sysHop2 is not being populated. I created a field in my systemconfiguration table called syshop2 to hold the value. Also I need to apply this to an existing records. Here is the entire code for calculation. Private Sub sysNetworkNumber_BeforeUpdate(Cancel As Integer)...

The user wants to subtrack the third entry network number by the first. He wants to ensure that the hop spacing is greater than 4. The way the database works is that a school or account can have up to 5 base stations 3 of one frequence and 2 of another, He wants to first and third base to be...

Here where I put the code, still get the same error message :confused: Dim PrevSysConID, SndPrevSysConID As Long, sysHop2 As Integer sysHop1 = DLookup("[hpHop1]", "tblHoppingPatterns", "[hpNetworkID] = " _ & [Forms]![frmTempestCoordination]![frmSubSystem]![sysNetworkNumber])...

I get Run-time error '94' Invalid use of Null When first network number is entered, not sure why it relates to the following line of code. SysHopSpacing2 = Abs([sysHop1] - DLookup("[sysHop1]", "tblSystemConfiguration", "[sysAccountID]=" & _ Forms!frmTempestCoordination!accAccountID & "...

Cool! Thanks! Ill try this soon and see how it works!