Search results

Oh boy now I am feeling stupid ... This solved the problem, thank you!

This is resulting in another error message "the select statement includes a reserved word or an argument name that is misspelled or missing" so i am getting the feeling that the whole problem is resulting from the combo box. I am using a combobox in the form, where you can select an existing...

declaring it as a DAO.Recordset didnt help

I am trying to define it as the Filtered recordset. So the active recordset will only contain the records I want to edit. next thing would be something like rst2F1.edit rst2F1!field = value I used a similar code in other forms like rst.Filter = ...(conditions here) rstFiltered =...

Hello everyone! You have been a great help so far, so I hope you can help me with my newest problem to. I am using the following code: Private Sub Savebutton_Click() Dim db As DAO.Database Dim rst As DAO.Recordset Dim rst2 As DAO.Recordset Set db = CurrentDb Set rst =...

Ok this works! Thank you!

DSum would be the perfect solution, but my Criteria is depending on a user input from a combobox ... so it would be something like "[Location] Me.Loc" which apperently is not working ... I just always get and "" Field I already tried an rs.EOF, where I always get the missing Parameter Message...

Hello Everybody! I am new to access and trying to programm a small database for me and my colleagues and I am stuck right now. I am trying to loop through a recordset (which is displayed on the form) of varying lenght, and sum up the values of one column ... I found the rs.openrecord solution...