Recent content by shelspa

Got it. Cancel should = False Thanks.

I had it in after update. However, when I put it in before update it will not let the user move on to the next field and leave the out of spec data in that field. It acts just like using a validation rule and validation text.

I think that is close but I get a variable not defined for the word cancel.

So in an event procedure I have: If Me!Site_1_Index > 1.965 and < 2.015 Then What?

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

Thanks, this puts me well on my way.

So I used the following to establish a union query but I must have something wrong: SELECT ID, Site_1_postThickness as Num FROM qryTPolyLotReport UNION ALL SELECT ID, Site_2_postThickness FROM qryTPolyLotReport UNION ALL SELECT ID, Site_3_postThickness FROM qryTPolyLotReport UNION ALL SELECT...

Not form, "report" sorry.

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

This can all be done by running a macro that opens the form in datasheet view from the switchboard verses opening the form from the switchboard.

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

Create a query that shows only the last record. In the default value of the control on the form you can do: =DLast("fieldname","qryMost_Recent_Record")

Unfortunately the data table only shows microsoft's sample data. I found that in my concatenate statement, if I change the "/" to "\" between the months and years it works. Why in this chart and not other identical charts do I have to do this I have no idea. Every control, parameter, variable...

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

Records are not included in my query when this field is null. Therefore I really need to assign them to 0 so I don't lose information. The tables are linked by a lot number field, first to second and second to third. The first and third do not contain the same lot number. I'm not sure about...