Recent content by rcdugge

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.