Recent content by thomas49th

  1. T

    Checking for a NON null value

    Hi, how do I check through each record in a table to see if the field "Notes" is NOT a null value Thx :D
  2. T

    Take a field from Query output

    also how do i find the propeties of rst?
  3. T

    Take a field from Query output

    I get an compile error "External name not defined" and highlights myTempVar = [Item Name] I tried putting myTempVar = "[Item Name]" but then my output is just a string of "[Item Name];[Item Name]"... and so on. What should I do? Thx EDIT: Looking at the code I find nothing is actually...
  4. T

    Take a field from Query output

    Hi, an output from a query gives me so many records with the fields "Name" and "Type". How do i take all the records in my query with the field "Name" and put them into a string, parsed with a space(space inbetween each one record "Name")? Thx
  5. T

    Enter data for query from VBA

    nope sry. I think ill open a new thread tho
  6. T

    Enter data for query from VBA

    Cheerz. Now my query works fine, but I have another question From my query, how do i take each returned record's field "type" and put that into a string, each one parsed with a semi-colon ";", in VBA. Thx
  7. T

    Enter data for query from VBA

    Well im going to validate the data in VB when the user clicks the command button. That works. Im just not sure how to put the textbox data into a query... can you give me an example?
  8. T

    Enter data for query from VBA

    Hi, I have a query which is open ended (user enters data when clicks on it). I have a form with a textbox on it and command button. How do I make it so when the user clicks the command button the text in the textbox is entered into the query by VB from modMain? The textbox is text1 and command...
See more
Back
Top Bottom