Search results

Thanks man, but your link doesn't seem to be working....

hi, im trying to convert all the values in a table/querie coulmn into coma seperated values in a text box. like: table column: a b c d e *Some VBA Magic* Textbox = a,b,c,d,e Not realy sur where to start....any ideas? i presume some sort of loop is needed?

I have it working now!! yay!! i ended up using the code: DLookUp("CastingCost","data-tblCasting","ID=" & [PartID]) Just needed some brackets round PartID! Thanks Plog!

Hey Plog, Afraid I’m getting the same message box saying unknown with those as well. Although I do get a help button with this message box that links to "Data type mismatch in criteria expression. (Error 3464) The criteria expression in a Find method is attempting to compare a field with a value...

I have a update query where i am updating a table called tblPartSetEdit. tblPartSetEdit has the fieldsPartIDand CostofComponent. I am looking to update from a table called data-tblCasting that has fields ID and CastingCost. Ii am trying to update the field CostofComponent to a value from...

Awsome thanks vbaInet. I was passing over info that was not for the same columb as the combo box. I am a fool!! Sorted now!! I have also changed all my Forms_ to Forms!FormName Thanks :)

Thanks guys yeah the code does reference another form with a public sub setting. Not sure if this is the best way of doing it?? The total code is: Private Sub Text23_Click() DoCmd.OpenForm "frmExpandAssembly" Form_frmExpandAssembly.cboAssemblyID.SetFocus...

Hi, Im trying to select a value in a combo box. using this code: Form_frmExpandAssembly.cboAssemblyID.SetFocus Form_frmExpandAssembly.cboAssemblyID.ListIndex = 0 Form_frmExpandAssembly.cboAssemblyID.Dropdown This selects the first value but i want to select a value that is equal to a text box...

Yeah that seems to do the trick. Thanks!!

Hi Everyone, Kinda new to VBA and been lurking on here and learnt a lot already. OK ... i have 2 forms: TestForm1 TestForm2 In TestForm1 i have a text box called TextBox1 and Button called Button1. im trying to open TestForm2 when u click Button1 and go to the record in...