Search results

  1. C

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

    THe dreaded #Name? is ruining my form!!!!

    Thanks also the null switch worked perfectly.
  3. C

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

    THe dreaded #Name? is ruining my form!!!!

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

    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() 'Me.Cmd_Hidden.SetFocus Me.Opt_Active.DefaultValue = False Me.Opt_Inactive.DefaultValue = True Me.Opt_All.DefaultValue = False Me.Frm_SubPotting.Form.RecordSource =...
  6. C

    Solved CHange record source of subform

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

    UPdate Query not working

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

    UPdate Query not working

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

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

    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 error now.
  11. C

    UPdate Query not working

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

    Solved Runtime error 3071

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

    Solved Runtime error 3071

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

    Solved Runtime error 3071

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

    Solved Highlight backcolor in only 1 input on a continuous form

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

    Solved Highlight backcolor in only 1 input on a continuous form

    Hi, basedon what you are typiong to gasman does that mean that the above concept wont work and i have to do the code approach? THansk for all your help so far.
  17. C

    Solved Highlight backcolor in only 1 input on a continuous form

    Hi. I'm not sure if this is possible as I cant find away but I thouhgt before i give up i will ask on here. I have a form with 2 subforms on it. The first subform lists all my sales orders and the data is presented as a continuous form. On the subform is a command button to click to edit the...
  18. C

    How to call/trigger a command button when opening an form

    Hi, thanks for this. I think i understand it now. I will try and put this in and see if any issues occur. Makes a lot more sense than 1 hour ago :) Stupid question but in your code what are the .... about? dim Frm as access.form docmd.openForm "Frm_BatchInputEdit", .... set frm as...
  19. C

    How to call/trigger a command button when opening an form

    SO for that I just change private sub to public sub?
  20. C

    How to call/trigger a command button when opening an form

    Yep I did. Wasnt sure whether i needed to add more reference to it as i am typing this in the subform code so do i need to reference the full frm name im opening with the cmd_editpottingdataclick?
Top Bottom