Search results for query: *

I have a tab control form with a subform (qrybomsubform) I wish to show a warning message on the main form if the field Currcosttotal on the subform = zero (not Null - zero) I have the following - this hides the label but doesn't show it when I move to a record with a zero value. Currcosttotal...

I have a tempory table to which a list of part number are pasted from Excel. I need to validate these numbers for being Known or New parts I have the following code that finds "New" part numbers and inserts them in the "tblnewparts" table - this works fine. I can't find a way of inserting the...

I have a subform bound to the main form by two primary keys - Xfile and issueno. I have a routine on a subform field that inserts a record in a table if no matching records found using If DCount("*", "qrybom", "partno = '" & partno & "'") = 0 Then If MsgBox("This is a New Part - Do You...

I have a label on a main form which I wish to display if a sub form field= zero I am using this Private Sub Form_Current() If Forms!frmprojectstabbed![qrybomsubform].Form![Currcosttotal] = 0 Then Me.warning.Visible = True ElseIf Forms!frmprojectstabbed![qrybomsubform].Form![Currcosttotal] > 0...

Hi I have a report with four text boxes displaying subform totals. One of them refuses to display zero if no data =IIf([Reports]![rpprojects]![qrybom subreport].[Report].[HasData]=True,[Reports]![rpprojects]![qrybom subreport].[Report]![sumadjustcost],0) The others work fine using a similar...

I have a subform based on a lookup query. The user enters a part number and it looks up the additional information. If the user enters a part number that has no matching records is there a way I can automatically have this number inserted into the "newparts" table?? I have tried If Isnull...

Can any one offer some advice on this. I have a form that has one required field, this form has a subform based on a Tblmanufacturers, this contains 6 fields - 4 imported via ODBC from an AS400, 2 contained in the database. The 4 ODBC fields may or may not contain data. I want to have a button...

Hi I Have a form "frmmanufacturers" that has a subform listing parts supplied by a particular manufacturer. I wish to be able to double click the part number [partno] field on the subform which will open another form displaying the matching record. I am trying the following - with no luck...

Can any one help with a problem I have with a tab control form I have a form with a two page tab control - page 1 being the main form. I have a data sheet view subform on page 2.(linked by "Parttype" There is a part type field on page 1 and I wish to hide columns on the data sheet depending on...

I have a database to keep track of electronic component specifications. All parts have a "parttype"field and all part types have separate "specification" table Eg Part type "Resistor" is linked to "Resistor_spec" Is there any way I can use a tab control with the main part details on page one...