Search results

i have 60 fields in this table ... i was wondering about the limit. i'm constructing family history, where each person can have <=10x-Sisters, <=10-brothers, =<4x-Spouses, =<10-Sons, =<10daughters + parents and grandparents maternal and paternal. thats where the high number, it's not...

what is the maximum number of fields can a table in MS access 2003 hold? thanks :)

working like a charm, thank you :D

thank you HTH :D i used this now: Me.Brother1.Visible = IIf(Me.BrotherS >= 1, True, False) Me.Brother2.Visible = IIf(Me.BrotherS >= 2, True, False) Me.Brother3.Visible = IIf(Me.BrotherS >= 3, True, False) Me.Brother4.Visible = IIf(Me.BrotherS >= 4, True, False) Me.Brother5.Visible =...

(1) What characters i should not use in Fields names, as i realized when working with VBA some characters are not recognized and substituted with (_)? (2) is it ok if i add underscore (_) in table's and form's names? (3) any hints about naming? like for a text box field we use txt (4) any...

ok it's working now Private Sub MyDropDownBox_AfterUpdate() If Me.Mytextbox = 8 Then Me.Mytextbox.Visible = True Else Me.Mytextbox.Visible = False End If End Sub but is there a trick to write less code for a mass of visible txtboxes. thanks :)

i have a field with a dropdown menu of 0-10 i would like to do this: if i choose 3 for example, i get Field1, Field2 and Field3 to be "visible" in the form. i am trying to use the IIF statement but with no luck so far. can someone help me please? thanks

I thought about doing this: on form close / or command button "next" click The code loops/checks for true values and open the corresponding forms respectively Does that make sense? if it does can someone translate this into VB code please? or tell me where to read about it. i'm fairly new to...

glad to know, i spent an hour trying to figure it out. :rolleyes:

Pat Hartman i actually have a foreign key from table_A in table_C... are you saying there is no need for this key as long as table_B in between i.e is it better to remove it? thanks

can someone help me with this please. Forms used: (1) Main form - contains words say for example A/b/c/d/e/f/g - these words can be of "true" value either by check box or drop down menu (2) Other forms - each word (in the main form) has a full form. What i am trying to do is, when the...

hello, i am new to this and i appreciate your help. if table_A is related to table_B (1-to-many) & table_B is related to table_C (1-to-many) Do i have also to relate table_A to table_C? or it is related by default? thanks P.S table_C has both table_A and table_B primary keys as foreign keys.

hello, i have a field called "Priority" with items in drop down menu: Low Normal High my question is how can i make the word "High" appear in [Red] ? thanks