Search results

thanks for the reply doc man in my relationships window the AddressID has a 1 by the way this address is the PK for the Address table and is an autonumber. And the AddressID on the Person table has the many sign and is a number field and not a PK. My Address table has duplicate addresses. with...

Hi here is my question, and before someone says to search the forum, i did and can't find the answer... so i'll give it a shot with this thread I have 2 tables. 1 has personal data: name, birthdate, sex... called tblmemberdata 1 has contaact data: address, phone #'s... called tblmembercontact...

i tried that... most of the posts i found were not answered completely. the colsest i found was creating an index... is this the most effective way? thanks for the help

that's the thing it's not there. in the field list the RFC isn't there. the form is composed of fields from 2 tables (personal data: tblmemberdata and contact information: tblmembercontact) that are related through the PK from both (autonumber) fields. not sure if that is doing something thanks

ok i have a tblmembers and a tblmembers form. i created it and everything works fine. now after doing all that, i need a new field called RFC, that I added to the my tblmembers. When i open the tblmembers form. in the field list i can't see the RFC field. i can't add it. thanks

ok here it is i have a database for members. i have a table with the general info for the members like name, date of birth, that kind of stuff. i want to know how i can make sure that there are no duplicate members. when in the form.. how can i validate that the member isn't already there? the...

this might be an easy question, but here it goes i have a table, and i made a form that is related to this table after i update the table, for example i added a field, now i can add the field in the form. is there any way to update the form with the new changes from the table? thanks:o

sorry that table came out wrong... it should look like this Key---- Member ID -------Relationship ----------Member ID 1-------- 245------------ father---son------------- 246 2 --------123--------- grandpa--grandson---------- 345

thanks everyone for your help.. i'm finding the time to read those articles... ajetrumpet: thanks for the reply. by family relationships i mean: my db is for members (tblmembers), that contains normal member info, like name, address, b-day, etc... i need to establish when some of these members...

i understand normalization is something that you get trained with after working for a whilie with databases i have a member db and i made a table for the country,state,city,zip this tale is used by other tables like the member info. how far does the normalization go? should i make a table for...

thanks for the reply... the reason i have 2 fields of the same thing, is because of what i was thinking to solve my relations problem... i need to establish family relationships. i thought by making a table with the type of relationship and a table with 3 fields the 2 members of the...

hi :D here is my question: i have a table (tblmembers) with member data (name, last name) etc. i found how to run a search qry with parameters to ask for name, last name. i have another table (tblrelationships) with 3 fields 2 for member id's and 1 for the type of relationship they have i...

thank you very much it works perfectly i really appreciate it

thanks for the reply i tried the lines: strSQL = "INSERT INTO tblLocalizacion ([Pais], [Estado], [Ciudad]) " & _ VALUES ('" & Me.PaisNac & "', '" & Me.EstadoNac "', '" & NewData & "'); it says bad expression on the first ' (single cuotation)

This is the Code I'm using for a notinlist event. I know it works Private Sub cboCity_NotInList(NewData As String, Response As Integer) On Error GoTo coboCity_NotInList_Err Dim intAnswer As Integer Dim strSQL As String intAnswer = MsgBox("The City " & Chr(34) & NewData & _...

This is the Code I'm using for a notinlist event. I know it works Private Sub cboCity_NotInList(NewData As String, Response As Integer) On Error GoTo coboCity_NotInList_Err Dim intAnswer As Integer Dim strSQL As String intAnswer = MsgBox("The City " & Chr(34) & NewData & _...

just thought i'd post this. i found the answer... in case someone else comes to the same problem. i made a query that takes the values from the table with the countries/states/cities SELECT DISTINCT locationtable.[countrycolumn] FROM locationtable ORDER BY locationtable.[countrycolumn]...

hi hope someone can help. I'm making a form to select country/state/city for members i made a table with 3 columns country,state,city i wrote down the states for 2 countries (the ones i'm gonna use) the city is left blank (since i don't want to write down all the cities just yet) i'm looking...

ajetrumpet: thanks a lot... those were a big help!!!!! :D :D

could not find any help for that on the ms access help... any ideas where i could fin a little more elaborate help for that?