Recent content by chrisjames25

Will give this a try now and see how far i get and report back. Many thanks

Yep when i say i work for a nursery most people instantly go with child nursery not plant nursery!!!! Oddly enough there is a child nursery right next to our plant nursery.

Hi. Its been a while so i guess that means with all your help so far my databases are working fairly well at work!!!! Big thanks for that. At the end of our season we do a stocktake of all the inventory on the nursery. Due to the scale and how spread out it all is we get different people to do...

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