Search results

Let me explain it again i guess then. So I have a table in Access that I have been filling out using a word document. for the most part, the two fields(columns) that i have been filling out are just text. The name of the fields are questions and answers. The problem is one of the answers in the...

i was curious if somehow I could put a Microsoft Word table into ONE cell in a table. Or if that was not possible, how to make it a picture. If that is not possible either, any other suggestions would be great.

btw, you have helped me so much. i really appreciate it!

the only additional thing would be could the words you search show up above the items you selected? i know that would be a tough one.

ooooo. do i need another field then. So the include? field has checkboxes. however, the TYPE of field it is is yes/no. i havent solved the problem yet. bascially after doing the search, I would like to check off the box and click the add button which I would like to add to the report. then, for...

right. the name of the field that has the yes/no is Include?. so what would the docmd statement look like if i want the row to show up on the report which contains a checked box in the include? field. I still do not understand. is val(nz(me.answer, yes)) wrong? should it just be me.yes? This...

I dont know what I pushed, but the search and clear button have stopped working too. sorry.

as -1, it does not affect the report at all and there are no changes, but rather it prints the report which as all of the data on it

When I have DoCmd.OpenReport "qrysearchreport", , , "[Include?]= " & Val(Nz(Me.Answer, Yes)) an error comes up that says variable not defined. yet it is a yes/no data type

I have changed it to DoCmd.OpenReport "qrysearchreport", , , "[Include?]= ' " & Val(Nz(Me.Answer, 2)) &" ' " it is a yes/no datatype. since it is a yes/no, would the val(nz(me.answer, "yes"))?

what i have now is DoCmd.OpenReport "qrysearchreport", , , "[YesNoFieldName]=" & Val(Nz(Me.Answer, 2)). how come the filter doesnt work?

I have a search form which provides data and has a field yes/no check box. I also have a button "include" on the form which when clicked w any fields with a checked off box, will be sent to a report. However, I am having trouble doing this. I have tried using vba and for the button in the form...

vbaInet, I decided to go along with your suggestions and combine all of the questions and answers into one table with a company id in another, along with a query. I appreciate the help. The final step in this database would be after the include button has been clicked for it to be sent to a...

Sorry about that VBA. Right now the db has 10 tables, each with about 30-40 questions and answers. I still need to enter in the next 5-6 tables but just havent started since I want to get this done first. I can only see the 2nd link because the server I am on is blocking the first one. So to...

In the real database, there are probably going to be more like 15-16 tables and growing. Everything else for the most part should stay relatively the same.

How would you suggest I go about it? Could i make a subtable feed into a table and then just replace the query with the table? i am not sure how exactly a right join works and i could try figuring it out BUT would it require more work and reformatting than just creating sub tables(if that is...

ok, i put that as the code. it is still not working and not only that but in that awesome form that we created where we could look up certain criteria, you can no longer check it off.....only in the table can you check it off. i have the db down below

vba, i did as you said and added a yes/no field name in both tables and then with the check boxes in the form, put their record source as the field in the table(labeled "Include?"). however, in the union all query it still shows up as either 0/-1 .

ok. sorry vba. well Answer is the field that has the answers of the questions which were part of the data set. Therefore, i should change me.answer to me.yesnofieldname since that is the fieldname that i named it. however, in the query, the boxes are not there. only in the forms because that is...

(sorry i am not getting this. it must be frusterating. a little too advanceded for me)