Recent content by loneranger27

Hi, I have a form that calculates a number based on adding the sum of a field in a query. When I run this program on some windows enviroments I get the #error in the text boxes doing the math. BUT when I reinstall the windows enviroment it works fine. I mostly have this problem with...

Hi, I am having a similar problem but different, I have a form that calculates a number based on adding items in a table. When I run this program on some windows enviroments I get the #error in the text boxes doing the math. BUT when I reinstall the windows enviroment it works fine. I...

Hi, I have a very small database with one main table that stores information about an insurance claim that it recieves from an excel file recieved via email from several different agencies. Once the file is added to the main table it is my job to assign a claim number to this claim. I then...

i came up with a solution it may not be the best but it works just the same, I used a multiplier on the foreign key to make them all stay the same.

Let me explain a little more. This is a local database on each users laptop. They need the ability from time to time to take all the information for a customer write it to a file and then email the files to a co-worker to import into their database so they can work with the actual file. The...

I got it to work i used a running sum and got the result i was looking for. Thanks gor the help.

Hi, I have a query that finds customer info from the customer table then exports that infor to an excel file then finds all of the different accounts that person has and makes another excel file and then finds all of the orders per account and makes a third excel file. All is fine to here. I...

Hi, That code will work but it doesnt sum the negative values for the unit. In the unit detail there will me more than one record to show up some will be positive and some negative. I want to first sum all the positives and negatives to arrive at a total for the unit. This total for the unit...

That doesnt work, when I use it I get "cannot have aggregate function in expression " Any other ideas ? Thanks

Hi, I have a report with with a unit header and then a detail section which may have several items in the list and a unit footer. For each line in the detail section there is a payable amount. In the unit footer I have an unbound text box to calculte the total payment and if the payment is a...

Hi, I have a calculated text box that gets its value from one of 3 subforms. is there a way to put more that one condition into the iff() format? for example if [type]="row" or [type]="spade" then [textbox123]=forms![tom]![calc] how can I format this into an 1ff...

Hi, I have an append query that searches and gets a group of records that match a user entered id field. Then it moves these records to a backup table. This works fine. Now I want to move the records back to the original table with a different Id field. I want the Id field to match the...

I am thinking maybe make a button to move the data to another table then move it back with a new foreign key to match the new record. I am not sure how to change the foreign key.

Hi, I have a form called customers that the user enters the customers information into. then from there he can click a button and go to a form where they can enter products being ordered. The orders table uses an auto number for its primary key. Quite often we have customers with more than...

Hi, I have a combobox that the user selects an agent's name from. If the name entered by the user is not in the list then the user is prompted to add. This works fine. I would like for the name that is keyed into the combo box by the user to appear in the form where the user enters the name...