Search results

Yes accAccountID and sysSystemConfigID are autonumbers. That works!! Thank you very much!!! One question, how can this be applied to an existing record and continue the calculation if another system is added? Do I requery the subform before the calculation?

I do have a PK linked to the subform. Here's what I am working with. I have two tables Account and SystemConfiguation. On my entry form, the Account is the parent and systemConfiguration is the subform. The subform is presented in datasheet view while the main form is single view...

I want subtrack a value on the current record from the previous record and display the result in text box in subform datasheet. This is done during data entry. The calculation works most of the time and randomly it returns the wrong value. I have the code in an after update event after I enter a...

I have been think about this problem for a while and I am stuck, can you peform this test by nesting Dlookup so that the hop spacing is calculated with the accountIDs that match? The Accoun tablet and the system table are linked by accAccountID and sysAccountID. Can I base my calculation to stay...

Disregard the hopping pattern table, its just a reference table. There are a set number of values in that table. I just use a Dlookup for the hop1 based on the network number entered by the user, which auto populates the sysHop1 in the systemconfigurations table. The SystemConfiguration table...

The DMax works however, my results are not what I want. I created a school(account) and added 3 systems to the school the saved the record. My hop spacing calculated correctly based of the value of the Hop ID from previous system. The first system in a new school shoud not return a calculation...

I just reviewed the code and Ill give it a try. I have a question, can you restart the count when you reach a certain number. each account can have up to 5 possible systems. if you start a new account and add a system, can you start the number from 1 again? or so if I go back and edit a record...

Here is example of my form, I have entered the Base number manually, I would like them to be populate automatically. Also this a picture of one record. When I add another new record, I want the Base Number to start at zero on a new system configuations. The purpose of this because system...

I have this scenrio, I have drop down list that inserts the number 1 in a subform in datasheet view, the field name is Base Number, is there way to auto increment the previous base number by one in the next record of the datasheet? Base number 1 Base number 2 This is not going to be...

I found a work around, instead of using an autonumber, I created an new field in the table called Base Number which is unique to the account. Here is my code using the sysSystemConfigID sysHopSpacing = Abs([sysHop1] - DLookup("[sysHop1]", "tblSystemConfiguration"...

At first hop spacing was just a text box, but I could not get calculations to work right when subtracting from a previous record, the hop spacing had to be part of the record so I am storing this calculation in the table. Here is my table Structure.

Sorry for the lack of explanation, was in a hurry. There is field in the system configuration table called hop spacing, it stores the difference from the field called hop pattern. hop pattern subtracts from the previous hop pattern. I can do this with new records with a Dlookup because the...

I have two tables, Account and SystemConfiguration. Account primary key is accAccountID, this is tied to SystemConfiguration table by sysAccountID, foreign key. SystemConfiguration has its own primary key sysSystemConfigID. How can I group records together? Example accAccountID...

Thanks! It works now. I can't belive I missed that :eek:. I need sleep.

I am sure there is a thread related to this and I apologize for adding this thread if there is. I am having problem with duplicate detect. I have written a some VBA code to detect if a school name exist in the account table. The problem is I get my error messge ever time I enter a different...

I got the calculation to work by subtracting from the previous record using DLookUp, is there a way to subtract from the first record? This is my code sysHopSpacing = [sysHop1] - DLookup("[sysHop1]", "tblSystemConfiguration"...

Account information and system configuration are two seperate tables that are linked by Account ID. System configuration has its own autonumber primary key called sysSystemConfigID. The goal is when the user enters a network number in the system configuations subform, hop 1 geneaters a number...

I am sorry I forgot to mention the primary key, its sysSystemConfigID in the tblSystemConfiguration table.

Hi all, I am having trouble with or dont know if its possible to accomplish. I have a table with a field called Hop 1 that house a numeric value. I have created a textbox control called hop spacing. I wan to subtrack the hop 1 from the hop 1 in the first record and display it in the text box...

I figured it out!! I need to use Dlookup but my syntax was wrong. All is good :)