Re: $$Excel-Macros$$ Re: saving command button not functioning

2011-12-08 Thread Shankar Bheema
thank you very much Kishan On Thu, Dec 8, 2011 at 11:37 AM, Kishan Reddy, K < kishanreddy.kethire...@gmail.com> wrote: > Please add the following code. > > rst.update > > after assigning values to the fields > > Also instead of using rst.fields(0), --- you can use > rst.fields("fileno") which wi

$$Excel-Macros$$ Re: saving command button not functioning

2011-12-07 Thread Kishan Reddy, K
Please add the following code. rst.update after assigning values to the fields Also instead of using rst.fields(0), --- you can use rst.fields("fileno") which will be more legible and readable. Private Sub cmdsave_Click() Dim rst As Recordset Set rst = CurrentDb.OpenRecordset("select * from t_