Search results for query: *

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

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

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

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

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

Hi, I am having a problem using an unbound text box to query the user for a number and then doing a query based on that input, then outputting the resulting data from the rest of the record back onto the same form (filling in data in corresponding boxes). I set up a query that has...

Hi, I have looked through prior posts and haven't been able to find out exactly how to do this since I am a total newb at access. My problem is, I have a Value list called ProblemType that contains 3 items, Hardware, Software and Component. I also have two text boxes called Software Program...

Hi, I am writing reports based on a crosstab query with dates as column headings (ie 200011 is Nov 2000). What I need to do is be able to place a call to the query for a month/year that may not yet exist in the query. For instance, the data avalable today may only run up to 200210 and my...