Recent content by chrisjames25

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 page that it was something to do with the format needing to be a string so it recommended using the eval. WHen i used the eval my eval worked as i wanted. Sadly...

Thanks also the null switch worked perfectly.

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 tried making this switch and used this code Me.Txt_SalesOrderNo = Null 'Me.Txt_SalesOrderNo.Value = vbNullString...

Hi 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 once i click a command button in the mainform and the subform is based on a qry that looks at an input in a textbox on the mainform. SO far so good. I open...

Above code doesn's cause me any code to fail but it doesnt seem to change the recodsource. Private Sub Opt_Inactive_Click() 'Me.Cmd_Hidden.SetFocus Me.Opt_Active.DefaultValue = False Me.Opt_Inactive.DefaultValue = True Me.Opt_All.DefaultValue = False Me.Frm_SubPotting.Form.RecordSource =...

Hi. 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 form is called Frm_BatchInputSubform. I have a option button on the frm_pottinginput form that when i click i want to change the recordsource of...

Yep that was the trick. Cannot beleive a little separator caused my headache!!!!!!! Thank you so much.

Brilliant, THis is what is appearring in immediate window: UPDATE Tbl_SalesOrderDetails SET Delivered_Qty = 2,000 WHERE SalesDetails_ID=179 oh i should have said i streamlined the code a bit to the following: Dim codeissue As String codeissue = "UPDATE Tbl_SalesOrderDetails SET...

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 like. Cant beleive built whole database and never known how to use it :(

CHeers for this. I noticed this using gasmans approach and then corrected and now it all looks ok but still notworking. Saying syntax error now.

Hi. 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 i have tried to code states the following: CurrentDb.Execute "UPDATE Tbl_SalesOrderDetails SET Delivered_Qty = delivered_qty +" & Me.Txt_QtySupplied & "WHERE...

Found my problem. PHew. Sometimes best to step away from it for a day and then the issue is easier ot find. Basically the query builder i posted was wrong. I should have been referencing a txt box instead of a combobox. When i made the change i still got the same error because in the resetform...

Apologies it seems to error on the form.requery part of the code

Hoping you guys can help. Currently pulling hair out as last 4 hours of work has suddnely glitched (ive done something) and i dont know how to fix it. I have a form (image attached) I choose from a supplier from a combobox and based on the supplier chosen a list of sales orders is populated in...

Perfect. It has worked perfectly. Exactly what i needed. Just need to tweak the look and feel but that just form tweaking. Amazing. THanks you so much for your help. Will use this in a lot of other forms also. Your a star.