Search results for query: *

When my users enter a number that is out of spec, I want a message to appear saying "Out Of Spec". This will prevent them from moving on until they click OK. They need to notice that they are out of spec. The validation rule feature doesn't allow them to move on unless the data meets a...

My form is based on a query that returns about twenty records. It has 5 numeric fields upon which I want to use StDevP. This of course applies to all five fields in all records to give the standard deviation of all values. In thread702-475136 I was able to use a temp table to do this for a...

I have two tables: tblFormulations and tblWP The records in the first are unique to the field: FormulationsLot. The records in the second are unique to WPLot. These two fields have identicle values. When a new record is generated in tblFormulations, I want a new record to be appended to tblWP...

I have a stacked column chart that plots monthly sums by two concatenated date fields using datepart. Example: Jan 04, Feb 04, Mar 04 etc. It works great. When I do a calculation on each data field to change the data to a percentage, the x axis date labels get jacked. The first shows normal...

I know this has been covered but I'm not getting it. I have a select query of three tables. On one numeric field I want the nulls to be zero. This field name is present in all three tables. I want the query to return values (and zeros for nulls) from this field only from the third table...

I want to convert a short time field into straight number of minutes to do some calculations. Example make 1:10 equal 70 (minutes). I have searched to no avail and I realize this could be a can of worms. Ideas?

How can I avoid the six field limit on a chart and have 12?

On exit of a field on my form I have the following code for calculating a percent yield. It assigns a variable (test)to 135, 105, or 260 into the calculation based on the part number that was inputed. The problem is that it always assigns the variable to 135. I have tried numerous variations...

I have a parameter query that shows one record. It has fields for a beginning date and an ending date. I want to count the number of days between the two. Help appreciated.

I have a data entry form based on a table. I want it to open for only the top (or most recent) 75 or so records based on the autonumber field or date field for greater speed. I don't need all my 12,000 or so records available here. I want this done automatically when the form is opened. Ideas?

The size of my Access 97 database is increasing at a rate that exceeds what you would expect from just data entry. It will increase up to 40mg in only two weeks. After I compact it, the size goes down to around 9mg. I think it is related to opening and closing a data entry form. Doing this...

I have the following as a field in a query to show a running sum (taken from another thread): RunningSum: DSum(&quot;[YearlySavings]&quot;,&quot;tblMaster&quot;,&quot;[ID]<=&quot; & [ID]) I want this to use the field &quot;Proposed Completion&quot; which is a date rather than the ID field for...

I have a cross tab query that counts the number of jobs done per shift. Shift is a field that is entered as 1,2, or 3. I have:row heading = date, column heading = shift, row heading = ID, row heading = total of jobs, and value = jobs This is based off of a make table that is made for a...

...in hopes of someday solving this three year problem for me that I am convinced has a simple answer. I want to apply a function to five fields in the current record on a field's on enter property. Any function will do: Min, Max, Avg, STDEV, etc. I just can't figure out the syntax. The help...

I have three fields of data. I want a fourth field to show the minimum of the three. I put the following code in the after update event of the third field: Me!Minimum_Field.Value = Minimum(Me!Field1.Value, Me!Field2.Value, Me!Field3.Value) error = minimum not defined. This applies to only...

I have written a procedure that is far beyond the 64K size limit. It is in the after update of a field. What to do? Can it be split into multiple procedures?

I have a bar chart with a few data series. I have data labels showing the value at the top of each bar. Some values are zero and I want them to show also but they aren't. Ideas?

This may have been covered but I didn't find it. I want my subform to update when data is entered on the main form. The data displayed on both is from the same table. The subform happens to be a chart. Of course, charts use a query. These details are probably what is complicating it. Ideas?

I want to do a calculation in the after update event of a field on a form. The calculation is on a field that is on the form from the table the form is based on with another field from a query. The only hitch I have is with the syntax that calls out the field from the query. Ideas?

I want an error message to appear when 3 or more consecutive records have a value in a field that is greater than a number or less than another number to indicate an out of control process. I would like for the message to appear after the third value was entered on a form if at all possible...