Search results

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

also how do i find the propeties of rst?

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

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

nope sry. I think ill open a new thread tho

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

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?

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