Recent content by deanamiles86

Sorry Im a bit lost with where you are, dont you just reopen the table and click AfterInsert again to edit the macro?

ive now been able to recreate this error and i fixed it with the following =IIf([QtyAdjustOut]>[Forms]![Inventory_OutboundRequest]![OnHand],MsgBox("Message Insufficient inventory, please adjust your quantity",0,"Title Inventory check"))

i cant see why you are getting this error, have you got any other events happening in this form?

Not sure why this hasn't worked, I have created a replica DB and it worked Am I right in thinking You are using form Inventory_OutboundRequest and You are using the field OnHand And within the same form you are using a sub form called SF_inventorydetailsitems with the field QtyAdjustOut

To do that Create a query based on your earlier query and group by the student num and subject, then average the pts, then use an if statement to determine the grade

If you give each student a unique ref number you could use this create a module Public Function Conc(Fieldx, Identity, Value, Source) As Variant Dim cnn As ADODB.Connection Dim rs As ADODB.Recordset Dim SQL As String Dim vFld As Variant Set cnn = CurrentProject.Connection Set rs = New...

Try This "1st September" & Year(Date())

Try this =IIf([SF_inventorydetailsitems].[Form]![QtyAdjustOut]>[OnHand],MsgBox("Message Insufficient inventory, please adjust your quantity",0,"Title Inventory check"))