Search results for query: *

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 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...

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, 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...

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...

Hi, I have a text box with the following in the control source =round([text29]/count([itemcount])*5),1) [itemcount] is the number of boxes of that item and there are 5 items in each box. the problem I am having is that sometimes the count field will should be null so that nothing is counted...

Hi, I have a form where we enter information about a car. and the user selects the type of car from a combo box. What I want to do is that if the combo says dodge truck then the truck form opens if it says dodge car then the car form opens and so on. I tried if then statements and did not have...

Hi, I have a tab control with 4 pages and each one contains a different subform. I have a combobox on the mainform tnat I want to use to control which tab they can view and or enter info into. the tabs are named redux, mature, new, old. if the combobox = &quot;<11&quot; then I only want the...

Hi, I have a form and a subform. The user enters record data in to the main form then a summary of it apprears on the subform, this works fine. But when I try to add a second record to the main form via a add record button I get an error you tried to assign the null value to a variable field...

Hi, I put my database on a windows 2000 laptop to day and for some reason it also had a file named &quot;PRO lock file&quot; where pro is the name of my database. this system has access 2000 already installed and I cant run the data base i get a table unavailable error or something like that...

Hi, I have a report that has a subreport for the detail section and I would like to sum the field of [appraisal] but I cant seem to be able to do it. I have tried to put sum([appraisal]) in the page footer and the report footer and I have not had anyluck. Any suggestions would be...

Hi, I have a form with 2 sub forms and a tabcontrol on the main form is a subform that totals what is in the tab control. each tab control has a subform to total the information put into each of them. I have a save button which moves the total from the tab control to the main form. The...

Hi, I have a form with 2 subforms on it. The user updates the second query and then presses the save button which updates a field in the first query. My problem is that I cant get the query to refresh automatically. I would like to code in a requery or refresh just for that subfom but I cant...

Hi, I have a form that for some reason will not let me access it either in design mode or form mode. I get the error that user canceled the previous operation. Does any one have any ideas on how to fix this or where to look. I was working on a subform on this form when this happened. Any...

Hi, I seem to be having a problem when I pass the primary key of one form to the foreign key of another form. I am using appraisalid as the primary key in the field form and I am passing that value to appraisalid (the foreign key) of the appraisal form. To assign the value I am using the...

Hi, I seem to be having some problems creating command buttons. I have created several and all was fine but now all of a sudden I can draw the button but the wizard to tell it what I want the button to do doesnt come on anymore. I hope someone can help me or tell me what I have done to cause...

Hi, I have a form with a subform. In the main form the user enters information about a product. and they enter the line number that the product appears on. I have the query that the subform is based on to sort by the line number. My problem is that when I have line numer 10 it appears after...