Recent content by engineer

your question is not clear for me but I remind you that you can make search with many criteria say you can search about certian item in the inventory and its price more than certian value Are You ask about that ?

your title is " VBA or query " if it refer to which of them response the error the answer is the query. your error in the query and relationship in fact I tried to understand the relation between tables but I can't know by trial and error the solution is : go to the query "Qry_Rpt_02" in...

the code which used in form2 for show the data in combo is SELECT [tblPersons].[PersonID], [tblPersons].[PersonName] FROM tblPersons; which mean showing only the data from another table but I want show the data from to field to add it in another field , is it clear ? remember that my...

Thanks mr.boblarson for your interest but I am so sorry your example is so far than what I ask about I don't need any relation between the tables only I want data from one field is loaded in another field combo because I want preventing users from entering any data in this field only choose...

Thanks mr.boblarson for this orientation and for good link let me ask again with the right questio How can I load combo in form of table A from table B for more details I have table A ( Id - Name - Phone - Address ) which contain the personal data of every customer to permit connections...

I tried but not success when I make a relation between table and query , not appear the type of relationship it was not active for choosing

I have table A contains many data about persons I have table B which has a combobox in the field of Name I want to load it with the names of persons from table A can you help me ?

I am so sorry for my wrong answer when I wrote it , I was n't try it. but I understand your idea very good but I can't know the solution sorry for interruption & confusing

I ask about reference learning that in general not specific topic I love Access & Visual Basic6 but I not strong

1- add new field in customers table and make it primary key if you have previous primary key , you will make two fields primary key 2- add the same field in products table and don't make it primary 3- make relation one to many between them and you will display all products table in the...

for learning the benefits of unfreeze option but I found that it's make no thing thanks for reply

thanks mr.David for this super link how can I understand all codes written in the button ? what the reference for begineers from beginning to such that ??

1-You can go th the design view of your table and select the field which you will insert time on it. 2- make data type is lookup wizard and add all times which you want it is weak way but easy

when I make any field freeze , it became the first one in the table and when I make unfreeze , it still in the first and not go to its position why ??? Am I make it with wrong method ?

why ?????? you can make combo box for any field and add all products on it . why you want all table appear in the another table?? you should appear the products which each customer is purchased and that's good and is one to many relationship