Search results

coryt: I got it pasted in and the questions don't show up in the subform. I've been messing around with it and then got your last note. I downloaded yours and see the questions aren't showing up there either...??? Any ideas? Thanks, Rhonda

coryt: At the risk of sounding like a complete idiot...I need a little more help. How do I set the subforms record source to all of that? I tried clicking on the 3 little dots next to the drop down arrow for the record source thinking I was going to get the expression builder but instead...

I've tried and tried and can't get this straight in my head. I have 3 tables; tbl_questions, tbl_surveys, tbl_results. I have a nice form with a continuous subform. The form has 5 subjects from tbl_surveys, the subform contains all the questions from tbl_questions and also option buttons for...

I haven't got it working yet, but thanks for your help!!

I have a subform in a continuous form, the subform contains an option box (Yes, No, N/A). When I open the form and select one of the choices all of the questions show the same choice. What can I do so that each question can be answered separately. Thanks!

oops! forgot the file

It works I got some help from the programmer down the hall and it works the way it's supposed to. It isn't done the way you suggested but I thought you might like to see it in action. She tells me that any addition fields that may need to be added in the future can also be done with delete...

If you want to look at the changes in my database, it's attached. I think I have it normalized correctly, but now I'm having trouble getting the queries to work. I've been playing around with the nested iif statements and it's not working. When I tried to change it to this...

Well, I think I've finally got some circuits firing in my old muddled brain. I have incorporated all of these choices into one field by duplicating the lines of text and changing the selection. I was thinking that I could now rewrite my query with the same set of iif statements but changed...

Okay, I've built this new table named tbl_selection (I already had one named tbl_codes). But some of these items can have more than one selection. I'll try to answer your question on what this table that needs to be broken down is for. End users want a check list that they can print out...

This time I managed to compact my database and get it attached. (hmmm...I think) The reason for doing so, is that I am trying to understand normalization. I've done a little reading, but I've never heard of normaliztion before today. Should I create more tables? The queries are based on...

I have a query which has 14 fields that I need to query. That was 5 too many, (for the maximum of 9) so I split the query up and ended up with two. This wasn't such a good idea. Now my data starts over instead of being one continuous list. For example topic one, two, five, seven, twelve...

Fantastic!!! Thanks a million! I'm so happy I could dance a little jig, just like your visual boogie dude! Thanks again, Rhonda

I found it in tools/database utilities/covert database/to prior access database version. Thanks, Rhonda

I hope I did this right. You said a stripped down copy of A97 but I have 2000. I removed everything in this copy of the database but the form. If that's not what you wanted let me know. Sorry this took so long, I've been out of the office. Rhonda

Reset option groups if option is changed If I can explain this so that you can understand it, then I'm one step closer to sanity! I have a form which contains 5 option groups. In the second group if you choose culvert or repair, then you are done and may select a command button to generate...

Thanks for the info from you both. (I ended up changing my check boxes to text boxes, it was the only way I found to make them white on the inside) plus turning off auto-correct did the trick! Thanks again! Rhonda

I have a few issues on a report that I'm having trouble with. This report will be printed out and filled out by hand by various users. I have check boxes on the report. The inside of the box is gray. Can I remove the color, so that it's white? This report is set up to be landscape. When...

Thanks for your help.

I would like to separate information in my report with vertical lines. The problem is that each line of information is of varying size. Some are 1 row and some are 5 or 6. I tried drawing in a line but it only covers a portion of the larger entries. Is there some other way to accomplish...