Search results

I am not sure if it is a yes/no field or not. I did not convert anything to a string. What do i need to convert to a string? qrysearch IS the name of the query. wouldnt that be where i need the information from?

I wouldnt mind having it bound to the field in the table. And i tried this but in the qry any unchecked values become zeros. I changed me.answer to me.qrysearch because that is the name of the control source where the info is coming from but i keep getting an error.

ok. Thanks vba. So I have created a report with all of the data on it like you said. Then i made a button on the form which should be clicked if you want to insert the selected criteria into the report. The code I have put in is: Private Sub btnInsert_Click() 'I would like for the field...

vbainet, So i inserted the code into the check box by building a code event. And this does not really seem to be working. All of the checkboxes are checked and when i uncheck one, all of them are unchecked. And i also must have messed up on the formula somehwhere because it keeps saying there...

I have not created the report yet. Let me get this straight. So if I create a report based off of a query(obviously using the query that I used before would be easiest) that contained ALL of the data from all of the tables, I can somehow make it possible for the report to show only the results...

Well i was hoping somehow there was a way to add a check box next to each result. Then, after searching, if I liked the result, I could check the checkbox and maybe click a button that would send it to a report or word. So if i did this for 6 different responses, then those 6 responses that I...

Once again, thank you so much for the help. This project is starting to look very good. I have added check boxes next to each result and I am searching the web looking for a method to have a checked results sent to a report or word document. Besides that though, i really appreciate your help.

Thank you so much VBAINET. This works great. Besides fixing the coding(which I am sure was a huge hassel), what else did you do? where is subfdatasheet?

Thank you all for your responses. At this point I have this(look at the attatchment). vba, i took a look at the db but couldnt quite figure out what to change of mine that would make it work.

and one major problem is i dont have any relationships so I cannot simply do a sub form to get the data because it requires there to be a relationship.

Thank you vba. At this point I have Option Compare Database Option Explicit Private Sub btnClear_Click() Dim intIndex As Integer ' Clear all search items Me.txtquestion = "" Me.txtanswer = "" End Sub Private Sub btnSearch_Click() If BuildFilter = "" Then Me.sub.Query.RecordSource =...

Hi, my name is Robbie and I was hoping someone could help me with some VBA programming on Access. I would like to have a search form where I can enter data in a box and click a search button to search all of my queries to find any like terms. Here are the specifics: I have a couple of tables...