Search results for query: *

I have a calculated control on a form which is calculated using this formula: =([TotalItemInventory]-nz([Text16]))+nz(DSum("[numberreturned]","[tblEqptReturn]","[productid] = forms![products]![productid]")) [Text16] is another calculated control on the form which reflects a calculated sum on a...

I've written the code below to be activated when a command button is clicked on a form: Private Sub Command0_Click() Dim rst As Recordset Dim formholder As Variant Dim multi As Long Set formholder = Form![frmaccrual_vendor_invoice] Set rst = formholder.RecordsetClone multi =...

I was writing code in the VB window of Access 2000 with the properties window docked and open (the window that shows you the forms and modules you've created for the project). I was coding along when suddenly VB seems to not recognize my forms and their properties anymore. The form names are...

I was writing code in the VB window of Access 2000 with the properties window docked and open (the window that shows you the forms and modules you've created for the project). I was coding along when suddenly VB seems to not recognize my forms and their properties anymore. The form names are...

I have made this code which collects the value of the bound column of a multiselect list box and creates a string that I want to use in the criteria field for a query: Public Function PrintExemptionVendorRows() Dim ctlList As Control, varItem As Variant, strCollect As String ' Return...

Hello, this is my first question to Tek-Tips. I have made multifield indexes for a table called Table1 like so: Site1Index EventID Site1 Site2Index EventID Site2 Site3Index EventID Site3 Site4Index EventID Site4 Everything works fine, unless I want...