Search results for query: *

Roy, What if the part of the data needed to complete the calculations needs to come from another query (I need to get values above and below another calculated value, interpolate them, and use the results in the other calculations). I tried referencing another query in the calculation expression...

Thanks Roy. I assumed I could do what you said, but how would I loop through all the records that the form and report are based on (they are based on the same recordset) and get the calculated values from the form to the report for each one? I may just be not understanding exactly how reports...

Hi all, I have reports that I can not get to perform the calculations that I need (I asked about them in other threads). Is there a way for me to use the calculated data on the form and place it in the report instead of trying to redo the calculations on the report? And if so, how can I loop...

Anyone have any ideas? This problem is still stumping me as to why it will work if I have the report open in design mode and then run it again immediatly after it crashes. I am under the assumption that it works the 2nd time because the original running of the report "primes" the...

Hi all, I got my previous problem fixed but now have a different one..go figure. When I open my report, I get a divide by zero/null value error stemming from the 2 subreports that I requery for every record in the record set to get values that I interpolate and then use in the rest of the...

I have No selected for both Group Header and Group Footer. I when I try and select a Field to sort on, none show up. I believe this is because I use if-then-else statements in the On_Open for the report to decide which query to run the report on. I put the part number field in by hand, but when...

Same thing, the Field/Expression field is blank and the Sort Order has Ascending (it will not let me delete it) and I get the error. When I do have anything there, it still asks for the value that I want to run the subreport queries on. Not sure if this is the problem or not. Been messing with...

Jim, I deleted them but I get an error that states "You must define a sort field or expression for the group header or footer in the report you tried to print or preview" Jason

Hi all, I have a form which is based on 3 queries. I perform various calculation on the data and output it to the forms text boxes. I have created 2 invisible subforms to perform a lookup on a calculated value in a lookup table. In one subform I grab 2 values from the record above and in the...

Hello, I accidentally posted this in the Access Forms forum when it really belongs here. I just have to figure out how to delete it from that forum :) Here is my problem: The database I am working on is used to forecast inventory needs for the program I am on. When one of two different data...

Hi all, I need to import data into an existing table and have it overwrite the data already in the table with the new data. The data that is in the current table is autonumbered. Is there a way to import the data over top of the records already in the table? Can I also have the new data...

Crud..Figured I would have to code it instead of using the functions, just wanted to make sure. Thanks for your help WildHare! Jason

Hi, I have a group of numbers within the same record that I need to find the standard deviation of and can not figure out how to do it in either the query or within a form using VB. The table is set up like PartNumber IDNumber Description Week1 Week2 Week3... to Week6. Where the weeks are the...

Hi, I have an Excel worksheet that has a table that allows me to input a number in a specific cell and it performs operations on it (such as interpolation) and outputs the answer to another specific cell. Instead of figuring out how to get this into Access 97 and perform the operations needed, I...

Hi, I have a form that is tied to a table. What I need is that for any data that the user changes on the form, it will only be saved to the table if they click the Save button. If they close the form/go to next record/go to a different form, I need for the data to not be updated in the table...

Hi, I have a form that has 5 input boxes that are used to search my records. The user can use any combination of the 5 boxes and will get the records that meet those conditions (ie. they select Hardware for the type and 777000 for the partnumber, they will get all instances that correspond...

Figured it out :) Thanks for the help Lozere. Regards, Jason

Thanks for the reply, I created a Module called Management, inside I put only Public Manager As Boolean I also tried it as Dim Manager As Boolean but neither worked. How do I reference that boolean and set it to true or false when the button is clicked. Here is what I tried adding to...

Hi all, I have a form that acts like a switchboard. In the VB code, I have declared a boolean variable that I set when one of the buttons is clicked. These buttons open another form and I want to control what fields are locked in that form depending upon which button is clicked on the first...

John, No records are there when its opened. I would like it to be blank until the person selects the incident number, then have it fill in the text boxes with the appropriate data from the table. I can't figure out how to "initialize" the Me.Bookmark to be, say a new or blank record...