Recent content by Jeff_Ford

I have posted this previousely to no avail, Can anybody help? Based upon the selection on a form frmMainMenu another form frmMainForm is displayed with some fields on no-show based upon the selection that was made from frmMainMenu. This is filtered by TblPartID I would like however to have an...

A query I have created needs to sum fields “QuantityInGood”-“QuantityOutGood” And “QuantityInBad”-“QuantityOutBad” The information for these fields come from two sub queries 1. qryrptsubQuantityInStockBySupplier 2. qryrptsubQuantityInQuarantineBySupplier The information for these sub...

How can i set the control source of the combo to the suppliers table when the record source of the form is set to tbl Batches?

Cascading combo I know there is plenty of info out of there on how to do cascading combos, but im still sruggling! (Not just laziness), ive downloded sample databases but i guess i wont understand one until i have one working within my database. I need one that allows a product to be selected...

I have a query (qryBatch) that queries information from a table (tblBatches) this, query is the record source for a subform (frmBatch) within a main form (frmMainForm). On the main form there is a combo box (Product I.D) which should be used to filter the information within the subform through...

I have a query (qryBatch) that queries information from a table (tblBatches) this, query is the record source for a subform (frmBatch) within a main form (frmMainForm). On the main form there is a combo box (Product I.D) which should be used to filter the information within the subform through...

I have a form that collects test information about a large number of parts. The parts need to have the batch numbers of materials inputted along with the test data. These batch numbers vary from part type to part type. I have previousely used code to Auto Fill the batch numbers from the...

believe me it would be too much to redesign now, can i not use Vb to find the max, min and do the calc OR do the calc in a query.

So would the control source be somethng like = Max ([Basecoat Thickness #1] + [Basecoat Thickness #2] + [Basecoat Thickness #3]) - Min ([Basecoat Thickness #1] + [Basecoat Thickness #2] + [Basecoat Thickness #3]) ............?

Yeah they get ther values from data input by a user, the textboxes are called Basecoat Thickness #1 Basecoat Thickness #2 Basecoat Thickness #3 Basecoat Thickness #4 Basecoat Thickness #5 Basecoat Thickness #etc

Probably a simple one but, what would i type in the control source of a text box if i wanted it to display the Max - Min value of a number of text box values

Ok, im still having problems with cascading combo boxes im a complete amatuer!, ive posted it here if anybody could be so kind to have a go. In this example i have two customers 1 and 2, each with specific parts made by each, based upon the customer chosen i wan the second combo box to display...

I want a combo boxes values to be based upon the selection made in a previous combo box. I.E the first combo box displays customer names and based upon the selction of the company name the next combo box will be populated with the parts made by that customer. I have created tables with the...

Can you get more than 6 field in a chart on a report? surely

Does anyone know how to calculate the statistic cp in visual basic? for a query or form?