Recent content by ootkhopdi

Thanks arnelgp and same to you and your family.. one more question May i got Text box 12 value =DLookup("[Me.combobox1]", "Datatable", "[Combobox2] =" & Forms![Details]![Combobox2])

Thanks arnelgp it works fine..

Thanks to All for helping me. now i get another issue, if i select a field in combo box 1, then how can i get all values of field in table like. if i select Name field in Combo box 1, then all values of Field "NAME" should be displayed in Combo box 2. Thanks once again to all

Hi I want to create a drop down table field in access form, in this list values should be Column headings of a table/ query. like this if table A column titles are Name Post School then list items should be Name,Post,School. if i add one more column in table i.e. class then it...

Some one there for help me?? How can i filter different value records in diffrent fields..?

Hi All I have a data base , i have little knowledge about access. some posters are tell me about data base normalization., they give me links to read about this, but i cant under stand, what is this?:banghead::banghead: So can some one tell me about this. in simple steps. or in my...

Thanks to Both , "Plog" and "The Doc Man". both of you , give me good ways, now i try your suggestions. hope in future like this, i got your guidance .. thanks once again.. Can i talk in other language as my language is HINDI..

Hi. All I have a database with more than 100000 records. this data belongs to about 5000 employee with last 10 years..so it is so huge.due to this big data , when i run any query , it runs too much slow. so i want to break this data into 3 or 4 tables. But i want , when i want to search or...

Thanks to All.. i have done it with a form "Update value", i create a combo box with query unique id ,a text box for update values, and a command button with update query.. i do it ..thanks all to give me replies..

i think there is some confusion let i try to more clear my problem 1- i have a table with 10000 records with 10 fields , Main Fields are IDs and Value 2-In Table Values of Ids are different like my example. ID Value A W B X A Y C...

Thanks Ridders but there is a problem as i tell me in my post. i have more than 50 ids which values are containing or equal to "W". In your suggestion , i can update one or two ids , but i want to update all ids which in a table or query. please tell me how can i do.. thanks once again

Hi i have one table having IDs like this S.No. ID Value 1 A Z 2 A Y 3 B X 4 C W 5 A W now i create a query which having unique ids and value filtered=W now result in query is Id...

Hi, i have a table with 15 fields. In this table there are two fields ID value 1 A 1 B 2 C 3 D 2 A 2 B 4 A 5 A Now i want to select Ids which having more than two distinct values ID Value 1 A 1 B 2 A 2 B 2 C...

hello.. when i m using an select query to my data base . it runs too much slow.. it takes hours to complete function.. my data having app- 100000 records.. please tell me how can i run it faster ... without break my data into other tables... thanks

i have a table which having a large number of records.. i want to change Name field data into Proper Case i can do change data in upper case by field format ">" or in lower case by "<" but how can i change into proper case .. i dont want to create an query to change data in proper case...