Search results

Hi, I am not sure how to design my response form for a survey questionnaire database. At the moment I have "ResponseText" and "CommentText" fields that are used to store answers. The problem is each questions have different type of answers: select one from the list or the user types the...

Thank you, your help is appreciated.

Thanx Ken for the reply and for the help. I have attached a screen shot of my tables, fields and the relationship. I hope I've done it right.

Yes Ken I did, I got about 28 results. Some of them were very identical to my prob and very helpful, but none of them gave me the answer or a idea for the last part of the prob.

Hi guys, I need help with setting up my tables and relationship for a questionnaire type of database. Basically there are two questionnaires that are conducted; one is completed on the day of the treatment and another one after the treatment on a later date. Both questionnaires have 13...

Heres is the code, I get the following compile error: Method or data member not found. I think it is not recognising my fields. This code is in the main form (frm_allSlideDetails) and the fields are in the subform (subfrm_slideDetails) Private Sub addRecord_Click() On Error GoTo...

The disabled fields vary, each record has different fields which are disabled so whatever the state of the last record I viewed, it will have those disabled fields when clicked add new record.

Thanks for the reply. I forgot to say, the add new record button is on the main form and the fields that I want to be enabled are in the subform. I am newbie so am sorry for asking a such stupid question, what dou you mean by the controlname - am I suppose to put the name of the button there...

I have a subform which disables certain fields based on the value entered. The problem I am having is that when I click on add new record, the form stays in the last state with disabled fields. Basically I want all the field to be enabled when add new record button is clicked. I hope it makes...

Its ok guys, I solved it :) Thanx anyway Solution: Private Sub panelName_AfterUpdate() If Not IsNull(Me.panelName.Value) Then Me.openSubFrmPanelMembers.Enabled = True Else Me.openSubFrmPanelMembers.Enabled = False End If End Sub Private Sub Form_Current() If Not...

Same prob :(

Didnt work, the button stays disabled all the time.

Hi guys, just registered, very nice with excellent info forum you have here. I aint that good with databases but am getting there slowly :) I have a problem, was wondering if you guys can help? Here is the prob: I have a button called openSubFrmPanelMembers that loads up a form when it is...