chrisjames25's latest activity
-
Cchrisjames25 replied to the thread THe dreaded #Name? is ruining my form!!!!.I'll be honest I'm not sure why i am using a Eval. I think i was stuck last week getting the query to work and i saw on a forum page...
-
Cchrisjames25 replied to the thread THe dreaded #Name? is ruining my form!!!!.Thanks also the null switch worked perfectly.
-
Cchrisjames25 replied to the thread THe dreaded #Name? is ruining my form!!!!.HI All, thanks for so many helpful responses. Blows my mind how helpful this forum is. The solution came by Hi. Thanks for this. I...
-
CHi All. Been pulling my hair out today and just cant see what doing wrong. I have a mainfomr with a subform. THe subform is populated...
-
-
Cchrisjames25 replied to the thread Solved CHange record source of subform.Above code doesn's cause me any code to fail but it doesnt seem to change the recodsource. Private Sub Opt_Inactive_Click()...
-
CHi. I have a main form with the name Frm_PottingInput. WIthin that form is a subform called Frm_Sub_Potting. The source object of that...
-
Cchrisjames25 replied to the thread UPdate Query not working.Yep that was the trick. Cannot beleive a little separator caused my headache!!!!!!! Thank you so much.
-
Cchrisjames25 replied to the thread UPdate Query not working.Brilliant, THis is what is appearring in immediate window: UPDATE Tbl_SalesOrderDetails SET Delivered_Qty = 2,000 WHERE...
-
Cchrisjames25 replied to the thread UPdate Query not working.Apologies I didnt know how to do a debug.print so I created a string and turned it into a message box so i could see what string looked...
-
Cchrisjames25 replied to the thread UPdate Query not working.CHeers for this. I noticed this using gasmans approach and then corrected and now it all looks ok but still notworking. Saying syntax...
-
CHi. WIthin a form i have a command button. As part of the code I want to update a table that is not bound to the form. THe update qry...
