Search results

ughhh is that only way? I have already made so many lookup fields... dam it

Hello, I have been looking for ways to make a dropdown menu in the form to show a option while recording number into the table, for example, to show (Yes, No, Don't Know, Missing data), and to record 1,2,3,4 in table respectively. Some people said do the lookup field and do 2 columns with 1...

NICEEEEEEEEEEEEEEE Thank you! It worked!

I put the code and modified the code (for names), so it would look like this, Private Sub TUGUnable_Click() If Me.TUGUnable = "True" Then Me.TUGTrial1.Visible = False Else Me.TUGTrial1.Visible = True End If End Sub However, it does not make TUGTrial1 visible or...

How would I make them disabled? Also, Where am I putting those codes? Sorry I am kinda new to all these...

Thank you! Also, can I make it disabled, rather than invisible?

hmm do i still use True and False for checkbox?

I would imagine that I will have to use codes, but not entirely sure how I would do this. Also, is it fine to use yes/no fields? or is it better to just have combo box with 1 and 2 to meet yes/no?

Hello, How do I do that on the form?

Hello, I see you have put in a lot of work on this. Thank you. First of all, when I try to make new record by clicking next arrow on the bottom, it gives me "runtime error 3061 too few parameters. expected 1. Also, is your design supposed to have multiple subforms for every questions I have...

Thank you for all the suggestions. I will actually read up on normalization and stuff and come back if I still don't see what to do..

Oh wow. Yes I see what you mean now. I get to make some progress haha. Thank you very much!! But one thing is, After I type in the subject ID into form 1-3, and then move onto next form (4-6), the subject ID section on that form is blank. Is there any way to link them so that it would...

could you elaborate for me? how would I make a use of the data that I have entered into the form if i turn off the data entry to no?

First, I will be manually interviewing participants with long questionnaire. Then, wit those responses I have got, I need to enter those data into the database I am creating right now. However, the problem is, the questionnaire is super long, so that I am running out of fields to have them in...

I see what you mean.. So I need questions ----> responses by respondent <--- respondent. however, same question still remains, as my questions are definitely more than 255 fields, which means I would need more than 1 table for the "questions" table. How do I link them? Also, what I am trying...

Thank you. But I kind of need to get this working before I go to sleep tonight though... Well ugh... But the thing is, when I just bluntly types in the same subject ID (such as 1234) into both forms, it still will give me "you cannot add or change a record because a related record is required...

or do I need separate form?

Why is it giving me this "you cannot add or change a record because a related record is required in table" error?

Here it is...

I am not sure what you mean by separate record?