Search results

vbainet, ALl I can say is this works best for what I am trying to do i this case.

I dont know how to change this to solved

Marlan, Thanks you got me on the right track. The only thing I had to change was after each text there is chr(13) and chr(10). The code looked like this. Dim txtstr() As String Dim txtvar As Variant txtstr = Split(Me.Text0, Chr(13) & Chr(10)) For Each txtvar In txtstr Insert Query Next...

Sure. I am making a db for different courses in a school. Each chapter of each course has 2 guaranteed requirements to teach. However each chapter could have several other requirements. I want to put a multi line field and each line they enter would be a requirement. I.E. Mandatory...

Just wanted to drop in and say hello to everyone. I am currently working on a database that is really over my head. My time frame is 6 weeks so I was hoping people woul dbe able to help me out. It has been my experience that uk forums are much more accepting to "newbies" and much more helpful...

I have a form on db that is a multiline text box. I want to insert the information in that field into another table. How do I make access insert each line of text in the text field as a new record.