Recent content by relewis

Thanks hneal98 and PHV. I'll give both your suggestions a try out tomorrow morning and report Robin

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

Tony, You are so right. I figured that out just before I clicked the e-mail that told me about your reply. I"m so embarrassed. Thanks for the help, however. Robin

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

Thanks, mkov, but that didn't solve the problem. I reinstalled MS Access 2000 and made sure I had all libraries and that didn't do the trick either. I'm going to put this database on another computer altogether and see if that makes a difference. Thanks again. Robin

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

scriverb, Thanks for the clarification; however, adding the Format() or Format(Cstr()) bit to the parsing of the string I make did not solve the problem. What did solve the problem was, the string I am creating is taken from numbers in an autonumber field in my table. Instead of having the...

scriverb, I have implemented your solution using the global variable, and it works very well except for one little thing. If the string created looks like this "47,62", I am getting results not only for the records that match 47 or 89 in criteria (which is what I want) but also...

scriverb, it looks as if both your solutions will solve my problem. I'll try them out tomorrow and reply here as to how well it works. IN the meantime, thanks so much for your (and others) help. Robin

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