Search results

Thanks Pat...good ideas.....apparently Bridge players really do know all the tricks!

Thanks Pat, per usual, your answer is clear and precise and helpful. I was able to make a start using both Doc's and your replies. The only question I have left is: would you agree with Doc'x suggestion regarding using the append query to add 52 records to the tblPersonAnswers table upon...

Thanks Doc for your reply. You are correct: Every question has the same choices and will never change and all of them must be answered. I agree with the option group idea and that is what I have planned to use. My original idea was to create a table like this: ID Answer1 Answer2 Answer3...

Another Survey Question I am designing a database that stores results for medical record audits. Each record is scored using 52 criteria with possible answer: Yes, No, or Not Applicable. The final score is calculated on a formula that I will have in a calculated field in a query. I have...

Thanks for your reply Pat. I honestly don't know what the hell happened. But no I did not place them on top of each other. Even when I tried to put both subforms next to each other NOT using a tab control, sometimes when I switched from design view to form view the second form would turn into...

I have a main form with a subform. The subform has 2 subforms that I am trying to put on a tab contol (2 tabs). I am able to add the tab control and then the two subforms and set up the child/master links but when I go to view the main form, I get parameter errors and when I go back to design...

This may be a dumb question but I ain't proud: ;) Can you calll a function from a module in a calculated field of a query? I have found a wonderful sample on this site that calculated business days but it is used in a form and I want the same function but in a calculated filed in a query. Is...

Thanks for your replies up until now. Your reply before your last one gave me an idea that may be easier than what I am trying to do now. So for now let's just drop this thread. I am going to work on the record source idea. Thanks again!

Sorry for the confusion. I was trying to keep it simple as possible. The main form displays a physician name. the subforms (there are 2) display audit scores based on the physician number. this is the child/master link for most physicians. Some physicians however, belong to a group. If they...

Right. No I do not change the record source. It stays the same throughout. Thanks

Not sure I understand your question. The coding I use to change the Child/Master Link of the sub form is in the main form's Current event. Could this be the problem? The pop up msg asking for a parameter appears when I go from one record to the next record on the main form. I am not sure...

Yes I did and I got a pop up box that displayed the field contents in the message and a blank box asking for a parameter.

Yes...just got into the office..I do still need help..thanks :)

I need to know how to write the vb code for changing the Link Childs/Master properties for subforms. I have searched the Help files but not much "help"! I have a form with 2 subforms. I want the Link Childs Field & Link Master Field properties for both subforms to be triggered by what is...

Whew! I think Mike could have redesigned and recreated an entirely new database in the time he has spent defending the one he has currently! And it would have been time much better spent because believe me, if he tries to convert it, it is going to crash big time! Good luck! This thread has...

I tried using your exact code on a test form with one text box and the button and it worked fined. Perhaps there is some other code in your form that is causing the problem???

Yes I tried that with your version however, it still will not reset the focus ...without the err routine the same error in my original post (2108) comes up. However, I can live with the fact that it cancels and clears the date field. Thanks for you replies. By the way Pat, I read a thread...

Thanks for your reply Pat. The problem with putting it in the BeforeUpdate event of the form is that the user has to be allowed to edit the form perhaps many times prior to entering the date. The date field is only entered once the transaction is completely finished. If I put the code in the...

I have a form with a date field the user completes upon completing the form. I want them to check one of the check boxes in a section on the form before exiting. I cannot put this procedure in the form's BeforeUpdate event because the user must be allowed to edit the form several times prior to...

we may have just done this. check this thread: http://www.access-programmers.co.uk/forums/showthread.php?t=66601 Not sure if this is how you display a thread or not. hopefully will help you.