Search results

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!

The code is located in the frmSubSystem. I have not created another field to hold the base number. Each system configuation for an account is a new record in the datasheet. The main code for the current calculation in in the field sysNetworkNumber before update event in the code editor. I still...

The database is working great, the only thing the users want now is the ability to subtract the third system network number from the first network number in the system configuration subform within the account. I am not sure if this is possible or how to accomplish this goal. I do know I can...

Thanks for the assistance!!

A user requested a change that would change the form header and detail back ground color to white when they click the button print record and then change the color back all in one click after the record prints. I keeping getting a run time error, type mismatch on the line where to code is to be...

Bill, the cboSystemType is text field, Ill rerun the code with get the error so we can figure it out for future reference, Thank for you help! Ill try to get that error messge posted soon.